You can use the Database System Monitor with DB2 Connect Enterprise Edition to monitor the connections for remote clients. Owing to a limitation, at present you cannot use the System Monitor to monitor connections for applications running on the DB2 Connect gateway workstation.
For example, when an error occurs at the host or AS/400 system, the system administrator can determine if the problem was on the DB2 Connect workstation. The database system monitor correlates:
This information shows which DB2 Connect connection caused the problem, which allows the system administrator to force the individual client application from the system without affecting the other clients using the DB2 Connect connection.
The system monitor is always active. However, if you want to get more detail in GET SNAPSHOT output, you should turn on the corresponding monitor switches. The monitor switches relevant to DB2 Connect are STATEMENT (for statement-level information), and UOW (for transaction-level information).
To change monitor switches, use the DB2 UPDATE MONITOR SWITCHES command. Refer to the Command Reference for the syntax of this command. Here is an example, which creates DB2 System Monitor statistics for Units of Work (UOW):
db2 update monitor switches using uow on
To list the status of monitor switches, use the DB2 GET MONITOR SWITCHES command.