Ques 1.) Which log files does SAP MaxDB generate?
The log files that SAP MaxDB generates are described in the documentation.
Ques 2.) What information do the KnlMsg* files provide and when should I use them for analysis?
The KnlMsg* files, also called database messages, contain the error messages from the database kernel.
The database messages do not contain any SQL error messages, for example, like those that the application raises as the result of an SQL statement. The KnlMsg* files are your starting point for every error analysis.
Ques 3.) Which information does the dbm.prt file provide and when should I use it for analysis?
The file "dbm.prt" is the database manager log file. It is located in the run directory of the database. This file contains the administration commands for the DBM server. In addition to the information messages, it also contains the return codes of the commands and error messages that have occurred on the DBM server.
The file "dbm.prt" helps you to analyze problems related to the following:
- Add/remove volume
- Changes to the database parameter configuration
The run directory is located at /wrk/ . You can determine with the command xinstinfo .
The file "dbm.prt" is an ASCII file that is overwritten cyclically.
Ques 4.) What information do the RTEMemory_chunk* files provide and when should I use them for analysis?
When you start the database kernel, shared memory segments are created for the database console (XCONS) in the form of memory mapped files (RTEMemory_Chunk. files). The files are cyclically synchronized.
In the case of a database crash, the current content of the memory segments is synchronized with the memory mapped files. The RTEMemory_Chunk files enhance the analysis options after a database crash.
The RTEMemory_Chunk files are located in the run directory, in the subdirectory rtedump_dir .
The RTEMemory_Chunk files are not ASCII files. The SAP support team can evaluate them using the postmortem console ( x_cons -p ).
Ques 5.) What information does the file "rtedump" provide and when should I use it for analysis?
The database kernel generates the file "rtedump" when a crash occurs.
The file "rtedump" is located in the run directory of the database. When you restart the database, the system copies it to the subdirectory DIAGHISTORY/ .
The file "rtedump" contains the data of the database console command x_cons show all and is an ASCII file.
You use the file "rtedump" along with the database messages (KnlMsg* files) for analysis purposes after every database crash.
The KnlMsg* files record the database task that triggered the crash. You use the information from the KnlMsg* files to analyze the file "rtedump".
You use the data from the file "rtedump" in the OLTP and BW environment to determine the corresponding SAP work process trace (developer trace).