DB2 Instance Partition Parameters (DB2_INSTANCE_PARTITION_PARAMETERS)

The DB2_INSTANCE_PARTITION_PARAMETERS application class serves as a container for all the consumer parameters related to the instance partiion node. It represents the monitored group Instance Partition Parameters that exist in PSO_INSTANCE_PARTITION_PARAMETERS.xml file.

Application class attributes

Attributes (parameters)

The following attributes are available for this monitor type:

• Agents Registered (AgentsRegd)
• Committed private memory (CommittedPrivateMem)
• FCM buffer pool utilization (FCMBufferPoolUtil)
• Hash joins after heap threshold exceeded (PostThreshHashJoins)
• High water mark for agents registered (MaxAgentsRegd)
• High water mark for coordinating agents (MaxCoordAgents)
• Idle agents (NumIdleAgents)
• Local connections executing in db manager (LocConnExecInDBM)
• Local connections in db manager (LocConnectsToDBM)
• Percentage of agents assigned from agent pool (PctAgentsFromPool)
• Percentage of agents registered to max agents (PctAgentsRegd)
• Percentage of Idle agents to max agents (PctAgentsIdle)
• Percentage of piped sort requests accepted (PctPipedSortReqsAcc)
• Post threshold sorts (PostThreshSorts)
• Private Sort heap allocated (TotSortHeapAlloc)
• Remote connections executing in db manager (RemConnExecInDBM)
• Remote connections to db manager (RemConnectsToDBM)