| Data Columns | Computed Columns |
| Adapter | ASG TMONDB2 |
|---|---|
| ASG TMON for DB2 for z/OS. Formerly from Landmark. Tracks DB2 buffer pools, lock contention and serialized resource usage, transaction statistics from CICS to DB2, and dynamic and static SQL calls. | |
| Domain Category | TMONDB2 |
| ITRM Table Name | XTMDDA2 |
| MXG Table Name | TMDBDA2 |
| Table Description | TMON for DB2 interval statistics |
Data Columns
| ITRM Column Name | MXG Column Name  | Description |
|---|---|---|
| CPSRBTM | CPUSRBTM | TaskSrbTime |
| CPTCBTM | CPUTCBTM | TaskTcbTime |
| DA3TABR | DA3STABR | AbortRequests |
| DA3TCMT | DA3STCMT | SuccessCommit(p1,p2,read-only) |
| DA3TCOM | DA3STCOM | CommitPhase-2 |
| DA3TCTH | DA3STCTH | CreateThreadRequests |
| DA3TCTW | DA3STCTW | CreateThreadsRequestsThatWaited |
| DA3TEXT | DA3STEXT | ExitRequests |
| DASTHWB | DA3STHWB | HighWaterMarkForIdbackThreads |
| DASTHWC | DA3STHWC | HighWaterMarkForCthreadThreads |
| DASTHWF | DA3STHWF | HighWaterMarkForIdforeThreads |
| DA3TIDN | DA3STIDN | IdentifyRequests |
| DA3TIND | DA3STIND | AgentsGoneIndoubt |
| DA3TMOM | DA3STMOM | SsamEomCount |
| DA3TMOT | DA3STMOT | End-of-task(non-db2TaskAbends) |
| DA3TPRE | DA3STPRE | PrepareRequests |
| DA3TRDO | DA3STRDO | ReadOnlyCommits |
| DA3TRIU | DA3STRIU | ResolveIndoubtUnitOfRecovery |
| DA3TSGN | DA3STSGN | Sign-onRequests |
| DA3TSSI | DA3STSSI | SsiCallsProcessed |
| DA3TSYN | DA3STSYN | CommitPhase-1 |
| DA3TTRM | DA3STTRM | TerminateThreadRequests |
| DA9TCT0 | DA9STCT0 | DisplayDatabaseCommands |
| DA9TCT1 | DA9STCT1 | DisplayThreadCommands |
| DA9TCT2 | DA9STCT2 | DisplayUtilityCommands |
| DA9TCT3 | DA9STCT3 | RecoverBsdsCommands |
| DA9TCT4 | DA9STCT4 | RecoverIndoubtCommands |
| DA9TCT5 | DA9STCT5 | StartDatabaseCommands |
| DA9TCT6 | DA9STCT6 | StartTraceCommands |
| DA9TCT7 | DA9STCT7 | StartDb2Commands |
| DA9TCT8 | DA9STCT8 | StopDatabaseCommands |
| DA9TCT9 | DA9STCT9 | StopTraceCommands |
| DA9TCTA | DA9STCTA | StopDb2Commands |
| DA9TCTB | DA9STCTB | TermUtilityCommands |
| DA9TCTC | DA9STCTC | DisplayTraceCommands |
| DA9TCTD | DA9STCTD | ResetGenericluCommands |
| DA9TCTE | DA9STCTE | StartRlimitCommands |
| DA9TCTF | DA9STCTF | StopRlimitCommands |
| DA9TCTG | DA9STCTG | DisplayRlimitCommands |
| DA9TCTH | DA9STCTH | ModifyTraceCommands |
| DA9TCTI | DA9STCTI | StartDdfCommands |
| DA9TCTJ | DA9STCTJ | StopDdfCommands |
| DA9TCTK | DA9STCTK | CancelDdfThdCommands |
| DA9TCTL | DA9STCTL | DisplayLocationCommands |
| DA9TCTM | DA9STCTM | ArchiveLogCommands |
| DA9TCTN | DA9STCTN | AlterBufferpoolCommands |
| DA9TCTO | DA9STCTO | DisplayBufferpoolCommands |
| DA9TCTP | DA9STCTP | SetArchiveCommands |
| DA9TCTQ | DA9STCTQ | DisplayArchiveCommands |
| DA9TCTR | DA9STCTR | ResetIndoubtCommands |
| DA9TCTS | DA9STCTS | AlterGbpoolCommands |
| DA9TCTT | DA9STCTT | DisplayGbpoolCommands |
| DA9TCTU | DA9STCTU | DisplayProcedureCommands |
| DA9TCTV | DA9STCTV | StartProcedureCommands |
| DA9TCTW | DA9STCTW | StopProcedureCommands |
| DA9TCTX | DA9STCTX | DisplayGroupCommands |
| DASTCTY | DA9STCTY | AlterUtilityCommands |
| DA9TCTZ | DA9STCTZ | DisplayFunctionCommands |
| DA9TCX0 | DA9STCX0 | StartFunctionCommands |
| DA9TCX1 | DA9STCX1 | StopFunctionCommands |
| DA9TCX2 | DA9STCX2 | SetLogCommands |
| DA9TCX3 | DA9STCX3 | DisplayLogCommands |
| DASTCX4 | DA9STCX4 | SetSysparmCommands |
| DA9TERR | DA9STERR | UnrecognizedCommands |
| DASADDL | DAASADDL | AllocationFailure(deadlock) |
| DASADIR | DAASADIR | AllocationFailure(invalid) |
| DASADUR | DAASADUR | AllocationFailure(unavailable) |
| DASSUSP | DAASSUSP | PhysicalSuspends |
| DASXAUS | DAASXAUS | AsynchronousUnrelatedTcbsScheduled |
| DASXAUT | DAASXAUT | AsynchronousUnrelatedTcbsScheduled |
| DASXSRS | DAASXSRS | SynchronousRelatedTcbsScheduled |
| DASXSRT | DAASXSRT | SynchronousRelatedTcbsScheduled |
| DASXSUS | DAASXSUS | SynchronousUnrelatedTcbsScheduled |
| DASXSUT | DAASXSUT | SynchronousUnrelatedTcbsScheduled |
| DABGL2H | DABGL2H | AsyncIxlcacheInvocSecondaryGbp |
| DABGLGG | DABGLGG | GetpagesForGbpDepPages |
| DABGLHS | DABGLHS | AsyncIxlcacheInvocPrimaryGbp |
| DABGLN1 | DABGLN1 | PageP-lockLockNegoSpaceMapPages |
| DABGLN2 | DABGLN2 | PageP-lockLockNegotiationsDataPgs |
| DABGLN3 | DABGLN3 | PageP-lockLockNegoIndexLeafPgs |
| DABGLP1 | DABGLP1 | PageP-lockLockReqsSpaceMapPgs |
| DABGLP2 | DABGLP2 | PageP-lockLockReqsDataPages |
| DABGLP3 | DABGLP3 | PageP-lockLockReqsIndexLeafPgs |
| DABGLS1 | DABGLS1 | PageP-lockLockSuspsSpaceMapPgs |
| DABGLS2 | DABGLS2 | PageP-lockLockSuspsDataPages |
| DABGLS3 | DABGLS3 | PageP-lockLockSuspsIndexLeafPgs |
| DABGLU1 | DABGLU1 | PageP-lockUnlockRequests |
| DABPFIX | DABPFIX | PgfixAttribute |
| DABPGST | DABPGST | PgstealAttribute |
| DABSLA | DABSLA | Serviceability |
| DABSTLP | DABSTLPL | TimesPagesAddedToLpl |
| DABVDQB | DABVDQB | PoolVerticalWriteThreshold |
| DADNDBA | DADNDBA | RequestsRequiredDbatThread |
| DADPOOL | DADPOOL | RequestsSatisfiedByPoolThread |
| DADAJST | DADSAJST | Dbm1AddressSpaceTcbTime |
| DADAPRC | DADSAPRC | Dbm1AddressSpaceProcName |
| DADASCB | DADSASCB | Dbm1AddressSpaceAscbToken |
| DADASID | DADSASID | Dbm1AddressSpaceAsid |
| DADASRB | DADSASRB | Dbm1AddressSpaceSrbTime |
| DASDCCO | DADSDCCO | IfiCommandRequests |
| DASDCKP | DADSDCKP | CountOfDb2Checkpoints |
| DASDCRA | DADSDCRA | IfiReadaRequests |
| DASDCRS | DADSDCRS | IfiReadsRequests |
| DASDCWR | DADSDCWR | IfiWriteRequests |
| DASDDDD | DADSDDDD | DataCaptureDataDescriptions |
| DASDDDR | DADSDDDR | DataCaptureLogRows |
| DASDDLC | DADSDDLC | LogRecordsCaptured |
| DASDDLR | DADSDDLR | DataCaptureLogReads |
| DASDDMB | DADSDDMB | DataCaptureDescribes |
| DASDDRR | DADSDDRR | DataCaptureLogRecords |
| DASDDTB | DADSDDTB | DataCaptureTables |
| DASDLR | DADSDLR | HighUsedRbaAddressOfLog |
| DASDSCA | DADSDSCA | IfiAbends |
| DASDSCU | DADSDSCU | IfiUnrecognizedFunctions |
| DASINV1 | DADSINV1 | Reason1StatisticsWasInvoked |
| DASINV2 | DADSINV2 | Reason2StatisticsWasInvoked |
| DASINV3 | DADSINV3 | Reason3StatisticsWasInvoked |
| DASINV4 | DADSINV4 | Reason4StatisticsWasInvoked |
| DADSPSR | DADSPSRB | Dbm1AddressSpacePreemptableSrb |
| DASTCI2 | DADSTCI2 | CurrentType2InactiveThreads |
| DASTCNA | DADSTCNA | CurrentActiveDbatThreads |
| DASTCST | DADSTCST | ColdStartConnections |
| DASTDBT | DADSTDBT | DbaseAccessThrdQueued(dbat) |
| DASTHWA | DADSTHWA | HighWaterMarkOfActiveDbatThreads |
| DASTHWD | DADSTHWD | HighWaterMarkOfAllDbatThreads |
| DASTMAS | DADSTMAS | HwmDbatSlotsNotInUse |
| DASTMI2 | DADSTMI2 | HwmType2InactiveThreads |
| DASTMQ2 | DADSTMQ2 | HwmType2InactiveThreadsQueued |
| DASTNAS | DADSTNAS | CurrDbatSlotsNotInUse |
| DASTNQ2 | DADSTNQ2 | CurrentType2InactiveThreadsQueued |
| DASTQCI | DADSTQCI | CurrentInactiveDbats |
| DASTQCR | DADSTQCR | ConversDeallocDueToDsnzparmLimit |
| DASTQI2 | DADSTQI2 | QueuedReceiveRequests |
| DASTQMI | DADSTQMI | HighWaterMarkOfInactiveDbat |
| DASTRSA | DADSTRSA | ResyncConnectionsAttempts |
| DASTRSS | DADSTRSS | ResyncConnectionsSuccess |
| DASTWST | DADSTWST | WarmStartConnections |
| DADSZSR | DADSZSRB | Dbm1AddressSpacePreemptableSrbZiip |
| DASCHNP | DAGSCHNP | ChangepRequests |
| DASCPLK | DAGSCPLK | ChgReqsForP-locks |
| DASCSLM | DAGSCSLM | ChgReqsPropagatedToXes |
| DASDRTA | DAGSDRTA | GlobalLock/chgReqsDenied |
| DAGSFLM | DAGSFLMG | FalseContentions |
| DASFLSE | DAGSFLSE | FalseContentions |
| DASIGLO | DAGSIGLO | Suspends(irlmGlobalContention) |
| DASKIDS | DAGSKIDS | LockReqsPropagatedToXesAsync |
| DASLPLK | DAGSLPLK | LockReqsForP-locks |
| DASLSLM | DAGSLSLM | LockReqsPropagatedToXes |
| DASNTFR | DAGSNTFR | NotifyMessagesReceived |
| DASNTFY | DAGSNTFY | NotifyMessagesSent |
| DASOTPE | DAGSOTPE | OtherP-lockNegotiates |
| DASPEMX | DAGSPEMX | MaxEnginesAvailForP-lock/notifyExit |
| DASPEQW | DAGSPEQW | EngineUnavailForP-lock/notify |
| DASPGPE | DAGSPGPE | PageP-lockNegotiates |
| DASPPPE | DAGSPPPE | Pageset/partitionP-lockNegotiates |
| DASSGLO | DAGSSGLO | Suspends(xesGlobalContention) |
| DASUPLK | DAGSUPLK | UnlckReqsForP-locks |
| DASUSLM | DAGSUSLM | UnlockReqsPropagatedToXes |
| DAIAJST | DAISAJST | IrlmAddressSpaceTcbTime |
| DAIAPRC | DAISAPRC | IrlmAddressSpaceProcName |
| DAIASCB | DAISASCB | IrlmAddressSpaceAscbToken |
| DAIASID | DAISASID | IrlmAddressSpaceAsid |
| DAIASRB | DAISASRB | IrlmAddressSpaceSrbTime |
| DAISPSR | DAISPSRB | IrlmAddressSpacePreemptableSrb |
| DASRST1 | DAISRST1 | IsrRecordTypeFlag |
| DAISTCO | DAISTCOL | ColumnsTerminatedPeakConcurr |
| DASTCUR | DAISTCUR | RidInternalBlocksAllocated |
| DASTHIG | DAISTHIG | RidInternalBlksAllocated(hwm) |
| DASTLLM | DAISTLLM | TmsRidTerminated(rdsLimit) |
| DASTMAX | DAISTMAX | TmsRidTerminated(mxConcurrProcess) |
| DASTPLM | DAISTPLM | TmsRidTerminated(dmLimit) |
| DASTSTG | DAISTSTG | TmsRidTerminated(sos) |
| DAISZSR | DAISZSRB | IrlmAddressSpacePreemptableSrbZiip |
| DAJSBPA | DAJSBPAG | LogWriteBufferPagedIn |
| DAJSCIW | DAJSCIWR | LogWriteCi-sWritten |
| DAJSLOG | DAJSLOGW | LogWriteIoRequests |
| DAJSLSU | DAJSLSUS | LogWriteSuspends |
| DAJSSER | DAJSSERW | SerialLogWriteRequests |
| DASTALR | DAJSTALR | ArchiveLogReadAllocations |
| DASTALW | DAJSTALW | ArchiveLogWriteAllocations |
| DASTBDS | DAJSTBDS | BsdsAccessed |
| DASTBFL | DAJSTBFL | ActiveLogOutputCiCreated |
| DASTBFW | DAJSTBFW | CallsToWriteActiveLogBuffers |
| DASTCIO | DAJSTCIO | ActiveLogControlIntervals |
| DAJSTHR | DAJSTHRW | LogWriteRescheduledThreshold |
| DASTLMA | DAJSTLMA | LookaheadTapeVolumeMountsAttempted |
| DASTLMS | DAJSTLMS | LookaheadTapeVolMountsPerformed |
| DASTRAC | DAJSTRAC | LogReadsSatisfiedFromActiveLog |
| DASTRAR | DAJSTRAR | ReadsFromArchiveLog |
| DASTRBF | DAJSTRBF | LogReadsFrOutputBuffers |
| DASTTVC | DAJSTTVC | ReadsDelayedForArchiveAllocLimit |
| DASTWRF | DAJSTWRF | LogWriteRequests(force) |
| DASTWRN | DAJSTWRN | LogWriteRequests(nowait) |
| DASTWRW | DAJSTWRW | LogWriteRequests(wait) |
| DASTWTB | DAJSTWTB | LogWaitsDueToUnavailWriteBuffer |
| DASTWUR | DAJSTWUR | ReadDelayedDueToUnavailResource |
| DAMAJST | DAMSAJST | MstrAddressSpaceTcbTime |
| DAMAPRC | DAMSAPRC | MstrAddressSpaceProcName |
| DAMASCB | DAMSASCB | MstrAddressSpaceAscbToken |
| DAMASID | DAMSASID | MstrAddressSpaceAsid |
| DAMASRB | DAMSASRB | MstrAddressSpaceSrbTime |
| DASEXC | DAMSEXC | ExceptionsDetected |
| DAMSPSR | DAMSPSRB | MstrAddressSpacePreemptableSrb |
| DAMSZSR | DAMSZSRB | MstrAddressSpacePreemptableSrbZiip |
| DAAPGID | DASAPGID | Db2dbm1IntervalPagin |
| DAAPGII | DASAPGII | IrlmprocIntervalPagin |
| DAAPGIM | DASAPGIM | Db2mstrIntervalPagin |
| DAAPGIX | DASAPGIX | DistIntervalPagin |
| DAAPGOD | DASAPGOD | Db2dbm1IntervalPagout |
| DAAPGOI | DASAPGOI | IrlmprocIntervalPagout |
| DAAPGOM | DASAPGOM | Db2mstrIntervalPagout |
| DAAPGOX | DASAPGOX | DistIntervalPagout |
| DADIRF | DASDIRF | ReasonIntervalStatRecordWasLogged |
| DASECFA | DASECFAL | FailDueToStmtPoolFull |
| DASECFR | DASECFRE | FreePagesInStmtFreeChain |
| DASECPG | DASECPGE | PagesInStatementPool |
| DAECT | DASECT | PagesUsedForCursorTable |
| DAECTG | DASECTG | RequestsForCursorTableSections |
| DAECTL | DASECTL | LoadedCursorTableSections |
| DAEDBD | DASEDBD | PagesUsedForDatabaseDescriptors |
| DAEDBDG | DASEDBDG | DbdRequests |
| DAEDBDL | DASEDBDL | DbdLoadedFromDasd |
| DASEDFA | DASEDFAL | FailDueToDbdPoolFull |
| DASEDFR | DASEDFRE | FreePgsInDbdFreeChain |
| DASEDPG | DASEDPGE | PagesInDbdPool |
| DAEDSC | DASEDSC | DynamicCachePagesUsed |
| DAEDSG | DASEDSG | DynamicCacheRequests |
| DAEDSI | DASEDSI | DynamicCacheInserts |
| DASEDYN | DASEDYNP | PagesUsedInStmtPool |
| DAEFAIL | DASEFAIL | FailuresDueToPoolFull |
| DAEFREE | DASEFREE | FreePagesInFreeChain |
| DAEKT | DASEKT | PagesUsedForPackageTable |
| DAEKTG | DASEKTG | RequestsForPtSections |
| DAEKTL | DASEKTL | PtSectionsLoadedFromDasd |
| DAEPAGE | DASEPAGE | PagesInEdmPool |
| DAESKCT | DASESKCT | PagesUsedForSkeletonCursorTables |
| DAESKPT | DASESKPT | PagesUsedForSkpt |
| DASSPSR | DASSPSRB | SpasAddressSpacePreemptableSrb |
| DASTABN | DASSTABN | AbendsDueToStorageSos |
| DASTCNF | DASSTCNF | FixedPoolSegmentsContracted |
| DASTCNV | DASSTCNV | VariablePoolSegmentsContracted |
| DASTCON | DASSTCON | StorageContractions(dueToSos) |
| DASTCRI | DASSTCRI | ShortageOfStorage(sos)Detected |
| DASTEXF | DASSTEXF | FixedPoolSegmentsExpanded |
| DASTEXV | DASSTEXV | VariablePoolSegmentsExpanded |
| DASTFPF | DASSTFPF | FixedPoolsDeallocated |
| DASTFPV | DASSTFPV | VariablePoolsDeallocated |
| DASTFRE | DASSTFRE | Non-poolFreemainsIssued |
| DASTFRF | DASSTFRF | FixedPoolSegmentsFreed |
| DASTFRV | DASSTFRV | VariablePoolSegmentsFreed |
| DASTGET | DASSTGET | Non-poolGetmainsIssued |
| DASTGPF | DASSTGPF | FixedPoolsCreated |
| DASTGPV | DASSTGPV | VariablePoolsCreated |
| DASTRCN | DASSTRCN | NonzeroReturnsByGm/fm |
| DASSZSR | DASSZSRB | SpasAddressSpacePreemptableSrbZiip |
| DAABIND | DATABIND | SuccessfulAutomaticBindPlans |
| DAABNDA | DATABNDA | AutomaticBindPlanAttempts |
| DAABNPA | DATABNPA | AutomaticBindPackageAttempts |
| DAABNPS | DATABNPS | SuccessfulAutomaticBindPackages |
| DAALLCA | DATALLCA | PlanAllocationAttempts |
| DAALLOC | DATALLOC | SuccessfulBoundPlanAllocations |
| DAALLPA | DATALLPA | PackageAllocationAttempts |
| DAALLPS | DATALLPS | SuccessfulPackageAllocations |
| DAAUCCH | DATAUCCH | SuccessfulAuthChecksUsingCache |
| DAAUCHK | DATAUCHK | AuthChecksAttempts |
| DAAUPUB | DATAUPUB | SuccessfulPublicAuthChecks |
| DAAUSUC | DATAUSUC | SuccessfulAuthChecks |
| DABINDA | DATBINDA | Bind(add)PlanSub-commands |
| DABINDR | DATBINDR | Bind(replace)PlanSub-commands |
| DABNDPA | DATBNDPA | Bind(add)PackageSub-commands |
| DABNDPR | DATBNDPR | Bind(replace)PackageSub-commands |
| DATCAUT | DATCAUT | SucRoutineAuthChecksFromCache |
| DATCNAC | DATCNAC | UnsucAddsToRoutineAuthCache |
| DATCNOT | DATCNOT | UnsucRoutineAuthChecksFromCache |
| DATCOW1 | DATCOW1 | AuthidOverwritesInRtnAuthCache |
| DATCOW2 | DATCOW2 | RoutineOverwritesInRtnAuthCache |
| DATCPUB | DATCPUB | SucRtnPublicAuthChecksFromCache |
| DACURPB | DATCURPB | CurrentClose(yes)PagesetsNotInUse |
| DADSDRN | DATDSDRN | DatasetsClosedViaDrain |
| DADSOPN | DATDSOPN | DatasetsCurrentlyOpen |
| DAEXDRN | DATEXDRN | SuccessfulDatasetDrains |
| DAFREE | DATFREE | FreePlanSub-commands |
| DAFREEA | DATFREEA | AttemptsToFreeAPlan |
| DAFREPA | DATFREPA | AttemptsToFreeAPackage |
| DAFREPS | DATFREPS | FreePackageSub-commands |
| DAHAJST | DATHAJST | AccumulatedAscbTcbTimeInDb2 |
| DAHASC | DATHASC | ThreadElapsedTimeInDb2 |
| DAHASRB | DATHASRB | AccumulatedAscbSrbTimeInDb2 |
| DAHAWTI | DATHAWTI | IoElapsedWaitTime |
| DAHAWTL | DATHAWTL | AccumulatedLock/latchElapsedTime |
| DAHDBTT | DATHDBTT | IndoubtTimeBetweenThePhases |
| DAHNSRT | DATHNSRT | SortInvocations |
| DAHPH1C | DATHPH1C | CommitPh1Calls |
| DAHPH1T | DATHPH1T | CmtP1AccumulatedElapsedTime |
| DAHPH2C | DATHPH2C | CommitPh2Calls |
| DAHPH2T | DATHPH2T | CmtP2AccumulatedElapsedTime |
| DAHSYNC | DATHSYNC | 1phCommitCalls |
| DAHSYNT | DATHSYNT | 1pCmtAccumulatedElapsedTime |
| DAHTHDC | DATHTHDC | CurrentlyActiveThreads |
| DAHTHDM | DATHTHDM | ConcurrentThreads(intervalHwm) |
| DAHTHDN | DATHTHDN | PrimaryTdr(s)LoggedDueToNewUser |
| DAHTHDP | DATHTHDP | PriThreadDetailRecords(tdr)Logged |
| DAHTHDR | DATHTHDR | PrimaryTdr(s)LoggedDueToResignon |
| DAHTHDS | DATHTHDS | SecondaryTdr(s)Logged |
| DAHTHDX | DATHTHDX | ConcurrentThreads(tmonConnectHwm) |
| DAHTIME | DATHTIME | AccumulatedElapsedSortTime |
| DAMAXDS | DATMAXDS | MaxDsetsOpenedConcurrently |
| DAMAXPB | DATMAXPB | MaxClose(yes)PagesetsNotInUse |
| DANVRID | DATNVRID | InvalidResourceIds |
| DAOPNNO | DATOPNNO | OpenFailuresAfterDrainProcess |
| DAOPNOK | DATOPNOK | OpenSuccessesAfterDrainProcess |
| DAPAUT | DATPAUT | SuccessfulPackageAuthChecks |
| DAPCCT | DATPCCT | DatasetsConvertedToReadonlyState |
| DAPCOW1 | DATPCOW1 | PackageCacheAuthidOverwrites |
| DAPCOW2 | DATPCOW2 | PackageCachePackageOverwrites |
| DAPKGBD | DATPKGBD | PackagesBound |
| DAPKGFR | DATPKGFR | PackagesFreed |
| DAPKGRB | DATPKGRB | PackagesRebound |
| DAPLFRD | DATPLFRD | PlansFreed |
| DAPLNBD | DATPLNBD | PlansBound |
| DAPLRBD | DATPLRBD | PlansRebound |
| DAPNOT | DATPNOT | UnsuccessfulPackageAuthChecks |
| DAPPUB | DATPPUB | SuccessfulPublicPkgAuthChecks |
| DARBIND | DATRBIND | RebindPlanSub-commands |
| DARBNDA | DATRBNDA | AttemptsToRebindAPlan |
| DARBNPA | DATRBNPA | AttemptsToRebindAPackage |
| DARBNPS | DATRBNPS | RebindPackageSub-commands |
| DAREOPN | DATREOPN | ReopensDueToSlowClose |
| DASLWDD | DATSLWDD | CurrentClose(yes)DatasetsNotInUse |
| DASTDRN | DATSTDRN | UnsuccessfulDatasetDrains |
| DATESTB | DATTESTB | TestBinds(noPlan-id) |
| DATTDRN | DATTTDRN | DatasetDrainRequests |
| DACALU | DAUCALU | AlterUtilityCount |
| DACCHK | DAUCCHK | CheckUtilityCount |
| DACCPY | DAUCCPY | CopyUtilityCount |
| DACDIA | DAUCDIA | DiagnoseUtilityCount |
| DACLOD | DAUCLOD | LoadUtilityCount |
| DACMOD | DAUCMOD | ModifyUtilityCount |
| DACMRG | DAUCMRG | MergeUtilityCount |
| DACQUI | DAUCQUI | QuiesceUtilityCount |
| DACRCV | DAUCRCV | RecoverUtilityCount |
| DACREO | DAUCREO | ReorgUtilityCount |
| DACRPR | DAUCRPR | RepairUtilityCount |
| DACRPT | DAUCRPT | ReportUtilityCount |
| DACRUN | DAUCRUN | RunstatsUtilityCount |
| DACSTO | DAUCSTO | StospaceUtilityCount |
| DAACHG | DAXACHG | ChangeRequestCount |
| DAACHUS | DAXACHUS | HighestCpuSecondsUsed |
| DAACLMT | DAXACLMT | LimitCpuSeconds |
| DAACLNO | DAXACLNO | ClaimRequests |
| DAACLUN | DAXACLUN | UnsuccessfulClaimRequests |
| DAADEA | DAXADEA | DeadlockCount |
| DAADRNO | DAXADRNO | DrainRequests |
| DAADRUN | DAXADRUN | UnsuccessfulDrainRequests |
| DAAFLG1 | DAXAFLG1 | ResourceLimitFacilityFlagByte |
| DAAFLGR | DAXAFLGR | DaxaflgrFlag |
| DAAIRLM | DAXAIRLM | OtherIrlmRequestCount |
| DAALDAB | DAXALDAB | AlterDatabasesStatements |
| DAALES | DAXALES | LocksEscalatedToSharedMod |
| DAALEX | DAXALEX | LocksEscalatedToExclusive |
| DAALOCC | DAXALOCC | AllocateCursorStatements |
| DAALOCK | DAXALOCK | LockRequestCount |
| DAALOCL | DAXALOCL | AssociateLocatorStatements |
| DAALPRO | DAXALPRO | AlterProcedures |
| DAALTIX | DAXALTIX | AlterIndexStatements |
| DAXALTS | DAXALTSQ | AlterSequences |
| DAALTST | DAXALTST | AlterStrggrpStatements |
| DAALTTA | DAXALTTA | AlterTableStatements |
| DAALTTS | DAXALTTS | AlterTablespaceStatements |
| DAXALTV | DAXALTVW | AlterViewStatements |
| DAALUDF | DAXALUDF | AlterFunctions |
| DAANPL | DAXANPL | MaximumPageLocksHeld |
| DAAPREC | DAXAPREC | HowLimitWasDetermined |
| DAAQRY | DAXAQRY | QueryRequestCount |
| DAARLID | DAXARLID | ResourceLimitTableId |
| DAASLAT | DAXASLAT | SuspendCount(latchConflict) |
| DAASLMT | DAXASLMT | LimitInServiceUnits |
| DAASLOC | DAXASLOC | SuspendCount(lockConflict) |
| DAASOTH | DAXASOTH | SuspendCount(otherConflict) |
| DAATIM | DAXATIM | LockTimeoutCount |
| DAAUNLK | DAXAUNLK | UnlockRequestCount |
| DACASCD | DAXCASCD | MaxLevelOfNestedSqlCascading |
| DACAUD | DAXCAUD | UserDefinedFunctionsExecuted |
| DACAUDA | DAXCAUDA | UserDefinedFunctionsAbended |
| DACAUDR | DAXCAUDR | UserDefinedFunctionsRejected |
| DACAUDT | DAXCAUDT | UserDefinedFunctionsTimedOut |
| DACBPNX | DAXCBPNX | ParaGrpsIntendedForDataSharinGrp |
| DACDIST | DAXCDIST | CreateDistinctType |
| DACLOSE | DAXCLOSE | CloseCursorStatements |
| DACMTON | DAXCMTON | CommentOnStatements |
| DACON1 | DAXCON1 | ConnectType-1Statements |
| DACON2 | DAXCON2 | ConnectType-2Statements |
| DACORNO | DAXCORNO | ParaGrpsRunOn1Db2(noCoord) |
| DACRALS | DAXCRALS | CreateAliasStatements |
| DACRATB | DAXCRATB | CreateAuxTables |
| DACRDAB | DAXCRDAB | CreateDatabaseStatements |
| DAXCRES | DAXCRESQ | CreateSequences |
| DACRGTT | DAXCRGTT | CreateTemporaryGlobalTables |
| DACRINX | DAXCRINX | CreateIndexStatements |
| DACRPRO | DAXCRPRO | CreateProcedures |
| DACRSTG | DAXCRSTG | CreateStrggrpStatements |
| DACRSYN | DAXCRSYN | CreateSynonymStatements |
| DACRTAB | DAXCRTAB | CreateTableStatements |
| DACRUDF | DAXCRUDF | CreateFunctions |
| DACSKIP | DAXCSKIP | TimesDb2SkippedForPara(bpShrtg) |
| DACTABS | DAXCTABS | CreateTablespaceStatements |
| DACTRIG | DAXCTRIG | CreateTriggers |
| DAXDCLG | DAXDCLGT | DeclareGlobalTemporaryTablStmts |
| DADDIST | DAXDDIST | DropDistinctType |
| DADEFVU | DAXDEFVU | CreateViewStatements |
| DAXDEGD | DAXDEGDT | ParalGrpsInUdfQblkW/declTempTbl |
| DADELET | DAXDELET | DeleteStatements |
| DADESC | DAXDESC | DescribeStatements |
| DADGBUF | DAXDGBUF | ParallelGroupsFell(bpShortage) |
| DADGCUR | DAXDGCUR | ParallelGroupsFell(updtCsr) |
| DADGESA | DAXDGESA | ParallelGrpsFell(noEsaSrtSupp) |
| DAXDROS | DAXDROSQ | DropSequences |
| DADRPAL | DAXDRPAL | DropAliasStatements |
| DADRPDB | DAXDRPDB | DropDatabaseStatements |
| DADRPIX | DAXDRPIX | DropIndexStatements |
| DADRPKG | DAXDRPKG | DropPackageStatements |
| DADRPPR | DAXDRPPR | DropProcedure |
| DADRPST | DAXDRPST | DropStrggrpStatements |
| DADRPSY | DAXDRPSY | DropSynonymStatements |
| DADRPTA | DAXDRPTA | DropTableStatements |
| DADRPTR | DAXDRPTR | DropTriggers |
| DADRPTS | DAXDRPTS | DropTablespaceStatements |
| DADRPUD | DAXDRPUD | DropUserDefinedFunc |
| DADRPVU | DAXDRPVU | DropViewStatements |
| DADSCTB | DAXDSCTB | DescribeTablesStatements |
| DAFETCH | DAXFETCH | FetchStatements |
| DAFREEL | DAXFREEL | FreeLocators |
| DAGRANT | DAXGRANT | GrantsStatements |
| DAHOLDL | DAXHOLDL | HoldLocators |
| DAINCRB | DAXINCRB | IncremntalBinds(exludesPrepares) |
| DAINSRT | DAXINSRT | InsertStatements |
| DAISORR | DAXISORR | ParaGrpsRunOn1Db2(rr/rsIso) |
| DALABON | DAXLABON | LabelOnStatements |
| DALOBV | DAXLOBV | MaxStorageForLobValues |
| DALOCK | DAXLOCK | LockTableStatements |
| DAMIAP | DAXMIAP | TimesMultiIndexAccessPathUsed |
| DAMRMIP | DAXMRMIP | TimesMiapNotUsedRidsMaxAllowed |
| DAMXDEG | DAXMXDEG | MaxDegreeOfParallelism |
| DANRGRP | DAXNRGRP | ParallelGrpsExecAtSameDegree |
| DANSMIP | DAXNSMIP | TimesMiapNotUsedStrgNotAvail |
| DAOPEN | DAXOPEN | OpenCursorStatements |
| DAPREP | DAXPREP | PreparesStatements |
| DAXPRES | DAXPRESI | PrepareWhereIndxUseRestrictd/pendg |
| DARDGRP | DAXRDGRP | ParallelGroupsReduced |
| DAREL | DAXREL | ReleaseStatements |
| DAREVOK | DAXREVOK | RevokeStatements |
| DARNTAB | DAXRNTAB | RenameTables |
| DAROIIX | DAXROIIX | TimesDirRowAccessRevertedToIndex |
| DAROIMA | DAXROIMA | TimesDirectRowAccessSuccessful |
| DAROITS | DAXROITS | TimesDirRowAccessRevertedToTscan |
| DAROWTR | DAXROWTR | TimesRowTriggerActivated |
| DARPOP1 | DAXRPOP1 | ParaGrpsReformulatedSysplex |
| DARPOP2 | DAXRPOP2 | ParaGrpsReformulatedBp |
| DAXAJST | DAXSAJST | DistAddressSpaceTcbTime |
| DAXAPRC | DAXSAPRC | DistAddressSpaceProcName |
| DAXASCB | DAXSASCB | DistAddressSpaceAscbToken |
| DAXASID | DAXSASID | DistAddressSpaceAsid |
| DAXASRB | DAXSASRB | DistAddressSpaceSrbTime |
| DASAUF | DAXSAUF | AuthorizationFailures |
| DASDDL | DAXSDDL | DdlAgainstAuditedObject |
| DASELEC | DAXSELEC | SelectStatements |
| DAXSETC | DAXSETCP | SetCurrentPrecisionStatements |
| DASETHV | DAXSETHV | SetHost-varStatements |
| DAXSPSR | DAXSPSRB | DistAddressSpacePreemptableSrb |
| DASTCAB | DAXSTCAB | StoredProcedureAbends |
| DASTCAL | DAXSTCAL | SqlCallStatements |
| DASTCDG | DAXSTCDG | SetCurrentDegreeStatements |
| DAXTCON | DAXSTCON | SetConnectionStatements |
| DASTCRJ | DAXSTCRJ | SqlCallRejects |
| DASTCRL | DAXSTCRL | SetCurrentRulesStatements |
| DASTCTO | DAXSTCTO | SqlCallTimeouts |
| DASTDEX | DAXSTDEX | PrepsDiscarded(maxkeepdExceeded) |
| DASTDGE | DAXSTDGE | ParallelGroupsInSeqmode |
| DASTDIN | DAXSTDIN | PrepsDiscarded(invalidated) |
| DASTFND | DAXSTFND | PreparesSatisfiedFromCache |
| DASTIPR | DAXSTIPR | PrepsNotFromCache(noValidCopy) |
| DASTNFD | DAXSTNFD | PreparesNotSatisfiedFromCache |
| DASTNPR | DAXSTNPR | PrepsFromCache(copyFound) |
| DASTPTH | DAXSTPTH | SetCurrentPath |
| DASTREO | DAXSTREO | Reoptimizations |
| DASTSQL | DAXSTSQL | SetSqlidStatements |
| DASTTRG | DAXSTTRG | TimesStatementTriggerActivated |
| DAXSZSR | DAXSZSRB | DistAddressSpacePreemptableSrbZiip |
| DATOGRP | DAXTOGRP | ParallelGroupsExecuted |
| DATRGER | DAXTRGER | TimesTriggerSqlErrorOccurred |
| DAUPDTE | DAXUPDTE | UpdateStatements |
| DAPCT | DAZPCT | MaximumAlliedThreads |
| DAPDSMX | DAZPDSMX | MaximumOpendDataSets |
| DAPEDPL | DAZPEDPL | MaxSizeOfEdmPool |
| DAPIDB | DAZPIDB | MaximumBatch/stcIdentifies |
| DAPIDF | DAZPIDF | MaximumTsoThreads |
| DAPLKTS | DAZPLKTS | MaximumPageLocksPerTablespace |
| DAPLKUS | DAZPLKUS | MaximumPageLocksPerApplication |
| DAPLOGL | DAZPLOGL | LogLoadParmWhenToCheckpoint |
| DAPNAME | DAZPNAME | DsnzparmName |
| DAPRID | DAZPRID | MaxSizeOfRidPool |
| DAPRINT | DAZPRINT | RecordingIntervalInMinutes |
| DAPRLIM | DAZPRLIM | TimeLastIsrWasCutInMin |
| DAPRLIS | DAZPRLIS | TimeLastIsrWasCutStck |
| DAPRMA | DAZPRMA | MaxActiveRemoteThreads |
| DAPRMC | DAZPRMC | MaxConcurRemoteThreads |
| DAPRMIN | DAZPRMIN | TimeThisIsrWasCutInMin |
| DAPSORT | DAZPSORT | MaxSizeOfSortPool |
| DAPTOUT | DAZPTOUT | MaxLockTimeoutValue |
| DURATION | DURATM | Duration |
| ELAPSTM | ELAPSTM | ThreadElapsedTime |
| DATETIME | ENDTIME | Datetime |
| HCAID | HCAID | AuthorizationId |
| HCATYP | HCATYP | ConnectingSystemTypeCode |
| HCCN | HCCN | ConnectionId |
| HCCV | HCCV | CorrelationId |
| HCOPID | HCOPID | OriginalOperatorId |
| HCPLAN | HCPLAN | PlanName |
| HCTOKN | HCTOKN | UniqueTokenPerTrans |
| HDPRID | HDPRID | ApplicationRequestorProdId |
| HDRQNM | HDRQNM | RequestorLocationName |
| HDSVNM | HDSVNM | SrvnamParmOfDrdaExcsat |
| HDTSTP | HDTSTP | DbatTraceRecordTimestamp |
| HSACE | HSACE | AceAddress |
| HSIID | HSIID | IfcidInstrumentationId |
| HSISEQ | HSISEQ | SequenceNumberForInstrumentation |
| HSLOCN | HSLOCN | LocalLocationName |
| HSLUCC | HSLUCC | CommitCountForThread |
| HSLUNM | HSLUNM | LuName |
| HSLUUV | HSLUUV | InstanceNumberForThread |
| HSNID | HSNID | NetworkId |
| HSRMID | HSRMID | ResourceManagerId |
| HSRN | HSRN | Db2ReleaseNumber |
| HSSSID | HSSSID | Db2SubsystemName |
| HSSTCK | HSSTCK | StoreClockValueForHeader |
| HSWSEQ | HSWSEQ | SequenceNumberForDestination |
| HUCNT | HUCNT | CountFieldInCpuHeader |
| HUCPUTM | HUCPUTM | CputimeOfMvsTcb/srbDispatched |
| JOB | JOB | JobNameOrTsoUser |
| LMRKFLG | LMRKFLG1 | GlobalControlFlagnr1 |
| LSTPDATE | LSTPDATE | LastProcessDate |
| OCURDA | OCURDA | DaRecordsCount |
| SHFTIND | SHFTINDC | ShiftIndicator |
| SSSID | SSSID | Db2SubsystemName |
| MACHINE | SYSTEM | Machine |
| ZDATE | ZDATE | DateObservationCreated |
Note: Differences between MXG and ITRM column names are highlighted in yellow
Top of PageComputed Columns
| ITRM Column Name | Description | Expression |
|---|---|---|
| DATETIMEFIFTEENMIN | DatetimeFifteenMinute | Formula:DatetimeFifteenMinute |
| DATETIMEFIVEMIN | DatetimeFiveMinute | Formula:DatetimeFiveMinute |
| DATETIMEONEMIN | DatetimeOneMinute | Formula:DatetimeOneMinute |
| DATETIMETENMIN | DatetimeTenMinute | Formula:DatetimeTenMinute |
| DATETIMETHIRTYMIN | DatetimeThirtyMinute | Formula:DatetimeThirtyMinute |
| DATETIMETWENTYMIN | DatetimeTwentyMinute | Formula:DatetimeTwentyMinute |
| DAYDATE | DayDate | Formula:DayDate |
| DAYOFMONTH | DayOfMonth | Formula:DayOfMonth |
| DAYOFWEEK | DayOfWeek | Formula:DayOfWeek |
| HOUR | Hour | Formula:Hour |
| MONTHDATE | MonthDate | Formula:MonthDate |
| SHIFT | Shift | Formula:Shift |
| TIME | Time | Formula:Time |
| WEEKDATE | WeekDate | Formula:WeekDate |
| YEARDATE | YearDate | Formula:YearDate |
v1.0 04MAR2011