July 15, 2009 at 3:38 am
Symptom
B*TREE BAD INDEX 865672 (ROOT) in the knldiag.err since the software upgrade to Version 7.3.00 Build 27.
Other terms
Bad index, performance problems Performance problems;
Reason and Prerequisites
Problems may occur with the database indexes in Versions older than 7.3.00 Build 25. Note 541895 contains more detailed information.
The affected indexes are deactivated as of Version 7.3.00 Build 27 (they [...]
July 13, 2009 at 6:13 am
Symptom
This note lists known problems that occur in connection with the security settings of the files reg_info and sec_info. If required, this note also refers you to other notes that deal with a particular problem. For general information about using these files, read Note 1069911 in addition.
1.) Entries for HOST and USER-HOST [...]
July 12, 2009 at 2:36 am
Symptom
This note describes the needed MaxDB database log files that ByD Support has to add to a ByD customer call when you have MaxDB database problems.
These log files are the precondition that SAP MaxDB Support can start any database specific analysis.
Other terms
MaxDB; ByD; Log Files; knlmsg; knlmsgarchive; rtedump; database analysis;
Reason and Prerequisites
You are having [...]
July 7, 2009 at 3:28 am
Symptom
This note is an overview note about problems with the database analyzer. It lists notes that are often helpful if you experience problems with the database analyzer. This note briefly describes the contents of each of these notes.
The list does not claim to be conclusive or complete.
Other terms
DbAnalyzer, database analyzer
Reason and Prerequisites
Problems with [...]
June 29, 2009 at 3:00 am
Symptom
What must I bear in mind during the system switch upgrade if I am using “database links” as described in Note 25383?
Other terms
Database link, synonym, PARMVNT_SHD, system switch upgrade
Reason and Prerequisites
Errors will occur during the system switch upgrade if you use the “database links” defined in the ABAP Dictionary.
Since the objects in the ABAP dictionary [...]
June 14, 2009 at 8:49 am
Symptom
Despite being correctly configured (parameters, statistics, …), the Oracle Cost Based Optimizer (CBO) or Rule Based Optimizer (RBO) chooses an unsuitable access path for an SQL statement, and this leads to an unnecessarily long runtime.
Reason and Prerequisites
There are several possible causes of long SQL statement runtimes. This note also describes those bugs [...]