Troubleshooting
Problem
This document gives you steps to enable Database Monitoring using a Client Access Express or IBM® iSeries® Access for Windows ODBC DSN setup.
See this TechNote for more information on Database Monitor impacts: https://www-01.ibm.com/support/docview.wss?uid=ibm10882914
Resolving The Problem
To start Database Monitor (DBMON) from the Client side using a Client Access Express or IBM® iSeries™ Access for Windows ODBC connection, do the following:
Note: These steps will not work with the IBM® DB2® driver or with OEM (non-IBM) ODBC drivers.
| 1 | Click on the Start button > Programs > IBM iSeries Access for Windows > ODBC Administration > System DSN or User DSN. |
| 2 | Highlight the DSN that the ODBC application uses to connect to the IBM® System i® products system, and press Configure. Note: The user must know which DSN they are using to make the connection. |
| 3 | Click on the Diagnostic tab. |
| 4 | Select the Enable Database Monitor, Enable the Start Debug (STRDBG) command, and click OK |
The following is the Help text on enabling DBMON through DSN:
The DBMON trace is started for any jobs going to that system from the PC that the DSN resides on. The DBMON file is called qodbnnnnnn, where nnnnnn is the job number, and it will be in library QUSRSYS.
The DBMON trace will stop when the application disconnects (SQLDisconnect) or an ENDDBMON command against that job is done.
| Caution: A long-running and/or large DBMON can negatively impact system performance. If possible, narrow the scope of the issue and start the DBMON, shortly before the issue begins and over specific or generic job names. If it is suspected that the DBMON is causing system wide performance issues, end the DBMON using the ENDDBMON command from the IBM i command line. If ENDDBMON is not working as-expected, issue the following command from the IBM i command line instead: ENDDBMON JOB(*ALL/*ALL/*ALL) COMMENT(END_ALL_PUBLIC_MONITORS) |
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"Db2 for i","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Historical Number
380980934
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1015497