Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu.

The functions in this menu go into greater detail than the database overview and help you with advanced database monitoring operations. The most commonly used functions are the following:

• Wait Situations (Informix)

• Chunk I/O Activity (Informix)

• · Informix Session
• · Table Activity (Informix)
• · Exclusive Lockwaits (Informix)
• · Database Message Log (Informix)
• · State on Disk (Informix)
• · Display Pseudotables (Informix)

• Parameter Changes (Informix)

• SQL Statement (Informix)

• Onstat Commands