With STRDBMON, you can monitor SQL queries executed in DB2 Universal Database for iSeries that come from different SQL interfaces such as ODBC, IBM Toolbox for Java, native JDBC, or SQL call level interface (SQL CLI). Moreover, when you choose to collect detailed information, you can also monitor queries that come from non-SQL interfaces such as OPNQRYF and Query for iSeries. 4.2.2 Ending a Detailed Database Monitor To end the collection of database performance data for a specified job or all jobs on the system, you must use the End Database Monitor (ENDDBMON) command. The following parameters are available for this command: JOB You can specify the job name or *ALL to end only the monitor that was started with that same job name. It is possible to end one monitor on a job and still have another one collecting on that same job. COMMENT This parameter enables you to describe the collection. If an attempt is made to end the monitor on all jobs, then a STRDBMON command must have been issued previously for all jobs. If a particular job is specified in this command, the job must have the monitor started explicitly and specifically on that job. For more information about the STRDBMON or ENDDBMON commands, visit the V5R3 iSeries Information Center at: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp