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 Log
Files
Database Manager CLI, file_getfirst
Database
Administration in CCMS: MaxDB, Logs and Messages
Database
Administration in CCMS: SAP liveCache Technology, Logs and Messages
Kernel Logs
File Name |
Directory |
File ID |
Description |
knldiag |
Run directory of the database instance: <independent_data_path>\wrk\<database_name> (see Glossary, Run Directory) |
KNLDIAG |
Current kernel log of the database instance Contains all kernel messages (error messages, warnings and information) See also the special database parameter KNLDIAGSIZE |
knlmsg |
Run directory of the database instance |
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 |
knldiag.err |
Run directory of the database instance |
KNLDIAGERR |
Error messages and start messages of the kernel since installation |
knldiag.old |
Run directory of the database instance |
KNLDIAGOLD |
Last kernel log (before the last restart) |
General Log Files
File Name |
Directory |
File ID |
Contents |
<database_name>.pah |
<independent_data_path>\config |
DBMPAHI |
History of the database parameters |
<database_name>.prt |
Run directory of the database instance: <independent_data_path>\wrk\<database_name> |
KNLTRCPRT |
Text version of the database trace |
knldump |
Run directory of the database instance |
KNLDUMP |
Memory dump after a database crash |
knlmini.dmp |
Run directory of the database instance |
- |
Only for Microsoft Windows Memory dump after database kernel crash (for postmortem debugging) See the support database parameter MINI_DUMP |
knltrace |
Run directory of the database instance |
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. |
MaxDBInstanceCreation_install-<date-ID>.log |
<independent_data_path>\wrk |
|
Log of the software installation See Installation Manual, |
rtedump |
Run directory of the database instance |
RTEDUMP |
Latest values of the runtime environment of the database instance |
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. |
Run directory of the database instance: <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 |
Run directory of the database instance |
Database Manager Log Files
File Name |
Directory |
File ID |
Contents |
dbahist.prt |
<independent_data_path>\wrk\<database_name>\dbahist |
DBAHIST |
For SAP systems only Log of the database administration activities |
dbm.ebf |
Run directory of the database instance: <independent_data_path>\wrk\<database_name> |
BACKEBF |
Only for backup tools from other providers Backup history, includes backup IDs, external backup IDs and error messages If a backup tool successfully executed a backup but could not determine the backup ID, it enters the backup as failed in the backup history. |
dbm.ebp |
Run directory of the database instance |
BACKEBP |
Only for backup tools from other providers The log of the last backup |
dbm.ins |
Run directory of the database instance |
INSTPRT |
Log of loading/updating the system tables |
dbm.knl |
Run directory of the database instance |
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. |
dbm.mdf |
Run directory of the database instance |
BACKMDF |
History of the backup templates used for the backups |
dbm.prt |
Run directory of the database instance |
DBMPRT |
Log of the DBM Server Contains all administration commands sent to the DBM Server |
dbm.utl |
Run directory of the database instance |
UTLPRT |
Contains administration commands sent from the DBM Server to the database kernel |
dbmsrv_<database_computer> |
<independent_data_path>\wrk |
DBMSRV |
Instance –independent log of the DBM Server |
dbmsrv_<database_computer>.dmp |
<independent_data_path>\wrk |
DBMSRVMINIDUMP |
Memory dump saved by the DBM server in case of a crash Contains stack and memory segments Can be used for post-mortem debugging |
Loader Log Files
File Name |
Directory |
File ID |
Contents |
loader.log |
<loader_appplication_data>\log |
|
Log of the Loader |
loader.log |
<independent_data_path>\wrk |
LOADER |
Loader server log |
loader_<timestamp>.log |
<loader_user_data>\packages |
|
Log of the Loader in transport mode |
transport.log |
<loader_application_data>\packages |
|
Transformation history |
See also:
Loader, Log File, Transformation
History
X Server Log Files
File Name |
Directory |
File ID |
Contents |
xserver_<computer_name>.prt |
<independent_data_path>\wrk |
XSRVPROT |
Log of the X Server |
xserver_<computer_name>.old |
<independent_data_path>\wrk |
XSRVPROTOLD |
Last log of the X Server |
Database Analyzer Log Files
File Name |
Directory |
File ID |
Contents |
DBAN.prt |
<independent_data_path>\wrk\analyzer |
ANALYZER#\DBAN.prt |
Logs of the Database Analyzer |
DBAN.inf |
<independent_data_path>\wrk\analyzer |
ANALYZER#\DBAN.inf |
Status of the Database Analyzer |
DBAN.err |
<independent_data_path>\wrk\analyzer |
ANALYZER#\DBAN.err |
Errors of the Database Analyzer |
Other |
|
ANALYZER#\<date> |
|
Event Dispatcher Log Files
File Name |
Directory |
File ID |
Contents |
dbmevtdisp.prt |
Run directory of the database instance: <independent_data_path>\wrk\<database_name> |
EVTDISPPRT |
Log of the Event Dispatcher |
Synchronization Manager Log Files
File Name |
Directory |
File ID |
Contents |
Your choice Defined in the file MSGSERVER.XML |
Your choice Defined in the file MSGSERVER.XML |
- |
Log of the message server |
See also:
Installation Manual, Directories