Table/Structure Field list used by SAP ABAP Program B2T2MF03 (New subroutines for version 1)
SAP ABAP Program
B2T2MF03 (New subroutines for version 1) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2DBSIZH - ADATE | Date of last refresh of transaction DB02 | ||
| 2 | DB2DBSIZH - ATIME | Time of the last refresh of transaction DB02 | ||
| 3 | DB2DBSIZH - IXNUM | Number of indexes in the R/3 system | ||
| 4 | DB2DBSIZH - IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | ||
| 5 | DB2DBSIZH - R3FREE | Total free space in the R/3 System (KB) | ||
| 6 | DB2DBSIZH - R3PCTUSED | Percentage of used size to allocated size of the R/3 System | ||
| 7 | DB2DBSIZH - R3SIZE | Total size allocated by the R/3 System (KB) | ||
| 8 | DB2DBSIZH - TBNUM | Number of tables in the R/3 system | ||
| 9 | DB2DBSIZH - TBSIZE | Total size of all R/3 tables (used storage in KB) | ||
| 10 | DB2DSVOL - DSNAME | Dataset name | ||
| 11 | DB2DSVOL - VOLUME | Serial number of the volume | ||
| 12 | DB2IXSIZED - ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 13 | DB2IXSIZED - DBNAME | Database name | ||
| 14 | DB2IXSIZED - DSNAME | Dataset name | ||
| 15 | DB2IXSIZED - EXTENTS | Total number of extents of a tablespace or index | ||
| 16 | DB2IXSIZED - FREESIZE | Free size of an index in KB (allocated minus used storage) | ||
| 17 | DB2IXSIZED - IXCREATOR | DB2 creator name | ||
| 18 | DB2IXSIZED - IXNAME | Name of a DB2 for OS/390 index | ||
| 19 | DB2IXSIZED - IXSPACE | Name of the indexspace that contains the index | ||
| 20 | DB2IXSIZED - PCTUSED | Percentage of used size to allocated size of an index | ||
| 21 | DB2IXSIZED - PQTY | Primary space allocation | ||
| 22 | DB2IXSIZED - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 23 | DB2IXSIZED - SQTY | Secondary space allocation | ||
| 24 | DB2IXSIZED - STORDATE | Date when the storage information has been collected | ||
| 25 | DB2IXSIZED - STORTIME | Time when the storage information has been collected | ||
| 26 | DB2IXSIZENEW - CREATOR | DB2 creator name | ||
| 27 | DB2IXSIZENEW - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 28 | DB2IXSIZENEW - NAME | Name of a DB2 for OS/390 index | ||
| 29 | DB2IXSIZENEW - PARTITIONS | Number of partitions of a tablespace or index | ||
| 30 | DB2IXSIZEO - ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 31 | DB2IXSIZEO - CREATOR | DB2 creator name | ||
| 32 | DB2IXSIZEO - DBNAME | Database name | ||
| 33 | DB2IXSIZEO - DSNAME | Dataset name | ||
| 34 | DB2IXSIZEO - EXTENTS | Total number of extents of a tablespace or index | ||
| 35 | DB2IXSIZEO - FREESIZE | Free size of an index in KB (allocated minus used storage) | ||
| 36 | DB2IXSIZEO - IXSPACE | Name of the indexspace that contains the index | ||
| 37 | DB2IXSIZEO - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 38 | DB2IXSIZEO - NAME | Name of a DB2 for OS/390 index | ||
| 39 | DB2IXSIZEO - PARTITIONS | Number of partitions of a tablespace or index | ||
| 40 | DB2IXSIZEO - PCTUSED | Percentage of used size to allocated size of an index | ||
| 41 | DB2IXSIZEO - PQTY | Primary space allocation | ||
| 42 | DB2IXSIZEO - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 43 | DB2IXSIZEO - SQTY | Secondary space allocation | ||
| 44 | DB2IXSIZEO - STORDATE | Date when the storage information has been collected | ||
| 45 | DB2IXSIZEO - STORTIME | Time when the storage information has been collected | ||
| 46 | DB2IXSIZEO - TBCREATOR | Authorization ID of the owner of the table | ||
| 47 | DB2IXSIZEO - TBNAME | DB2IXSIZEO-TBNAME | ||
| 48 | DB2IXSIZEP - ALLOCSIZE | Allocated storage of a partition of an index in KB | ||
| 49 | DB2IXSIZEP - DBNAME | Database name | ||
| 50 | DB2IXSIZEP - DSNAME | Dataset name | ||
| 51 | DB2IXSIZEP - EXTENTS | Number of extents of a partition of a tablespace or index | ||
| 52 | DB2IXSIZEP - FREESIZE | Free size of an index partition in KB | ||
| 53 | DB2IXSIZEP - IXCREATOR | DB2 creator name | ||
| 54 | DB2IXSIZEP - IXNAME | Name of a DB2 for OS/390 index | ||
| 55 | DB2IXSIZEP - IXSPACE | Name of the indexspace that contains the index | ||
| 56 | DB2IXSIZEP - PART | Partition number | ||
| 57 | DB2IXSIZEP - PCTUSED | Percentage of used to alloc. size of a partition of an IX | ||
| 58 | DB2IXSIZEP - PQTY | Primary space allocation | ||
| 59 | DB2IXSIZEP - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 60 | DB2IXSIZEP - SQTY | Secondary space allocation | ||
| 61 | DB2IXSIZEP - STORDATE | Date when the storage information has been collected | ||
| 62 | DB2IXSIZEP - STORTIME | Time when the storage information has been collected | ||
| 63 | DB2RFCCONN - RFCTBXTHH | DB2 for OS/390: High threshold for extent filtering | ||
| 64 | DB2RFCCONN - RFCTBXTHL | DB2 for OS/390: Low threshold for extent filtering | ||
| 65 | DB2TBIXSUM - IXFREE | Total free size of all R/3 indexes in KB | ||
| 66 | DB2TBIXSUM - IXNUM | Number of indexes in the R/3 system | ||
| 67 | DB2TBIXSUM - IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | ||
| 68 | DB2TBIXSUM - TBNUM | Number of tables in the R/3 system | ||
| 69 | DB2TBIXSUM - TBSIZE | Total size of all R/3 tables (used storage in KB) | ||
| 70 | DB2TBIXSUM - TSFREE | Total free size of all R/3 tablespaces in KB | ||
| 71 | DB2TBIXSUM - TSSIZE | Total size of all R/3 tablespaces (allocated storage in kB) | ||
| 72 | DB2TSDYN - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 73 | DB2TSDYN - DBNAME | Database name | ||
| 74 | DB2TSDYN - D_ALLOCSIZ | Allocated storage in KB: change per day | ||
| 75 | DB2TSDYN - D_EXTENTS | Number of extents: change per day | ||
| 76 | DB2TSDYN - D_FREESIZ | Free storage (allocated minus used) in KB: change per day | ||
| 77 | DB2TSDYN - EXTENTS | Total number of extents of a tablespace or index | ||
| 78 | DB2TSDYN - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 79 | DB2TSDYN - M_ALLOCSIZ | Allocated storage in KB: change per month | ||
| 80 | DB2TSDYN - M_EXTENTS | Number of extents: change per month | ||
| 81 | DB2TSDYN - M_FREESIZ | Free storage (allocated minus used) in KB: change per month | ||
| 82 | DB2TSDYN - NAME | Name of the tablespace | ||
| 83 | DB2TSDYN - PART | Partition number | ||
| 84 | DB2TSDYN - PARTITIONS | Number of partitions of a tablespace or index | ||
| 85 | DB2TSDYN - W_ALLOCSIZ | Allocated storage in KB: change per week | ||
| 86 | DB2TSDYN - W_EXTENTS | Number of extents: change per week | ||
| 87 | DB2TSDYN - W_FREESIZ | Free storage (allocated minus used) in KB: change per week | ||
| 88 | DB2TSDYNO - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 89 | DB2TSDYNO - DBNAME | Database name | ||
| 90 | DB2TSDYNO - D_ALLOCSIZ | Allocated storage in KB: change per day | ||
| 91 | DB2TSDYNO - D_EXTENTS | Number of extents: change per day | ||
| 92 | DB2TSDYNO - D_FREESIZ | Free storage (allocated minus used) in KB: change per day | ||
| 93 | DB2TSDYNO - EXTENTS | Total number of extents of a tablespace or index | ||
| 94 | DB2TSDYNO - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 95 | DB2TSDYNO - M_ALLOCSIZ | Allocated storage in KB: change per month | ||
| 96 | DB2TSDYNO - M_EXTENTS | Number of extents: change per month | ||
| 97 | DB2TSDYNO - M_FREESIZ | Free storage (allocated minus used) in KB: change per month | ||
| 98 | DB2TSDYNO - NAME | Name of the tablespace | ||
| 99 | DB2TSDYNO - PART | Partition number | ||
| 100 | DB2TSDYNO - PARTITIONS | Number of partitions of a tablespace or index | ||
| 101 | DB2TSDYNO - W_ALLOCSIZ | Allocated storage in KB: change per week | ||
| 102 | DB2TSDYNO - W_EXTENTS | Number of extents: change per week | ||
| 103 | DB2TSDYNO - W_FREESIZ | Free storage (allocated minus used) in KB: change per week | ||
| 104 | DB2TSHIS_O - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 105 | DB2TSHIS_O - DBNAME | Database name | ||
| 106 | DB2TSHIS_O - EXTENTS | Total number of extents of a tablespace or index | ||
| 107 | DB2TSHIS_O - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 108 | DB2TSHIS_O - NAME | Name of the tablespace | ||
| 109 | DB2TSHIS_O - PART | Partition number | ||
| 110 | DB2TSHIS_O - PARTITIONS | Number of partitions of a tablespace or index | ||
| 111 | DB2TSHIS_O - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 112 | DB2TSHIS_O - STORDATE | Date when the storage information has been collected | ||
| 113 | DB2TSSIZED - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 114 | DB2TSSIZED - DBNAME | Database name | ||
| 115 | DB2TSSIZED - DSNAME | Dataset name | ||
| 116 | DB2TSSIZED - EXTENTS | Total number of extents of a tablespace or index | ||
| 117 | DB2TSSIZED - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 118 | DB2TSSIZED - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 119 | DB2TSSIZED - PQTY | Primary space allocation | ||
| 120 | DB2TSSIZED - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 121 | DB2TSSIZED - SQTY | Secondary space allocation | ||
| 122 | DB2TSSIZED - STORDATE | Date when the storage information has been collected | ||
| 123 | DB2TSSIZED - STORTIME | Time when the storage information has been collected | ||
| 124 | DB2TSSIZED - TSNAME | Name of the tablespace | ||
| 125 | DB2TSSIZEO - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 126 | DB2TSSIZEO - DBNAME | Database name | ||
| 127 | DB2TSSIZEO - DSNAME | Dataset name | ||
| 128 | DB2TSSIZEO - EXTENTS | Total number of extents of a tablespace or index | ||
| 129 | DB2TSSIZEO - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 130 | DB2TSSIZEO - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 131 | DB2TSSIZEO - NAME | Name of the tablespace | ||
| 132 | DB2TSSIZEO - PARTITIONS | Number of partitions of a tablespace or index | ||
| 133 | DB2TSSIZEO - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 134 | DB2TSSIZEO - PQTY | Primary space allocation | ||
| 135 | DB2TSSIZEO - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 136 | DB2TSSIZEO - SQTY | Secondary space allocation | ||
| 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 - DSNAME | Dataset name | ||
| 142 | DB2TSSIZEP - EXTENTS | Number of extents of a partition of a tablespace or index | ||
| 143 | DB2TSSIZEP - FREESIZE | Free size of partition of a tablespace in KB | ||
| 144 | DB2TSSIZEP - PART | Partition number | ||
| 145 | DB2TSSIZEP - PCTUSED | Percentage of used to alloc. size of a partition of a TS | ||
| 146 | DB2TSSIZEP - PQTY | Primary space allocation | ||
| 147 | DB2TSSIZEP - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 148 | DB2TSSIZEP - SQTY | Secondary space allocation | ||
| 149 | DB2TSSIZEP - STORDATE | Date when the storage information has been collected | ||
| 150 | DB2TSSIZEP - STORTIME | Time when the storage information has been collected | ||
| 151 | DB2TSSIZEP - TSNAME | Name of the tablespace | ||
| 152 | DBCON - CON_NAME | Logical name for a database connection | ||
| 153 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 154 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 155 | SYST - UZEIT | ABAP System Field: Current Time of Application Server |