DB2 Application's Agent (DB2_AGENT)

The DB2_AGENT application class represents the agents that are working on behalf of DB2 applications.

Application class attributes

Attributes (parameters)

The following attributes are available for this monitor type:

• Application idle time (ApplIdleTime)
• Average sort time (AveApplSortTime)
• Average wait for lock (AveApplWaitForLock)
• Catalog cache hit ratio (CtlgCacheHitRatio)
• Commits attempted (ApplCommitsAttempted)
• Current lock wait time (CurrLockWaitTime)
• DDL executed (ApplDDLExec)
• Duration current UOW (DurationCurrUOW)
• Duration of most recent UOW (DurationMostRecentUOW)
• Internal rollbacks due to deadlock (ApplIntDeadlockRollbacks)
• Number of agents associated with an application (SubAgent)
• Number of deadlocks (NumApplDeadlocks)
• Number of exclusive lock escalations (NumApplExclLockEscals)
• Number of hash join overflows (HashJoinOverflows)
• Number of hash join small overflows (HashJoinSmallOverflows)
• Number of lock escalations (NumApplLockEscals)
• Number of lock timeouts (NumApplLockTimeouts)
• Number of total hash Joins (TotHashJoins)
• Number of total hash loops (TotHashLoops)
• Package cache hit ratio (PkgCacheHitRatio)
• Percentage of CPU time for agent (CpuUtilPct)
• Percentage of maxlocks held by application (PctApplmaxlocksHeld)
• Percentage of open local cursors with blocking (PctBlkOpenLocCursors)
• Percent overflow sort requests (PctApplOverflowSortReqs)
• Rollbacks attempted (ApplRollbacksAttempted)
• Rows read (RowsReadByAppl)
• Rows written (RowsWrittenByAppl)
• Selects executed (ApplSelectsExec)
• System CPU time used by agent (SystemCPUTimebyAgent)
• System CPU time used by statement (SystemCPUTimebyStmt)
• Time between most recent commit/rollback points (TimeBtwnRecentCommRbkPts)
• Total throughput (ApplTotThroughput)
• Total UOW (ApplTotUOW)
• UOW lock wait time (UOWLockWaitTime)
• UOW log space used (UOWLogSpaceUsed)
• Updates/Inserts/Deletes executed (ApplUpdInsDelExec)
• User CPU time used by agent (UserCPUTimebyAgent)
• User CPU time used by statement (UserCPUTimebyStmt)