Table/Structure Field list used by SAP ABAP Program /SSA/DDB (SDCC data collectors for databases general)
SAP ABAP Program
/SSA/DDB (SDCC data collectors for databases general) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | /SDF/FLSREQUEST - AVG_READ | /SDF/FLSREQUEST-AVG_READ | ||
| 2 | /SDF/FLSREQUEST - BLK_READS | /SDF/FLSREQUEST-BLK_READS | ||
| 3 | /SDF/FLSREQUEST - FILE_NAME | /SDF/FLSREQUEST-FILE_NAME | ||
| 4 | /SDF/FLSREQUEST - PFAD_NAME | /SDF/FLSREQUEST-PFAD_NAME | ||
| 5 | /SDF/FLSREQUEST - READS | /SDF/FLSREQUEST-READS | ||
| 6 | /SSF/BDLFLDS - CONTEXT | /SSF/BDLFLDS-CONTEXT | ||
| 7 | /SSF/BDLFLDS - SY_DATUM | /SSF/BDLFLDS-SY_DATUM | ||
| 8 | /SSF/BDLFLDS - TH_INSTANCE | /SSF/BDLFLDS-TH_INSTANCE | ||
| 9 | /SSF/BDLFLDS - TH_INSTNO | /SSF/BDLFLDS-TH_INSTNO | ||
| 10 | /SSF/BDLFLDS - TH_SERVER | /SSF/BDLFLDS-TH_SERVER | ||
| 11 | /SSF/BTAB - OBJKEY | /SSF/BTAB-OBJKEY | ||
| 12 | /SSF/BTAB - PID | /SSF/BTAB-PID | ||
| 13 | /SSF/BTAB - PLEN | /SSF/BTAB-PLEN | ||
| 14 | /SSF/LOG - TEXT | /SSF/LOG-TEXT | ||
| 15 | /SSF/LOG - TYPE | /SSF/LOG-TYPE | ||
| 16 | AS4ALVPTF - STATUS | iSeries: PTF Status | ||
| 17 | AUTHB - FILENAME | Physical file name | ||
| 18 | BTCXPM - LENGTH | Length of protocol message in external program | ||
| 19 | BTCXPM - MESSAGE | Log message from external program | ||
| 20 | CVERS - COMPONENT | Software Component | ||
| 21 | CVERS - EXTRELEASE | Patch Level of a Software Component | ||
| 22 | CVERS - RELEASE | SAP Release | ||
| 23 | DB2DSMEM - MEMB_NAME | DB2DSMEM-MEMB_NAME | ||
| 24 | DB2JOB - CREATOR | Creator of the JCL job | ||
| 25 | DB2JOB - JOBCARD | Line of a job | ||
| 26 | DB2JOB - JOBNAME | Name of a JCL job | ||
| 27 | DB2QW0225 - STRGDATE | Field of type DATS | ||
| 28 | DB2QW0225 - STRGTHST | DB2QW0225-STRGTHST | ||
| 29 | DB2QW0225 - STRGTIME | Field of type TIMS | ||
| 30 | DB2THREADS - ASHOST | Application server host name | ||
| 31 | DB2THREADS - DS_MEMBER | DB2THREADS-DS_MEMBER | ||
| 32 | DB2THREADS - WPID | Work process ID | ||
| 33 | DB2TSSIZEO - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 34 | DB2_KPI_SPACE_HISTORY - #AUX | Natural number | ||
| 35 | DB2_KPI_SPACE_HISTORY - #IX | Natural number | ||
| 36 | DB2_KPI_SPACE_HISTORY - #TABLES | Natural number | ||
| 37 | DB2_KPI_SPACE_HISTORY - #TS | Natural number | ||
| 38 | DB4AVGSPC - AVG_DROWS | iSeries: Avarage Growth (Rows) | ||
| 39 | DB4AVGSPC - AVG_DSIZE | iSeries: Avarage Growth (KB) | ||
| 40 | DB4AVGSPC - CURROWS | iSeries: Number of Rows in Table | ||
| 41 | DB4AVGSPC - INDTABNAME | iSeries: Object Name | ||
| 42 | DB4AVGSPC - TABNAME | iSeries: Object Name | ||
| 43 | DB4AVGSPC - TABSIZE | iSeries: Object Size in Kbytes | ||
| 44 | DB4AVGSPC - TAB_IND | iSeries: Indicates if Object Is Table or Index | ||
| 45 | DB4HISTSPC - DELTA_ROWS | iSeries: Delta Rows | ||
| 46 | DB4HISTSPC - DELTA_SIZE | iSeries: Delta Size of Table (KB) | ||
| 47 | DB4HISTSPC - HIST_DATE | iSeries: Analysis Date | ||
| 48 | DB4HISTSPC - TABNAME | iSeries: Object Name | ||
| 49 | DB4HISTSPC - TAB_IND | iSeries: Indicates if Object Is Table or Index | ||
| 50 | DB4OX - INSTNAME | Server Name | ||
| 51 | DB4OX - OBJNAME | Name of an ABAP Dictionary object | ||
| 52 | DB4OX - UPTIME | Text field length 14 | ||
| 53 | DB4SQLNAM - TABNAME | iSeries: Object Name | ||
| 54 | DB4SQR0100 - IPLTIME | Text field length 14 | ||
| 55 | DB4SQR0100 - QQARSS | iSeries: Average Result Set Size (Database Monitor) | ||
| 56 | DB4SQR0100 - QQAVGT | iSeries: Average Time (Database Monitor) | ||
| 57 | DB4SQR0100 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | ||
| 58 | DB4SQR0100 - QQKEY | iSeries: Key Field (Database Monitor) | ||
| 59 | DB4SQR0100 - QQLTU | iSeries: Time Last Used (Database Monitor) | ||
| 60 | DB4SQR0100 - QQPLIB | iSeries: Package/Program Library (Database Monitor) | ||
| 61 | DB4SQR0100 - QQPNAM | iSeries: Package/Program Name (Database Monitor) | ||
| 62 | DB4SQR0100 - QQSTF | iSeries: Statement Function (Database Monitor) | ||
| 63 | DB4SQR0100 - QQSTTX | iSeries: Statement Text (Database Monitor) | ||
| 64 | DB4SQR0100 - SYSID | Name of SAP System | ||
| 65 | DB4SQR0100 - TOTTIME | iSeries: Total Time (Database Monitor) | ||
| 66 | DB4_EXPLAIN - QQDSS | iSeries: Dataspace Selection (Database Monitor) | ||
| 67 | DB4_EXPLAIN - QQI1 | DB4_EXPLAIN-QQI1 | ||
| 68 | DB4_EXPLAIN - QQI3 | DB4_EXPLAIN-QQI3 | ||
| 69 | DB4_EXPLAIN - QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | ||
| 70 | DB4_EXPLAIN - QQIFNM | Index file | ||
| 71 | DB4_EXPLAIN - QQILNM | iSeries: System Name of Index Library (Database Monitor) | ||
| 72 | DB4_EXPLAIN - QQRCOD | Reason code | ||
| 73 | DB4_EXPLAIN - QQTFN | File name | ||
| 74 | DB4_EXPLAIN - QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | ||
| 75 | DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | ||
| 76 | DB6PM_XP - PARTITN | DB6PM_XP-PARTITN | ||
| 77 | DB6XPLOPER - IO_COST | DB6XPLOPER-IO_COST | ||
| 78 | DB6XPLOPER - TOTAL_COST | DB6XPLOPER-TOTAL_COST | ||
| 79 | DB6XPLPRED - HOW_APPLD | DB6XPLPRED-HOW_APPLD | ||
| 80 | DB6XPLSTMT - STMT_TEXT | DB6XPLSTMT-STMT_TEXT | ||
| 81 | DB6XPLSTMT - UPDATABLE | DB6XPLSTMT-UPDATABLE | ||
| 82 | DB6XPLSTRM - STRM_CNT | DB6XPLSTRM-STRM_CNT | ||
| 83 | DBCON - CON_NAME | Logical name for a database connection | ||
| 84 | DBCON - DBMS | Database system | ||
| 85 | DBRELEASE - DBRELEASE | Database release | ||
| 86 | DBSTATHDB4 - CURROWS | Number of rows in a table | ||
| 87 | DBSTATHDB4 - TABNAME | Table name | ||
| 88 | DBSTATHDB4 - TABSIZE | Used blocks of a table in KB | ||
| 89 | DD02V - TABNAME | Table Name | ||
| 90 | DD03P - FIELDNAME | Field Name | ||
| 91 | EXTENTS_TI - DB_OBJECT | Object: Name of table or index | ||
| 92 | FLSREQUEST - AVG_READ | Average Read time | ||
| 93 | FLSREQUEST - BLK_READS | Block Reads | ||
| 94 | FLSREQUEST - FILE_NAME | File name | ||
| 95 | FLSREQUEST - PFAD_NAME | Name of path related to file name | ||
| 96 | FLSREQUEST - READS | Physical Reads | ||
| 97 | FLSYSRQST - AVG_READ | Oracle Monitoring: Average Read | ||
| 98 | FLSYSRQST - BLK_READS | Oracle Monitoring: Block Reads | ||
| 99 | FLSYSRQST - FILE_ID | Oracle monitoring: File of the file containing the extend | ||
| 100 | FLSYSRQST - FILE_NAME | File name | ||
| 101 | FLSYSRQST - INST_ID | Oracle monitor: Instance ID | ||
| 102 | FLSYSRQST - PFAD_NAME | Name of path related to file name | ||
| 103 | FLSYSRQST - READS | Oracle Monitoring: Reads | ||
| 104 | FUPARAREF - FUNCNAME | Name of Function Module | ||
| 105 | FUPARAREF - PARAMETER | Parameter name | ||
| 106 | JCTAB - COUNTER | Number of table entries | ||
| 107 | ORASYSTABH - DATA_LENG | length of the column in bytes | ||
| 108 | ORASYSTABH - DATA_TYPE | datatype of the column | ||
| 109 | ORASYSTABH - ZEILE | char120 | ||
| 110 | SDBAADAHIS - BEGDAT | Date stamp | ||
| 111 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 112 | SYST - DAYST | ABAP System Field: Daylight Saving Time | ||
| 113 | SYST - DBSYS | ABAP System Field: Central Database System | ||
| 114 | SYST - FDPOS | ABAP System Field: Occurrence in Byte or Character String | ||
| 115 | SYST - HOST | ABAP System Field: Name of Current Application Server | ||
| 116 | SYST - INDEX | ABAP System Field: Loop Index | ||
| 117 | SYST - LANGU | ABAP System Field: Language Key of Text Environment | ||
| 118 | SYST - OPSYS | ABAP System Field: Operating System of Application Server | ||
| 119 | SYST - SAPRL | ABAP System Field: SAP System Release | ||
| 120 | SYST - SYSID | ABAP System Field: Name of SAP System | ||
| 121 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 122 | SYST - TZONE | ABAP System Field: Time Zone | ||
| 123 | SYST - UZEIT | ABAP System Field: Current Time of Application Server | ||
| 124 | SYST - ZONLO | ABAP System Field: Time Zone of Current User | ||
| 125 | TRDIR - NAME | ABAP Program Name | ||
| 126 | WPINFOS - APSERVER | Server Name | ||
| 127 | WPINFOS - WP_PID | Process Identification |