Start of Content Area

Procedure documentation Checking the Database Message Log (Informix)  Locate the document in its SAP Library structure

Use

You can use the detailed database analysis in the SAP/Informix database monitor to check the database message log file. This log file is used by Informix to record major events such as system startup and stop, archives, backups, checkpoints, log file full situations, and major errors (for example, hardware errors causing a chunk to go offline).

Note

The interface to the database message log, which is written to a local file system on the database server, is implemented through infstrfc (only when there is no application server running on the database server).

Procedure

  1. Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu ® State on disk ® Database Message Log.

    2. The system prompts you to choose between Only Alerts and All Messages.

  2. Choose All Messages normally. However, if you want to filter out the message Checkpoint complete, choose Only Alerts. This message is useful for checkpoint tuning.

 

See also:

Listing System Information with SAPDBA