Table/Structure Field list used by SAP ABAP Program LSDB2CCMS_ANALYSISSUB (DB2 z/OS: DB2 Subsystem Activity)
SAP ABAP Program
LSDB2CCMS_ANALYSISSUB (DB2 z/OS: DB2 Subsystem Activity) is using
pages: 1 2
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2THREADS - SAPSYS | DB2THREADS-SAPSYS | ||
| 2 | DB2THREADS - SQLCNT | The total number of executed SQL statements | ||
| 3 | DB2THREADS - SSPINDB2 | Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) | ||
| 4 | DB2THREADS - THDMLOCKS | DB2THREADS-THDMLOCKS | ||
| 5 | DB2THREADS - THDREQ | Number of Requests Sent to DB2 | ||
| 6 | DB2THREADS - THDSTAT | The status of the thread | ||
| 7 | DB2THREADS - TIMEINDB2 | Percentage of time spent in DB2 | ||
| 8 | DB2THREADS - TXCODE | transaction / thread name | ||
| 9 | DB2THREADS - UPDPAGE | The number of times a buffer update occurs for the agent | ||
| 10 | DB2THREADS - WPID | Work process ID | ||
| 11 | DB2THREADS - WPNUMBER | process ID | ||
| 12 | DB2THREADS - WPTYPE | process type | ||
| 13 | DB2TIMEG - PARCHQ | Archive log quiesce suspension time / time spent in DB2 (%) | ||
| 14 | DB2TIMEG - PARCHQA | Average duration of ARCHIVE LOG QUIESCE suspensions | ||
| 15 | DB2TIMEG - PARCHR | Archive read suspension time / Time spent in DB2 (%) | ||
| 16 | DB2TIMEG - PARCHRA | Average duration of archive read suspensions | ||
| 17 | DB2TIMEG - PCLREL | Claim release suspension time / Time spent in DB2 (%) | ||
| 18 | DB2TIMEG - PCLRELA | Average duration of claim release suspensions | ||
| 19 | DB2TIMEG - PCPUIN | CPU time spent in DB2 / Time spent in DB2 (%) | ||
| 20 | DB2TIMEG - PDRLK | Drain lock suspension time / Time spent in DB2 (%) | ||
| 21 | DB2TIMEG - PDRLKEA | Average duration of drain lock suspensions | ||
| 22 | DB2TIMEG - PDSST | Time dataset service task / time spent in DB2 (%) | ||
| 23 | DB2TIMEG - PDSSTA | Average waiting time for dataset ext./del./def. service task | ||
| 24 | DB2TIMEG - PGLOBTA | Average duration of global locking suspensions | ||
| 25 | DB2TIMEG - PGLOBTM | Global locking suspension time / Time spent in DB2 (%) | ||
| 26 | DB2TIMEG - PIO | I/O suspension time / Time spent in DB2 (%) | ||
| 27 | DB2TIMEG - PIOA | Average duration of I/O suspension | ||
| 28 | DB2TIMEG - PLKLA | Lock (Latch) supension time / Time spent in DB2 (%) | ||
| 29 | DB2TIMEG - PLKLAA | Average duration of lock/latch supensions | ||
| 30 | DB2TIMEG - PLOGWRIT | Percent of time spent in DB2 for log write I/O | ||
| 31 | DB2TIMEG - PLOGWRITA | Average duration of a suspension for log write I/O | ||
| 32 | DB2TIMEG - PNAINDB | Not attributed time in DB2 / Time spent in DB2 | ||
| 33 | DB2TIMEG - PNOTM | Notify messages suspension time / Time spent in DB2 (%) | ||
| 34 | DB2TIMEG - PNOTMA | Average duration of notify messages suspensions | ||
| 35 | DB2TIMEG - POCST | Time for open/close ST / time spent in DB2 (%) | ||
| 36 | DB2TIMEG - POCSTA | Average waiting time for open/close service task | ||
| 37 | DB2TIMEG - POTHR | Other read suspensions time / Time spent in db2 (%) | ||
| 38 | DB2TIMEG - POTHRA | Average duration of other read suspensions | ||
| 39 | DB2TIMEG - POTHRST | Time for other service task / time spent in DB2 (%) | ||
| 40 | DB2TIMEG - POTHRSTA | Average waiting time for other service tasks | ||
| 41 | DB2TIMEG - POTHW | Other write suspensions time / Time spent in DB2 (%) | ||
| 42 | DB2TIMEG - POTHWA | Average duration of other write suspensions | ||
| 43 | DB2TIMEG - PPGLA | Page latch suspension time / Time spent in DB2 (%) | ||
| 44 | DB2TIMEG - PPGLAA | Average duration of page latch suspensions | ||
| 45 | DB2TIMEG - PSLST | Time SYSLGRNG recording service task / time spent in DB2 (%) | ||
| 46 | DB2TIMEG - PSLSTA | Average waiting time for SYSLGRNG recording service task | ||
| 47 | DB2TIMEG - PSRVT | Time commit phase 2 or abort / Time spent in DB2 (%) | ||
| 48 | DB2TIMEG - PSRVTA | Average waiting time for commit phase II or abort | ||
| 49 | DB2TIMEG - PSUSPIN | Time spent suspended in DB2 / Time spent in DB2 (%) | ||
| 50 | DB2TIMES - THDTARCHQ | Archive log quiesce suspension time | ||
| 51 | DB2TIMES - THDTARCHQE | Number of ARCHIVE LOG QUIESCE suspensions | ||
| 52 | DB2TIMES - THDTARCHR | Archive read suspension time | ||
| 53 | DB2TIMES - THDTARCHRE | Number of archive read suspensions | ||
| 54 | DB2TIMES - THDTCLREL | Claim release suspension time | ||
| 55 | DB2TIMES - THDTCLRELE | Number of claim release suspensions | ||
| 56 | DB2TIMES - THDTCPUIN | CPU time spent in DB2 | ||
| 57 | DB2TIMES - THDTDRLK | Drain lock suspension time | ||
| 58 | DB2TIMES - THDTDRLKE | Number of drain lock suspensions | ||
| 59 | DB2TIMES - THDTDSST | Wait time for data set extend/delete/define service task | ||
| 60 | DB2TIMES - THDTDSSTE | Number of waits for data set ext./del./def. service task | ||
| 61 | DB2TIMES - THDTGLOBTE | Number of global locking suspensions | ||
| 62 | DB2TIMES - THDTGLOBTM | Global locking suspension time | ||
| 63 | DB2TIMES - THDTINB2 | Accumulated elapsed time in DB2 | ||
| 64 | DB2TIMES - THDTIO | I/O suspension time | ||
| 65 | DB2TIMES - THDTIOE | Number of I/O suspensions | ||
| 66 | DB2TIMES - THDTLKLA | Lock/latch supension time | ||
| 67 | DB2TIMES - THDTLKLAE | Number of Lock / Latch Suspensions | ||
| 68 | DB2TIMES - THDTLOGW | Log writes suspension time | ||
| 69 | DB2TIMES - THDTLOGWE | Number of log writes | ||
| 70 | DB2TIMES - THDTNAINDB | Not attributed time in DB2 | ||
| 71 | DB2TIMES - THDTNOTM | Notify messages suspension time | ||
| 72 | DB2TIMES - THDTNOTME | Number of notify messages suspensions | ||
| 73 | DB2TIMES - THDTOCST | Wait time for open/close service task (incl. HSM recall) | ||
| 74 | DB2TIMES - THDTOCSTE | Number of waits for open/close service task | ||
| 75 | DB2TIMES - THDTOTHR | Other read suspensions time | ||
| 76 | DB2TIMES - THDTOTHRE | Number of other read suspensions | ||
| 77 | DB2TIMES - THDTOTHRSE | Number of waits for other service tasks | ||
| 78 | DB2TIMES - THDTOTHRST | Wait time for other service tasks | ||
| 79 | DB2TIMES - THDTOTHW | Other write suspensions time | ||
| 80 | DB2TIMES - THDTOTHWE | Number of other write suspensions | ||
| 81 | DB2TIMES - THDTPGLA | Page latch suspension time | ||
| 82 | DB2TIMES - THDTPGLAE | Number of page latch suspensions | ||
| 83 | DB2TIMES - THDTSLST | Wait time for SYSLGRNG recording service task | ||
| 84 | DB2TIMES - THDTSLSTE | Number of waits for SYSLGRNG recording service task | ||
| 85 | DB2TIMES - THDTSRVT | Wait time for DB2 commit phase II processing | ||
| 86 | DB2TIMES - THDTSRVTE | Number of waits for commit phase II or abort | ||
| 87 | DB2TIMES - THDTSUSPIN | Time spent suspended in DB2 | ||
| 88 | DBCON - CON_NAME | Logical name for a database connection | ||
| 89 | LVC_S_FCAT - COLTEXT | ALV control: Column heading | ||
| 90 | LVC_S_FCAT - COL_OPT | Entry for Optional Column Optimization | ||
| 91 | LVC_S_FCAT - COL_POS | ALV control: Output column | ||
| 92 | LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 93 | LVC_S_FCAT - INTTYPE | ABAP data type (C,D,N,...) | ||
| 94 | LVC_S_FCAT - JUST | ALV control: Alignment | ||
| 95 | LVC_S_FCAT - KEY | ALV control: Key field | ||
| 96 | LVC_S_FCAT - LOWERCASE | Lowercase letters allowed/not allowed | ||
| 97 | LVC_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 98 | LVC_S_FCAT - OUTPUTLEN | ALV control: Column width in characters | ||
| 99 | LVC_S_FCAT - ROLLNAME | ALV control: Data element for F1 help | ||
| 100 | LVC_S_FCAT - SELTEXT | ALV control: Column identifier for dialog functions | ||
| 101 | LVC_S_ROW - INDEX | ALV control: Row number (index of internal table) | ||
| 102 | SCREEN - GROUP1 | SCREEN-GROUP1 | ||
| 103 | SCREEN - GROUP2 | SCREEN-GROUP2 | ||
| 104 | SCREEN - INPUT | SCREEN-INPUT | ||
| 105 | SCREEN - INVISIBLE | SCREEN-INVISIBLE | ||
| 106 | SCREEN - NAME | SCREEN-NAME | ||
| 107 | SCXTAB_CONTROL - CURRENT_LINE | SCXTAB_CONTROL-CURRENT_LINE | ||
| 108 | SCXTAB_CONTROL - LINES | SCXTAB_CONTROL-LINES | ||
| 109 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 110 | SYST - DYNNR | ABAP System Field: Current Dynpro Number | ||
| 111 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 112 | SYST - TCODE | ABAP System Field: Current Transaction Code | ||
| 113 | SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | ||
| 114 | SYST - UNAME | ABAP System Field: Name of Current User | ||
| 115 | SYST - UZEIT | ABAP System Field: Current Time of Application Server | ||
| 116 | TREEV_HHDR - HEADING | Tree Control: Text in Length 132 | ||
| 117 | TREEV_HHDR - TOOLTIP | Tree Control: Text in Length 132 | ||
| 118 | TREEV_HHDR - WIDTH | Natural number | ||
| 119 | TREEV_HHDR - WIDTH_PIX | Flag (X or Blank) |