Table/Structure Field list used by SAP ABAP Function Module DB02N_CONVERT_MONI_DB2 (DB02N_CONVERT_MONI_DB2)
SAP ABAP Function Module
DB02N_CONVERT_MONI_DB2 (DB02N_CONVERT_MONI_DB2) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CCDL_OUTTS - STORDATE | Date when the storage information has been collected | ||
| 2 | DB2CCDL_OUTTS - STORTIME | Time when the storage information has been collected | ||
| 3 | DB2DB02CONTROL - PARAM | Field of length 16 | ||
| 4 | DB2DB02CONTROL - VALUE1 | Field of length 16 | ||
| 5 | DB2DB02CONTROL - VALUE1 | Field of length 16 | SOURCE VALUE(CONVERT_TO_VERSION) LIKE DB2DB02CONTROL-VALUE1 OPTIONAL |
|
| 6 | DB2DB02CONTROL - VALUE2 | Field of length 16 | ||
| 7 | DB2DB02CONTROL - VALUE5 | 128 character | ||
| 8 | DB2DB02EXTENTS - CREATOR | DB2 creator name | ||
| 9 | DB2DB02EXTENTS - EXTENTS | Number of extents | ||
| 10 | DB2DB02EXTENTS - PARTNR | Number of partition | ||
| 11 | DB2DB02EXTENTS - QUAL1 | First part of name qualifiying the object that got ext.alert | ||
| 12 | DB2DB02EXTENTS - QUAL2 | Sec. part of name qualifiying the object that got ext. alert | ||
| 13 | DB2DB02IXSIZE - DASD_USAGE | Actual DASD usage (in KB) of dataset | ||
| 14 | DB2DB02IXSIZE - IXCREATOR | DB2 creator name | ||
| 15 | DB2DB02IXSIZE - IXNAME | Name of a DB2 for OS/390 index | ||
| 16 | DB2DB02IXSIZE - PARTITIONS | Number of partitions of a tablespace or index | ||
| 17 | DB2DB02IXSIZE - PART_EXTENSION | Extension or Partition (non-partitioned TS) number | ||
| 18 | DB2DB02IXSIZE - STORDATE | Date when the storage information has been collected | ||
| 19 | DB2DB02IXSIZE - STORTIME | Time when the storage information has been collected | ||
| 20 | DB2DB02IX_SUM - IXCREATOR | DB2 creator name | ||
| 21 | DB2DB02IX_SUM - IXNAME | Name of a DB2 for OS/390 index | ||
| 22 | DB2DB02IX_SUM - MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 23 | DB2DB02IX_SUM - STORDATE | Date when the storage information has been collected | ||
| 24 | DB2DB02IX_SUM - STORTIME | Time when the storage information has been collected | ||
| 25 | DB2DB02IX_SUM - SUM_ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 26 | DB2DB02IX_SUM - SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | ||
| 27 | DB2DB02IX_SUM - SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | ||
| 28 | DB2DB02IX_SUM - SUM_FREESIZE | Free size of an index in KB (allocated minus used storage) | ||
| 29 | DB2DB02IX_SUM - TSNAME | Name of the tablespace | ||
| 30 | DB2DB02LOB - BASE_TS_DBNAME | Name of the database where the base table resides | ||
| 31 | DB2DB02LOB - BASE_TS_TSNAME | Name of the tablespace where the base table resides | ||
| 32 | DB2DB02LOB - LOB_TS_DBNAME | Database name | ||
| 33 | DB2DB02LOB - LOB_TS_TSNAME | Name of the tablespace | ||
| 34 | DB2DB02SUMMARY - REFRDATE | Date of last refresh of transaction DB02 | ||
| 35 | DB2DB02SUMMARY - REFRTIME | Time of the last refresh of transaction DB02 | ||
| 36 | DB2DB02TSDYN - CREATOR | DB2 creator name | ||
| 37 | DB2DB02TSDYN - DBNAME | Database name | ||
| 38 | DB2DB02TSDYN - PART_NR | Partition number | ||
| 39 | DB2DB02TSDYN - TSNAME | Name of the tablespace | ||
| 40 | DB2DB02TSSIZE - CREATOR | DB2 creator name | ||
| 41 | DB2DB02TSSIZE - DASD_USAGE | Actual DASD usage (in KB) of dataset | ||
| 42 | DB2DB02TSSIZE - DBNAME | Database name | ||
| 43 | DB2DB02TSSIZE - PARTITIONS | Number of partitions of a tablespace or index | ||
| 44 | DB2DB02TSSIZE - PART_EXTENSION | Extension or Partition (non-partitioned TS) number | ||
| 45 | DB2DB02TSSIZE - STORDATE | Date when the storage information has been collected | ||
| 46 | DB2DB02TSSIZE - STORTIME | Time when the storage information has been collected | ||
| 47 | DB2DB02TSSIZE - TSNAME | Name of the tablespace | ||
| 48 | DB2DB02TS_HIS - DBNAME | Database name | ||
| 49 | DB2DB02TS_HIS - PART_EXTENSION | Extension or Partition (non-partitioned TS) number | ||
| 50 | DB2DB02TS_HIS - STORDATE | Date when the storage information has been collected | ||
| 51 | DB2DB02TS_HIS - TSNAME | Name of the tablespace | ||
| 52 | DB2DB02TS_SUM - BASE_TS_DBNAME | Database name | ||
| 53 | DB2DB02TS_SUM - BASE_TS_TSNAME | Name of the tablespace | ||
| 54 | DB2DB02TS_SUM - CREATOR | DB2 creator name | ||
| 55 | DB2DB02TS_SUM - DBNAME | Database name | ||
| 56 | DB2DB02TS_SUM - MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 57 | DB2DB02TS_SUM - STORDATE | Date when the storage information has been collected | ||
| 58 | DB2DB02TS_SUM - STORTIME | Time when the storage information has been collected | ||
| 59 | DB2DB02TS_SUM - SUM_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 60 | DB2DB02TS_SUM - SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | ||
| 61 | DB2DB02TS_SUM - SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | ||
| 62 | DB2DB02TS_SUM - SUM_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 63 | DB2DB02TS_SUM - TSNAME | Name of the tablespace | ||
| 64 | DB2DBSIZH - ADATE | Date of last refresh of transaction DB02 | ||
| 65 | DB2DBSIZH - ATIME | Time of the last refresh of transaction DB02 | ||
| 66 | DB2DSVOL - DSNAME | Dataset name | ||
| 67 | DB2DSVOL - VOLUME | Serial number of the volume | ||
| 68 | DB2EXTMON - PARTITION | Number of partition | ||
| 69 | DB2EXTMON - QUAL1 | First part of name qualifiying the object that got ext.alert | ||
| 70 | DB2EXTMON - QUAL2 | Sec. part of name qualifiying the object that got ext. alert | ||
| 71 | DB2EXTMON - TYPE | Type of object that got an extent alert | ||
| 72 | DB2IXSIZED - ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 73 | DB2IXSIZED - DSNAME | Dataset name | ||
| 74 | DB2IXSIZED - IXCREATOR | DB2 creator name | ||
| 75 | DB2IXSIZED - IXNAME | Name of a DB2 for OS/390 index | ||
| 76 | DB2IXSIZED - STORDATE | Date when the storage information has been collected | ||
| 77 | DB2IXSIZED - STORTIME | Time when the storage information has been collected | ||
| 78 | DB2IXSIZENEW - ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 79 | DB2IXSIZENEW - CREATOR | DB2 creator name | ||
| 80 | DB2IXSIZENEW - DSNAME | Dataset name | ||
| 81 | DB2IXSIZENEW - EXTENTS | Total number of extents of a tablespace or index | ||
| 82 | DB2IXSIZENEW - FREESIZE | Free size of an index in KB (allocated minus used storage) | ||
| 83 | DB2IXSIZENEW - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 84 | DB2IXSIZENEW - NAME | Name of a DB2 for OS/390 index | ||
| 85 | DB2IXSIZENEW - PARTITIONS | Number of partitions of a tablespace or index | ||
| 86 | DB2IXSIZENEW - STORDATE | Date when the storage information has been collected | ||
| 87 | DB2IXSIZENEW - STORTIME | Time when the storage information has been collected | ||
| 88 | DB2IXSIZENEW - TBCREATOR | Authorization ID of the owner of the table | ||
| 89 | DB2IXSIZENEW - TBNAME | Name of the table on which the index is defined | ||
| 90 | DB2IXSIZEP - ALLOCSIZE | Allocated storage of a partition of an index in KB | ||
| 91 | DB2IXSIZEP - IXCREATOR | DB2 creator name | ||
| 92 | DB2IXSIZEP - IXNAME | Name of a DB2 for OS/390 index | ||
| 93 | DB2IXSIZEP - PART | Partition number | ||
| 94 | DB2IXSIZEP - STORDATE | Date when the storage information has been collected | ||
| 95 | DB2IXSIZEP - STORTIME | Time when the storage information has been collected | ||
| 96 | DB2TBIXSUM - MONI_VER | Version marker for DB02's data stored in table MONI | ||
| 97 | DB2TBIXSUM - REFRDATE | Date of last refresh of transaction DB02 | ||
| 98 | DB2TBIXSUM - REFRTIME | Time of the last refresh of transaction DB02 | ||
| 99 | DB2TBLIST - CREATOR | DB2 creator name | ||
| 100 | DB2TBLIST - NAME | DB2 table name | ||
| 101 | DB2TBLIST - TSNAME | Name of the tablespace | ||
| 102 | DB2TSDYN - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 103 | DB2TSDYN - DBNAME | Database name | ||
| 104 | DB2TSDYN - NAME | Name of the tablespace | ||
| 105 | DB2TSDYN - PART | Partition number | ||
| 106 | DB2TSDYNO - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 107 | DB2TSDYNO - DBNAME | Database name | ||
| 108 | DB2TSDYNO - NAME | Name of the tablespace | ||
| 109 | DB2TSDYNO - PART | Partition number | ||
| 110 | DB2TSHISRG - ANZDAYS | DB2TSHISRG-ANZDAYS | ||
| 111 | DB2TSHISRG - ANZMONTHS | DB2TSHISRG-ANZMONTHS | ||
| 112 | DB2TSHISRG - ANZWEEKS | DB2TSHISRG-ANZWEEKS | ||
| 113 | DB2TSHISRG - FIRSTDAY | DB2TSHISRG-FIRSTDAY | ||
| 114 | DB2TSHISRG - FIRSTMONTH | DB2TSHISRG-FIRSTMONTH | ||
| 115 | DB2TSHISRG - FIRSTWEEK | DB2TSHISRG-FIRSTWEEK | ||
| 116 | DB2TSHISRG - LASTDAY | DB2TSHISRG-LASTDAY | ||
| 117 | DB2TSHISRG - LASTMONTH | DB2TSHISRG-LASTMONTH | ||
| 118 | DB2TSHISRG - LASTWEEK | DB2TSHISRG-LASTWEEK | ||
| 119 | DB2TSHIS_O - DBNAME | Database name | ||
| 120 | DB2TSHIS_O - NAME | Name of the tablespace | ||
| 121 | DB2TSHIS_O - PART | Partition number | ||
| 122 | DB2TSHIS_O - STORDATE | Date when the storage information has been collected | ||
| 123 | DB2TSSIZED - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 124 | DB2TSSIZED - DBNAME | Database name | ||
| 125 | DB2TSSIZED - DSNAME | Dataset name | ||
| 126 | DB2TSSIZED - STORDATE | Date when the storage information has been collected | ||
| 127 | DB2TSSIZED - STORTIME | Time when the storage information has been collected | ||
| 128 | DB2TSSIZED - TSNAME | Name of the tablespace | ||
| 129 | DB2TSSIZEO - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 130 | DB2TSSIZEO - DBNAME | Database name | ||
| 131 | DB2TSSIZEO - DSNAME | Dataset name | ||
| 132 | DB2TSSIZEO - EXTENTS | Total number of extents of a tablespace or index | ||
| 133 | DB2TSSIZEO - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 134 | DB2TSSIZEO - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 135 | DB2TSSIZEO - NAME | Name of the tablespace | ||
| 136 | DB2TSSIZEO - PARTITIONS | Number of partitions of a tablespace or index | ||
| 137 | DB2TSSIZEO - STORDATE | Date when the storage information has been collected | ||
| 138 | DB2TSSIZEO - STORTIME | Time when the storage information has been collected | ||
| 139 | DB2TSSIZEP - ALLOCSIZE | Allocated storage of a partition of a tablespace in KB | ||
| 140 | DB2TSSIZEP - DBNAME | Database name | ||
| 141 | DB2TSSIZEP - PART | Partition number | ||
| 142 | DB2TSSIZEP - STORDATE | Date when the storage information has been collected | ||
| 143 | DB2TSSIZEP - STORTIME | Time when the storage information has been collected | ||
| 144 | DB2TSSIZEP - TSNAME | Name of the tablespace | ||
| 145 | DBCON - CON_NAME | Logical name for a database connection | ||
| 146 | SYST - BATCH | ABAP System Field: Background Processing Active | ||
| 147 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 148 | SYST - UZEIT | ABAP System Field: Current Time of Application Server |