SMF DB2 Accounting Aggregation Information

StagedTable_Aggregation ColumnType ColumnName ColumnLabel Statistic Weight ColumnFormat ColumnNotes
XDBACCT - DayDB2BatchSsnAttach Class QWSSSID Subsystem none none none  
    ATTACHTYPE AttachmentType none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDATTACHTYPE SubsystemAttachType none none $CHAR64. trim(Qwsssid)||"-"||attachtype
XDBACCT - DayDB2BatchSsnAttachJob Class QWSSSID Subsystem none none none  
    ATTACHTYPE AttachmentType none none none  
    JOB JobName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed ATTACHTYPEJOB AttachTypeJobName none none $CHAR64. trim(Attachtype)||"-"||job
    DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDATTACHTYPE SubsystemAttachType none none $CHAR64. trim(Qwsssid)||"-"||attachtype
    QWSSSIDATTACHTYPEJOB SubsystemAttachTypeJobName none none $CHAR96. trim(Qwsssid)||"-"||trim(attachtype)||"-"||job
XDBACCT - DayDB2BatchSsnConnid Class QWSSSID Subsystem none none none  
    QMACNAM ConnectionName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDQMACNAM SubsystemConnectionName none none $CHAR64. trim(Qwsssid)||"-"||qmacnam
XDBACCT - DayDB2BatchSsnConnidJob Class QWSSSID Subsystem none none none  
    QMACNAM ConnectionName none none none  
    JOB JobName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QMACNAMJOB ConnectionNameJobName none none $CHAR64. trim(Qmacnam)||"-"||job
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDQMACNAM SubsystemConnectionName none none $CHAR64. trim(Qwsssid)||"-"||qmacnam
    QWSSSIDQMACNAMJOB SubsystemConnectionNameJobName none none $CHAR96. trim(Qwsssid)||"-"||trim(qmacnam)||"-"||job
XDBACCT - DayDB2BatchSsnJob Class QWSSSID Subsystem none none none  
    JOB JobName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDJOB SubsystemJobName none none $CHAR64. trim(Qwsssid)||"-"||job
XDBACCT - DayDB2BatchSsnLocation Class QWSSSID Subsystem none none none  
    QMALOCN LocationName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDQMALOCN SubsystemLocationName none none $CHAR64. trim(Qwsssid)||"-"||qmalocn
XDBACCT - DayDB2BatchSsnPlan Class QWSSSID Subsystem none none none  
    PLAN PlanName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDPLAN SubsystemPlanName none none $CHAR64. trim(Qwsssid)||"-"||plan
XDBACCT - DayDB2BatchSsnPlanJob Class QWSSSID Subsystem none none none  
    PLAN PlanName none none none  
    JOB JobName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QWACASCAVG ElapsedTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWACASCAVG=QWACASCSUM/ACCTCOUNTSUM; else QWACASCAVG=.;
    QWCAJSTAVG CpuTcbTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAJSTAVG=QWCAJSTSUM/ACCTCOUNTSUM; else QWCAJSTAVG=.;
    QWCAWTIAVG ElapsedIoTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTIAVG=QWCAWTISUM/ACCTCOUNTSUM; else QWCAWTIAVG=.;
    QWCAWTLAVG LockLatchTimeInDb2Avg none none TIME12.2 if ACCTCOUNTSUM gt 0 then QWCAWTLAVG=QWCAWTLSUM/ACCTCOUNTSUM; else QWCAWTLAVG=.;
    QWSSSIDPLAN SubsystemPlanName none none $CHAR64. trim(Qwsssid)||"-"||plan
    QWSSSIDPLANJOB SubsystemPlanNameJobName none none $CHAR96. trim(Qwsssid)||"-"||trim(plan)||"-"||job
XDBACCT - DayDB2CicsSsnConnid Class QWSSSID Subsystem none none none  
    QMANETN NetworkName none none none  
    QMACNAM ConnectionName none none none  
    DAYDATE DayDate none none NLDATE10. Ranked
  Id ENVIRONMENT Environment none none none  
    MACHINE Machine none none none  
    NESNAME SystemNetworkName none none none  
    QMALUNM LogicalUnit none none none  
    WEEKDATE WeekDate none none NLDATE10. Ranked
    MONTHDATE MonthDate none none NLDATE10. Ranked
    DAYOFWEEK DayOfWeek none none WKD.  
    DAYOFMONTH DayOfMonth none none 2.0  
  Metric ACCTCOUNT AccountingThreadsCountSum SUM none NLNUM16.0 Ranked
    DBTCBTM CpuTcbTimeTotalSum SUM none TIME12.2 Ranked
    ELAPSTM ElapsedTimeTotalSum SUM none TIME12.2 Ranked
    QTGAIGL IrlmGlobalSuspendsSum SUM none NLNUM16.0  
    QTGALPL PhysicalLockRequestsSum SUM none NLNUM16.0  
    QTGALSL CrossSystemPropagatedLockRequestsSum SUM none NLNUM16.0  
    QTXALES LockEscalationsToSharedSum SUM none NLNUM16.0  
    QTXALEX LockEscalationsToExclusiveSum SUM none NLNUM16.0  
    QTXANPL PeakPhysicalLocksHeldMax MAX none NLNUM16.0 Ranked
    QWACASC ElapsedTimeInDb2Sum SUM none TIME12.2 Ranked
    QWACSUC CpuServiceUnitsRateMax MAX none NLNUM16.3  
    QWCAJST CpuTcbTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCARNE IoWaitsSum SUM none NLNUM16.0 Ranked
    QWCARNL LockLatchWaitsSum SUM none NLNUM16.0 Ranked
    QWCAWTI ElapsedIoTimeInDb2Sum SUM none TIME12.2 Ranked
    QWCAWTL LockLatchTimeInDb2Sum SUM none TIME12.2 Ranked
    QXCALL SqlCallsCountSum SUM none NLNUM16.0  
    QXDELET SqlDeletesCountSum SUM none NLNUM16.0  
    QXELECT SqlSelectsCountSum SUM none NLNUM16.0  
    QXFETCH SqlFetchesCountSum SUM none NLNUM16.0  
    QXINSRT SqlInsertsCountSum SUM none NLNUM16.0  
    QXLOCK SqlTableLockCountSum SUM none NLNUM16.0  
    QXUPDTE SqlUpdatesCountSum SUM none NLNUM16.0  
  Computed DBTCBTMAVG CpuTcbTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then DBTCBTMAVG=DBTCBTMSUM/ACCTCOUNTSUM; else DBTCBTMAVG=.;
    DBTCBTMPCT CpuTcbTimeInDb2Pct none none NLNUM6.2 if DBTCBTMSUM gt 0 then DBTCBTMPCT=(QWCAJSTSUM/DBTCBTMSUM)*100; else DBTCBTMPCT=.;
    ELAPSTMAVG ElapsedTimeAvg none none TIME12.2 if ACCTCOUNTSUM gt 0 then ELAPSTMAVG=ELAPSTMSUM/ACCTCOUNTSUM; else ELAPSTMAVG=.;
    ELAPSTMPCT ElapsedTimeInDb2Pct none none NLNUM6.2 if ELAPSTMSUM gt 0 then ELAPSTMPCT=(QWACASCSUM/ELAPSTMSUM)*100; else ELAPSTMPCT=.;
    ENVIRONMENTMACHINEQWSSSID EnvironmentMachineSubsystem none none $CHAR96. trim(Environment)||"-"||trim(machine)||"-"||qwsssid
    ENVIRONMENTQWSSSID EnvironmentSubsystem none none $CHAR64. trim(Environment)||"-"||qwsssid
    QMANETNQMACNAM NetworkNameConnectionName none none $CHAR64. trim(qmanetn)||"-"||qmacnam