Table/Structure Field list used by SAP ABAP Program SAPLSDB4CCMS (SAPLSDB4CCMS)
SAP ABAP Program
SAPLSDB4CCMS (SAPLSDB4CCMS) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | AS4ALVPTF - STATUS_TXT | iSeries: PTF Status | SOURCE AS4ALVPTF-STATUS_TXT |
|
| 2 | AS4PTF - LICPGM | iSeries: PTF Product ID | SOURCE AS4PTF-LICPGM |
|
| 3 | AS4PTF - PTFNBR | iSeries: PTF Number | SOURCE AS4PTF-PTFNBR |
|
| 4 | DB4DBJOBS - JOBNAME | iSeries: Job Name (Database Monitor) | SOURCE DB4DBJOBS-JOBNAME |
|
| 5 | DB4DBJOBS - JOBNUM | iSeries: Job Number (Database Monitor) | SOURCE DB4DBJOBS-JOBNUM |
|
| 6 | DB4DBJOBS - JOBUSER | iSeries: Job User (Database Monitor) | SOURCE DB4DBJOBS-JOBUSER |
|
| 7 | DB4DBMCFG - REG_TUNIT | iSeries: Time unit for database monitor dump time interval | SOURCE DB4DBMCFG-REG_TUNIT |
|
| 8 | DB4DBMCFG - REG_DMP_T | iSeries: Time interval for regular dump and merge of DBMon | SOURCE DB4DBMCFG-REG_DMP_T |
|
| 9 | DB4DBMCFG - HST_TUNIT | iSeries: Time unit for database monitor dump time interval | SOURCE DB4DBMCFG-HST_TUNIT |
|
| 10 | DB4DBMCFG - HST_DMP_T | iSeries: Time interval for history dump of database monitor | SOURCE DB4DBMCFG-HST_DMP_T |
|
| 11 | DB4DBMCFG - DUMP_SERV | iSeries: System name of server for DBMon dump execution | SOURCE DB4DBMCFG-DUMP_SERV |
|
| 12 | DB4_RCDLCK - FILE | iSeries: Physical File (Dtabhase Monitor) | SOURCE DB4_RCDLCK-FILE |
|
| 13 | DB4_RCDLCK - LIBRARY | iSeries: Library of Physical File (Database Monitor) | SOURCE DB4_RCDLCK-LIBRARY |
|
| 14 | DB4_RCDLCK - MEMBER | iSeries: Physical Member (Database Monitor) | SOURCE DB4_RCDLCK-MEMBER |
|
| 15 | DB4_RCDLCK - RELRECNO | iSeries: Relative Record Number (Database Monitor) | SOURCE DB4_RCDLCK-RELRECNO |
|
| 16 | DB4_RCDLCK - TBNAME | iSeries: SQL Name of Table or View | SOURCE DB4_RCDLCK-TBNAME |
|
| 17 | SQ1000_DB4 - QQFETT | iSeries: FETCH time (Database Monitor) | SOURCE SQ1000_DB4-QQFETT |
|
| 18 | SQ1000_DB4 - QQSTF | iSeries: Statement Function (Database Monitor) | SOURCE SQ1000_DB4-QQSTF |
|
| 19 | SQ1000_DB4 - QQOTHT | iSeries: Any other time (Database Monitor) | SOURCE SQ1000_DB4-QQOTHT |
|
| 20 | SQ1000_DB4 - QQOPNT | iSeries: Open time (Database Monitor) | SOURCE SQ1000_DB4-QQOPNT |
|
| 21 | SQ1000_DB4 - QQMINT | iSeries: Minimum Time (Database Monitor) | SOURCE SQ1000_DB4-QQMINT |
|
| 22 | SQ1000_DB4 - QQLTU | iSeries: Time Last Used (Database Monitor) | SOURCE SQ1000_DB4-QQLTU |
|
| 23 | SQ1000_DB4 - QQMAXT | iSeries: Maximum Time (Database Monitor) | SOURCE SQ1000_DB4-QQMAXT |
|
| 24 | SQ1000_DB4 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | SOURCE SQ1000_DB4-QQCNT |
|
| 25 | SQ1000_DB4 - QQCLST | iSeries: CLOSE time (Database Monitor) | SOURCE SQ1000_DB4-QQCLST |
|
| 26 | SQ1000_DB4 - QQAVGT | iSeries: Average Time (Database Monitor) | SOURCE SQ1000_DB4-QQAVGT |
|
| 27 | SQHIST_DB4 - QQSRTCNT | iSeries: Number of Sorts (Database Monitor) | SOURCE SQHIST_DB4-QQSRTCNT |
|
| 28 | SQHIST_DB4 - QQSRTTOTR | iSeries: Total Rows Sorted (Database Monitor) | SOURCE SQHIST_DB4-QQSRTTOTR |
|
| 29 | SQHIST_DB4 - QQSRTTTIME | iSeries: Total Time Used by Sorts (Database Monitor) | SOURCE SQHIST_DB4-QQSRTTTIME |
|
| 30 | SQHIST_DB4 - QQSUMCNT | iSeries: Number of Executed SQL Statements | SOURCE SQHIST_DB4-QQSUMCNT |
|
| 31 | SQHIST_DB4 - QQTMFCNT | iSeries: Number of Temporary Files Created | SOURCE SQHIST_DB4-QQTMFCNT |
|
| 32 | SQHIST_DB4 - QQTMFTTIME | iSeries: Total Time Used by Temp. File Creates | SOURCE SQHIST_DB4-QQTMFTTIME |
|
| 33 | SQHIST_DB4 - QQTSCCNT | iSeries: Number of Table Scans | SOURCE SQHIST_DB4-QQTSCCNT |
|
| 34 | SQHIST_DB4 - QQTSCTOTR | iSeries: Total Rows Read by Table Scans | SOURCE SQHIST_DB4-QQTSCTOTR |
|
| 35 | SQHIST_DB4 - QQTSCTTIME | iSeries: Total Time Used by Table Scans | SOURCE SQHIST_DB4-QQTSCTTIME |
|
| 36 | SQHIST_DB4 - QQUPDCNT | iSeries: Number of Executed UPDATEs (Database Monitor) | SOURCE SQHIST_DB4-QQUPDCNT |
|
| 37 | SQHIST_DB4 - QUALITY | iSeries: Hit Ratio | SOURCE SQHIST_DB4-QUALITY |
|
| 38 | SQHIST_DB4 - READPCALL | iSeries: Number of Logical Reads per User Call | SOURCE SQHIST_DB4-READPCALL |
|
| 39 | SQHIST_DB4 - TIMEPCALL | iSeries: Database Processing Time per User Call | SOURCE SQHIST_DB4-TIMEPCALL |
|
| 40 | SQHIST_DB4 - QQSELCNT | iSeries: Number of Executed SELECTs (Database Monitor) | SOURCE SQHIST_DB4-QQSELCNT |
|
| 41 | SQHIST_DB4 - QQRBKCNT | iSeries: Number of Executed ROLLBACKs (Database Monitor) | SOURCE SQHIST_DB4-QQRBKCNT |
|
| 42 | SQHIST_DB4 - QQOTHCNT | iSeries: Number of Miscellaneous Statements | SOURCE SQHIST_DB4-QQOTHCNT |
|
| 43 | SQHIST_DB4 - QQINSCNT | iSeries: Number of Executed INSERTs (Database Monitor) | SOURCE SQHIST_DB4-QQINSCNT |
|
| 44 | SQHIST_DB4 - QQIDCTTIME | iSeries: Total Time Used by Index Creates (Database Monitor) | SOURCE SQHIST_DB4-QQIDCTTIME |
|
| 45 | SQHIST_DB4 - QQIDCCNT | iSeries: Number of Index Creates (Database Monitor) | SOURCE SQHIST_DB4-QQIDCCNT |
|
| 46 | SQHIST_DB4 - QQIDATBCNT | iSeries: Number of Tables over which Indexes are Advised | SOURCE SQHIST_DB4-QQIDATBCNT |
|
| 47 | SQHIST_DB4 - QQIDACNT | iSeries: Index Advice (Database Monitor) | SOURCE SQHIST_DB4-QQIDACNT |
|
| 48 | SQHIST_DB4 - QQDELCNT | iSeries: Number of Executed DELETEs (Database Monitor) | SOURCE SQHIST_DB4-QQDELCNT |
|
| 49 | SQHIST_DB4 - QQDDLCNT | iSeries: Number of Executed DDL Statements | SOURCE SQHIST_DB4-QQDDLCNT |
|
| 50 | SQHIST_DB4 - QQCOMCNT | iSeries: No. of Executed COMMITs (Database Monitor) | SOURCE SQHIST_DB4-QQCOMCNT |
|
| 51 | SQHIST_DB4 - PHYSREAD | iSeries: Number of Physical Reads | SOURCE SQHIST_DB4-PHYSREAD |
|
| 52 | SQHIST_DB4 - LOGICREAD | iSeries: Number of Logical Reads | SOURCE SQHIST_DB4-LOGICREAD |