You can use the detailed database analysis in the SAP/Informix database monitor to check sessions.

The session monitor provides activity information on each session in the database. In the SAP environment every work process has one session, so that this function represents the database view of work process activity. The host name and process ID can be used in conjunction with transaction SM51 to determine which work process belongs to the session.

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

The first screen of the session monitor shows, in addition to the Host Name and Process ID, the Session ID, the Thread ID of the sqlexec thread, total RSAM calls, Running time, Wait time and the current thread status.

2. To see the most recent SQL statement issued by the work process, select a session and choose Current sql.