IBM Books

System Monitor Guide and Reference


API Changes


Obsolete sqlmonss() Request Type Description Replacement
SQLMA_AGENT_APPL
SQLMA_AGENT_AGENTID

Get snapshot for agent Replaced with SQLMA_APPL which will report a breakdown per agent, if and when applicable.
SQLMA_COORD_AGENTS List all coordinator agents Replaced with SQLMA_appl_info_ALL, which returns appl_info for each application. It identifies the node where the coordinator agent runs and provides both its application handle and agent thread or process ID.
SQLMA_FCM_NODE_ALL
SQLMA_FCM_NODE

Get Fast Communication Manager Replaced with SQLMA_DB2, which gets all database manager information and returns FCM information (if applicable).
SQLMA_AGENT_ALL
SQLMA_COORD_AGENTS

Get snapshot for all agents
Get snapshot for coordinator agents

In PE V1.2, returned an SQLMA_AGENT_AGENTID snapshot for all agents, including the coordinators (or the coordinators only). Replaced with SQLMA_APPL_ALL (GET SNAPSHOT FOR APPLICATIONS). Note that information is not returned for agents that are not associated with any applications, as their counts would be zeroes.
SQLMA_DBASE_AGENTS Get snapshot for all agents for a database Replaced with SQLMA_DBASE_APPLS.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]