In DB2 Version 7 the database system monitor interface has been simplified and is now the same for all database and system configurations. This harmonization of the interface means that some of the request types that were available with the Parallel Edition (PE) V1.2 system monitor are no longer supported.
The most significant change affects how you monitor an application. In DB2 Version 7 an application snapshot returns all the relevaent application information, including a breakdown of the application statistics at the subsection or agent level (if applicable). For example, assuming an application is running a query composed of several subsections, a GET SNAPHOT FOR APPLICATION will return:
This information is available on both the coordinator and non-coordinator nodes. In PE V1.2, you would have to request information about individual agents or tablequeues and correlate the output obtained at these levels with the application.
| Note: | PE V1.2 applications are not compatible with DB2 Version 7. |
PE V1.2 applications that are not using any of the requests that have are obsolete in DB2 Version 7 can be recompiled after changing the request type from SQLM_DBMON_PARALLEL1 to SQLM_DBMON_VERSION1. No other changes should be required. See the following tables for obsolete requests.
agent_id
You should note that agent_id no longer corresponds to the process ID of the agent process. This field has not been renamed in the API to ensure source compatibility with previous versions, however it has become a globally unique identifier for the application.
Agent ID and application handle are synonymous. See Partitioned Database Considerations for more information.