Table/Structure Field list used by SAP ABAP Function Module DB02_CONVERT_MONI_DB2 (DB02_CONVERT_MONI_DB2)
SAP ABAP Function Module 
DB02_CONVERT_MONI_DB2 (DB02_CONVERT_MONI_DB2) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DB2DBSIZH - ADATE | Date of last refresh of transaction DB02 | |
| 2 | Table/Structure Field |
DB2DBSIZH - ATIME | Time of the last refresh of transaction DB02 | |
| 3 | Table/Structure Field |
DB2DBSIZH - IXNUM | Number of indexes in the R/3 system | |
| 4 | Table/Structure Field |
DB2DBSIZH - IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | |
| 5 | Table/Structure Field |
DB2DBSIZH - R3FREE | Total free space in the R/3 System (KB) | |
| 6 | Table/Structure Field |
DB2DBSIZH - R3PCTUSED | Percentage of used size to allocated size of the R/3 System | |
| 7 | Table/Structure Field |
DB2DBSIZH - R3SIZE | Total size allocated by the R/3 System (KB) | |
| 8 | Table/Structure Field |
DB2DBSIZH - TBNUM | Number of tables in the R/3 system | |
| 9 | Table/Structure Field |
DB2DBSIZH - TBSIZE | Total size of all R/3 tables (used storage in KB) | |
| 10 | Table/Structure Field |
DB2DSVOL - DSNAME | Dataset name | |
| 11 | Table/Structure Field |
DB2DSVOL - VOLUME | Serial number of the volume | |
| 12 | Table/Structure Field |
DB2EXTMON - EXTENTS | Number of extents | |
| 13 | Table/Structure Field |
DB2EXTMON - EXTENT_OLD | Number of extents before last ALTER SECQTY | |
| 14 | Table/Structure Field |
DB2EXTMON - LAST_ALTER | Date of last ALTER INDEX|TABLESPACE SECQTY | |
| 15 | Table/Structure Field |
DB2EXTMON - PARTITION | Number of partition | |
| 16 | Table/Structure Field |
DB2EXTMON - QUAL1 | First part of name qualifiying the object that got ext.alert | |
| 17 | Table/Structure Field |
DB2EXTMON - QUAL2 | Sec. part of name qualifiying the object that got ext. alert | |
| 18 | Table/Structure Field |
DB2EXTMON - SEVERITY | Severity of an extent alert | |
| 19 | Table/Structure Field |
DB2EXTMON - TYPE | Type of object that got an extent alert | |
| 20 | Table/Structure Field |
DB2IXSIZE - ALLOCSIZE | Total size of an index (allocated storage in KB) | |
| 21 | Table/Structure Field |
DB2IXSIZE - CREATOR | DB2 creator name | |
| 22 | Table/Structure Field |
DB2IXSIZE - DBNAME | Database name | |
| 23 | Table/Structure Field |
DB2IXSIZE - DSNAME | Dataset name | |
| 24 | Table/Structure Field |
DB2IXSIZE - EXTENTS | Total number of extents of a tablespace or index | |
| 25 | Table/Structure Field |
DB2IXSIZE - FREESIZE | Free size of an index in KB (allocated minus used storage) | |
| 26 | Table/Structure Field |
DB2IXSIZE - IXSPACE | Name of the indexspace that contains the index | |
| 27 | Table/Structure Field |
DB2IXSIZE - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | |
| 28 | Table/Structure Field |
DB2IXSIZE - NAME | Name of a DB2 for OS/390 index | |
| 29 | Table/Structure Field |
DB2IXSIZE - PARTITIONS | Number of partitions of a tablespace or index | |
| 30 | Table/Structure Field |
DB2IXSIZE - PCTUSED | Percentage of used size to allocated size of an index | |
| 31 | Table/Structure Field |
DB2IXSIZE - PQTY | Primary space allocation | |
| 32 | Table/Structure Field |
DB2IXSIZE - QTYUNIT | Unit in which primary and secondary allocation are given | |
| 33 | Table/Structure Field |
DB2IXSIZE - SQTY | Secondary space allocation | |
| 34 | Table/Structure Field |
DB2IXSIZE - STORDATE | Date when the storage information has been collected | |
| 35 | Table/Structure Field |
DB2IXSIZE - STORTIME | Time when the storage information has been collected | |
| 36 | Table/Structure Field |
DB2IXSIZE - TBCREATOR | Authorization ID of the owner of the table | |
| 37 | Table/Structure Field |
DB2IXSIZE - TBNAME | Name of the table on which the index is defined | |
| 38 | Table/Structure Field |
DB2IXSIZED - ALLOCSIZE | Total size of an index (allocated storage in KB) | |
| 39 | Table/Structure Field |
DB2IXSIZED - DBNAME | Database name | |
| 40 | Table/Structure Field |
DB2IXSIZED - DSNAME | Dataset name | |
| 41 | Table/Structure Field |
DB2IXSIZED - EXTENTS | Total number of extents of a tablespace or index | |
| 42 | Table/Structure Field |
DB2IXSIZED - FREESIZE | Free size of an index in KB (allocated minus used storage) | |
| 43 | Table/Structure Field |
DB2IXSIZED - IXCREATOR | DB2 creator name | |
| 44 | Table/Structure Field |
DB2IXSIZED - IXNAME | Name of a DB2 for OS/390 index | |
| 45 | Table/Structure Field |
DB2IXSIZED - IXSPACE | Name of the indexspace that contains the index | |
| 46 | Table/Structure Field |
DB2IXSIZED - PCTUSED | Percentage of used size to allocated size of an index | |
| 47 | Table/Structure Field |
DB2IXSIZED - PQTY | Primary space allocation | |
| 48 | Table/Structure Field |
DB2IXSIZED - QTYUNIT | Unit in which primary and secondary allocation are given | |
| 49 | Table/Structure Field |
DB2IXSIZED - SQTY | Secondary space allocation | |
| 50 | Table/Structure Field |
DB2IXSIZED - STORDATE | Date when the storage information has been collected | |
| 51 | Table/Structure Field |
DB2IXSIZED - STORTIME | Time when the storage information has been collected | |
| 52 | Table/Structure Field |
DB2IXSIZEP - ALLOCSIZE | Allocated storage of a partition of an index in KB | |
| 53 | Table/Structure Field |
DB2IXSIZEP - DBNAME | Database name | |
| 54 | Table/Structure Field |
DB2IXSIZEP - DSNAME | Dataset name | |
| 55 | Table/Structure Field |
DB2IXSIZEP - EXTENTS | Number of extents of a partition of a tablespace or index | |
| 56 | Table/Structure Field |
DB2IXSIZEP - FREESIZE | Free size of an index partition in KB | |
| 57 | Table/Structure Field |
DB2IXSIZEP - IXCREATOR | DB2 creator name | |
| 58 | Table/Structure Field |
DB2IXSIZEP - IXNAME | Name of a DB2 for OS/390 index | |
| 59 | Table/Structure Field |
DB2IXSIZEP - IXSPACE | Name of the indexspace that contains the index | |
| 60 | Table/Structure Field |
DB2IXSIZEP - PART | Partition number | |
| 61 | Table/Structure Field |
DB2IXSIZEP - PCTUSED | Percentage of used to alloc. size of a partition of an IX | |
| 62 | Table/Structure Field |
DB2IXSIZEP - PQTY | Primary space allocation | |
| 63 | Table/Structure Field |
DB2IXSIZEP - QTYUNIT | Unit in which primary and secondary allocation are given | |
| 64 | Table/Structure Field |
DB2IXSIZEP - SQTY | Secondary space allocation | |
| 65 | Table/Structure Field |
DB2IXSIZEP - STORDATE | Date when the storage information has been collected | |
| 66 | Table/Structure Field |
DB2IXSIZEP - STORTIME | Time when the storage information has been collected | |
| 67 | Table/Structure Field |
DB2TBIXSUM - DBSYS | Central Database System | |
| 68 | Table/Structure Field |
DB2TBIXSUM - IXFREE | Total free size of all R/3 indexes in KB | |
| 69 | Table/Structure Field |
DB2TBIXSUM - IXMISSDB | Number of indexes missing in the database | |
| 70 | Table/Structure Field |
DB2TBIXSUM - IXMISSDDIC | Number of indexes missing in the ABAP dictionary | |
| 71 | Table/Structure Field |
DB2TBIXSUM - IXNUM | Number of indexes in the R/3 system | |
| 72 | Table/Structure Field |
DB2TBIXSUM - IXPCTUSED | Percentage of used size to allocated size of all indexes | |
| 73 | Table/Structure Field |
DB2TBIXSUM - IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | |
| 74 | Table/Structure Field |
DB2TBIXSUM - MONI_VER | Version marker for DB02's data stored in table MONI | |
| 75 | Table/Structure Field |
DB2TBIXSUM - MONI_VER | Version marker for DB02's data stored in table MONI | SOURCE VALUE(CONVERT_TO_VERSION) LIKE DB2TBIXSUM-MONI_VER |
| 76 | Table/Structure Field |
DB2TBIXSUM - REFRDATE | Date of last refresh of transaction DB02 | |
| 77 | Table/Structure Field |
DB2TBIXSUM - REFRTIME | Time of the last refresh of transaction DB02 | |
| 78 | Table/Structure Field |
DB2TBIXSUM - SYSID | Name of SAP System | |
| 79 | Table/Structure Field |
DB2TBIXSUM - TBMISSDB | Number of tables missing in the database | |
| 80 | Table/Structure Field |
DB2TBIXSUM - TBMISSDDIC | Number of tables missing in the ABAP/4 dictionary | |
| 81 | Table/Structure Field |
DB2TBIXSUM - TBNUM | Number of tables in the R/3 system | |
| 82 | Table/Structure Field |
DB2TBIXSUM - TBSIZE | Total size of all R/3 tables (used storage in KB) | |
| 83 | Table/Structure Field |
DB2TBIXSUM - TSFREE | Total free size of all R/3 tablespaces in KB | |
| 84 | Table/Structure Field |
DB2TBIXSUM - TSNUM | Number of tablespaces in the R/3 system | |
| 85 | Table/Structure Field |
DB2TBIXSUM - TSPCTUSED | Percentage of used size to allocated size of all tablespaces | |
| 86 | Table/Structure Field |
DB2TBIXSUM - TSSIZE | Total size of all R/3 tablespaces (allocated storage in kB) | |
| 87 | Table/Structure Field |
DB2TSDYN - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | |
| 88 | Table/Structure Field |
DB2TSDYN - DBNAME | Database name | |
| 89 | Table/Structure Field |
DB2TSDYN - D_ALLOCSIZ | Allocated storage in KB: change per day | |
| 90 | Table/Structure Field |
DB2TSDYN - D_EXTENTS | Number of extents: change per day | |
| 91 | Table/Structure Field |
DB2TSDYN - D_FREESIZ | Free storage (allocated minus used) in KB: change per day | |
| 92 | Table/Structure Field |
DB2TSDYN - EXTENTS | Total number of extents of a tablespace or index | |
| 93 | Table/Structure Field |
DB2TSDYN - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | |
| 94 | Table/Structure Field |
DB2TSDYN - M_ALLOCSIZ | Allocated storage in KB: change per month | |
| 95 | Table/Structure Field |
DB2TSDYN - M_EXTENTS | Number of extents: change per month | |
| 96 | Table/Structure Field |
DB2TSDYN - M_FREESIZ | Free storage (allocated minus used) in KB: change per month | |
| 97 | Table/Structure Field |
DB2TSDYN - NAME | Name of the tablespace | |
| 98 | Table/Structure Field |
DB2TSDYN - PART | Partition number | |
| 99 | Table/Structure Field |
DB2TSDYN - PARTITIONS | Number of partitions of a tablespace or index | |
| 100 | Table/Structure Field |
DB2TSDYN - W_ALLOCSIZ | Allocated storage in KB: change per week | |
| 101 | Table/Structure Field |
DB2TSDYN - W_EXTENTS | Number of extents: change per week | |
| 102 | Table/Structure Field |
DB2TSDYN - W_FREESIZ | Free storage (allocated minus used) in KB: change per week | |
| 103 | Table/Structure Field |
DB2TSHIS - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | |
| 104 | Table/Structure Field |
DB2TSHIS - DBNAME | Database name | |
| 105 | Table/Structure Field |
DB2TSHIS - EXTENTS | Total number of extents of a tablespace or index | |
| 106 | Table/Structure Field |
DB2TSHIS - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | |
| 107 | Table/Structure Field |
DB2TSHIS - NAME | Name of the tablespace | |
| 108 | Table/Structure Field |
DB2TSHIS - PART | Partition number | |
| 109 | Table/Structure Field |
DB2TSHIS - PARTITIONS | Number of partitions of a tablespace or index | |
| 110 | Table/Structure Field |
DB2TSHIS - PCTUSED | Percentage of used size to allocated size of a tablespace | |
| 111 | Table/Structure Field |
DB2TSHIS - STORDATE | Date when the storage information has been collected | |
| 112 | Table/Structure Field |
DB2TSSIZE - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | |
| 113 | Table/Structure Field |
DB2TSSIZE - DBNAME | Database name | |
| 114 | Table/Structure Field |
DB2TSSIZE - DSNAME | Dataset name | |
| 115 | Table/Structure Field |
DB2TSSIZE - EXTENTS | Total number of extents of a tablespace or index | |
| 116 | Table/Structure Field |
DB2TSSIZE - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | |
| 117 | Table/Structure Field |
DB2TSSIZE - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | |
| 118 | Table/Structure Field |
DB2TSSIZE - NAME | Name of the tablespace | |
| 119 | Table/Structure Field |
DB2TSSIZE - PARTITIONS | Number of partitions of a tablespace or index | |
| 120 | Table/Structure Field |
DB2TSSIZE - PCTUSED | Percentage of used size to allocated size of a tablespace | |
| 121 | Table/Structure Field |
DB2TSSIZE - PQTY | Primary space allocation | |
| 122 | Table/Structure Field |
DB2TSSIZE - QTYUNIT | Unit in which primary and secondary allocation are given | |
| 123 | Table/Structure Field |
DB2TSSIZE - SQTY | Secondary space allocation | |
| 124 | Table/Structure Field |
DB2TSSIZE - STORDATE | Date when the storage information has been collected | |
| 125 | Table/Structure Field |
DB2TSSIZE - STORTIME | Time when the storage information has been collected | |
| 126 | Table/Structure Field |
DB2TSSIZED - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | |
| 127 | Table/Structure Field |
DB2TSSIZED - DBNAME | Database name | |
| 128 | Table/Structure Field |
DB2TSSIZED - DSNAME | Dataset name | |
| 129 | Table/Structure Field |
DB2TSSIZED - EXTENTS | Total number of extents of a tablespace or index | |
| 130 | Table/Structure Field |
DB2TSSIZED - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | |
| 131 | Table/Structure Field |
DB2TSSIZED - PCTUSED | Percentage of used size to allocated size of a tablespace | |
| 132 | Table/Structure Field |
DB2TSSIZED - PQTY | Primary space allocation | |
| 133 | Table/Structure Field |
DB2TSSIZED - QTYUNIT | Unit in which primary and secondary allocation are given | |
| 134 | Table/Structure Field |
DB2TSSIZED - SQTY | Secondary space allocation | |
| 135 | Table/Structure Field |
DB2TSSIZED - STORDATE | Date when the storage information has been collected | |
| 136 | Table/Structure Field |
DB2TSSIZED - STORTIME | Time when the storage information has been collected | |
| 137 | Table/Structure Field |
DB2TSSIZED - TSNAME | Name of the tablespace | |
| 138 | Table/Structure Field |
DB2TSSIZEP - ALLOCSIZE | Allocated storage of a partition of a tablespace in KB | |
| 139 | Table/Structure Field |
DB2TSSIZEP - DBNAME | Database name | |
| 140 | Table/Structure Field |
DB2TSSIZEP - DSNAME | Dataset name | |
| 141 | Table/Structure Field |
DB2TSSIZEP - EXTENTS | Number of extents of a partition of a tablespace or index | |
| 142 | Table/Structure Field |
DB2TSSIZEP - FREESIZE | Free size of partition of a tablespace in KB | |
| 143 | Table/Structure Field |
DB2TSSIZEP - PART | Partition number | |
| 144 | Table/Structure Field |
DB2TSSIZEP - PCTUSED | Percentage of used to alloc. size of a partition of a TS | |
| 145 | Table/Structure Field |
DB2TSSIZEP - PQTY | Primary space allocation | |
| 146 | Table/Structure Field |
DB2TSSIZEP - QTYUNIT | Unit in which primary and secondary allocation are given | |
| 147 | Table/Structure Field |
DB2TSSIZEP - SQTY | Secondary space allocation | |
| 148 | Table/Structure Field |
DB2TSSIZEP - STORDATE | Date when the storage information has been collected | |
| 149 | Table/Structure Field |
DB2TSSIZEP - STORTIME | Time when the storage information has been collected | |
| 150 | Table/Structure Field |
DB2TSSIZEP - TSNAME | Name of the tablespace | |
| 151 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 152 | Table/Structure Field |
SYST - DBSYS | ABAP System Field: Central Database System | |
| 153 | Table/Structure Field |
SYST - SYSID | ABAP System Field: Name of SAP System | |
| 154 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 155 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
