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, Logging

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 log files

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:

Traces

Monitoring

Troubleshooting

Installation Manual, Directories