With the detailed database analysis in the SAP/Informix database monitor you can look in depth at the Informix database for help with advanced monitoring of the database. For more information about the overview, see Looking at the Informix Database Overview.

You choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu to look at the detailed database analysis.

The most commonly used functions are the following:

• Checking Wait Situations (Informix)
• Checking Chunk I/O Activity (Informix)
• Checking Sessions (Informix)
• Checking Table Activity (Informix)
• Checking SQL Statements (Informix)
• Checking Exclusive Lockwaits (Informix)
• Checking the Database Message Log (Informix)
• Checking State on Disk (Informix)
• Checking Pseudotables (Informix)
• Checking Parameter Changes (Informix)
• Checking the Database with onstat Commands (Informix)