Log Files 
Use
The database system, database tools and interfaces write information and error messages in log files. Most log files are text files that you can read with a text editor.
Exceptions:
· Binary log files
· Log files that are only generated by the database system when requested by a user
To display the contents of such log files, use the Database Manager database tool, or the CCMS in SAP systems. You need the file ID of the log file.
Note that file IDs are case-sensitive.
See:
·
Database Manager GUI, 
Reading Database
Files
·
Database Manager CLI, Opening a Database
File
·
Database
Administration in CCMS: MaxDB, Logs and Messages
·
Database
Administration in CCMS: SAP liveCache, Logs and Messages
For more information about the most important database directories, see Directories. For a list of the variables that are used for directory names in the documentation, see Variables and Examples.
Kernel Logs
File Name |
File ID |
Contents |
Directory |
knldiag |
KNLDIAG |
Current kernel log of the database instance Contains all kernel messages (error messages, warnings and information) See also the special database parameter KNLDIAGSIZE |
Run Directory of the database instance: <independent_data_path>\wrk\<database_name> |
knlmsg |
KNLMSG |
Detailed current kernel log of the database instance Contains all kernel messages (error messages, warnings and information) You can use the Database Manager to display more information about the messages. Pseudo XML file |
Run directory |
knldiag.err |
KNLDIAGERR |
Error messages and start messages of the kernel since installation |
Run directory |
knldiag.old |
KNLDIAGOLD |
Last kernel log (before the last restart) |
Run directory |
General Log Files
File Name |
File ID |
Contents |
Directory |
<database_name>.pah |
DBMPAHI |
History of the database parameters |
<independent_data_path>\config |
<database_name>.prt |
KNLTRCPRT |
Text version of the database trace |
<independent_data_path>\wrk\<database_name> |
knldump |
KNLDUMP |
Memory dump after a database crash |
<independent_data_path>\wrk\<database_name> |
knltrace |
KNLTRC |
Binary log file of the database trace; can also contain information about the cause of the crash. The database system initializes this file each time the database instance is started. |
<independent_data_path>\wrk\<database_name> |
MaxDBInstanceCreation_install-<date-ID>.log |
|
Log of the software installation See also Installation
Manual, |
<independent_data_path>\wrk |
rtedump |
RTEDUMP |
Latest values of the runtime environment of the database instance |
<independent_data_path>\wrk\<database_name> |
liveCache-specific Log Files
File Name |
File ID |
Contents |
Directory |
lcinit.his |
LCINITHIS |
History of all start, stop and initialization actions in the liveCache. Information from the log lcinit.log is attached to this history. |
<independent_data_path>\wrk\<database_name> |
lcinit.log |
LCINIT |
Information for starting, stopping and initializing the SAP liveCache with the CCMS function of the SAP system |
<independent_data_path>\wrk\<database_name> |
Database Manager Log Files
File Name |
File ID |
Contents |
Directory |
dbahist.prt |
DBAHIST |
For SAP systems only Log of the database administration activities |
<independent_data_path>\wrk\<database_name>\dbahist |
dbm.ebf |
BACKEBF |
Only for backup tools from other providers Backup history The dbm.ebf log file identifies the backup ID and the external backup ID for each backup. |
<independent_data_path>\wrk\<database_name> |
dbm.ebp |
BACKEBP |
Only for backup tools from other providers The log of the last backup |
<independent_data_path>\wrk\<database_name> |
dbm.ins |
INSTPRT |
Log of loading/updating the system tables |
<independent_data_path>\wrk\<database_name> |
dbm.knl |
BACKHIST |
Backup history Contains all backups and restore actions. If no backups have yet been executed or the backup history was interrupted, HITSLOST is displayed. For information about the log files of backup tools from other providers, see the respective documentation. |
<independent_data_path>\wrk\<database_name> |
dbm.mdf |
BACKMDF |
History of the backup media used for the backups |
<independent_data_path>\wrk\<database_name> |
dbm.prt |
DBMPRT |
Log of the DBM Server Contains all administration commands sent to the DBM Server |
<independent_data_path>\wrk\<database_name> |
dbm.utl |
UTLPRT |
Contains administration commands sent from the DBM Server to the database kernel |
<independent_data_path>\wrk\<database_name> |
dbmsrv_<database_computer> |
DBMSRV |
Instance –independent log of the DBM Server |
<independent_data_path>\wrk |
Loader Log Files
File Name |
File ID |
Contents |
Directory |
loader.prt |
|
Log of the Loader See Loader, |
<loader_appplication_data>\log |
loader.prt |
LOADER |
Log of the Loader server |
<independent_data_path>\wrk |
transport.log |
|
Transformation history See Loader, |
<loader_user_data>\packages |
X Server Log Files
File Name |
File ID |
Contents |
Directory |
xserver_<computer_name>.prt |
XSRVPROT |
Log of the X Server |
<independent_data_path>\wrk |
xserver_<computer_name>.old |
XSRVPROTOLD |
Last log of the X Server |
<independent_data_path>\wrk |
Database Analyzer Log Files
File Name |
File ID |
Contents |
Directory |
DBAN.prt |
ANALYZER#\DBAN.prt |
Logs of the Database Analyzer |
<independent_data_path>\wrk\analyzer |
DBAN.inf |
ANALYZER#\DBAN.inf |
Status of the Database Analyzer |
<independent_data_path>\wrk\analyzer |
DBAN.err |
ANALYZER#\DBAN.err |
Errors of the Database Analyzer |
<independent_data_path>\wrk\analyzer |
Other |
|
|
|
Event Dispatcher Log Files
File Name |
File ID |
Contents |
Directory |
dbmevtdisp.prt |
EVTDISPPRT |
Log of the Event Dispatcher |
<independent_data_path>\wrk\<database_name> |
Synchronization Manager Log Files
File Name |
File ID |
Contents |
Directory |
Your choice Defined in the file MSGSERVER.XML |
|
Log of the message server |
Your choice Defined in the file MSGSERVER.XML |
See also: