You can use the detailed database analysis in the SAP/Informix database monitor to check statistics on the thread status. Although called wait statistics, these statistics cover all thread states, that is, they also include information on how long the threads are running, so providing a global overview of how time is spent in the database.

For the first part of the Wait Situations display, the possible thread states are summarized for all threads in the database. The state of threads that are simply idling and waiting for work does not appear in the display, so that you only see the important wait reasons and time spent running.

The statistics on thread status are collected if the parameter WSTATS is set to 1 in the Informix ONCONFIG file

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