Table/Structure Field list used by SAP ABAP Program B2T2MF04 (Subroutines for alert processing)
SAP ABAP Program
B2T2MF04 (Subroutines for alert processing) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2DB02CONTROL - PARAM | Field of length 16 | ||
| 2 | DB2DB02CONTROL - VALUE1 | Field of length 16 | ||
| 3 | DB2DB02CONTROL - VALUE2 | Field of length 16 | ||
| 4 | DB2DB02SUMMARY - REFRDATE | Date of last refresh of transaction DB02 | ||
| 5 | DB2DB02SUMMARY - REFRTIME | Time of the last refresh of transaction DB02 | ||
| 6 | DB2DB02TBDYN - CREATOR | DB2 creator name | ||
| 7 | DB2DB02TBDYN - D_SPACEF | Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ||
| 8 | DB2DB02TBDYN - D_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | ||
| 9 | DB2DB02TBDYN - D_TOTALROWS | Number of Rows: changes per day | ||
| 10 | DB2DB02TBDYN - M_SPACEF | Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ||
| 11 | DB2DB02TBDYN - M_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | ||
| 12 | DB2DB02TBDYN - M_TOTALROWS | Number of Rows: changes per month | ||
| 13 | DB2DB02TBDYN - RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | ||
| 14 | DB2DB02TBDYN - SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | ||
| 15 | DB2DB02TBDYN - SPACEF_FIRST | Tx DB02: Absolute difference in comparison to first run | ||
| 16 | DB2DB02TBDYN - SPACEF_LAST | Tx DB02: Absolute difference in comparison to previous run | ||
| 17 | DB2DB02TBDYN - SPACEF_PERC | Tx DB02: Difference (percent) in comparison to previous run | ||
| 18 | DB2DB02TBDYN - TBNAME | Name of the table on which the index is defined | ||
| 19 | DB2DB02TBDYN - TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | ||
| 20 | DB2DB02TBDYN - TBSIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | ||
| 21 | DB2DB02TBDYN - TBSIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | ||
| 22 | DB2DB02TBDYN - TBSIZE_PERC | Tx DB02: Difference (percent) in comparison to previous run | ||
| 23 | DB2DB02TBDYN - TOTALROWS_FIRST | Tx DB02: Absolute difference in comparison to first run | ||
| 24 | DB2DB02TBDYN - TOTALROWS_LAST | Tx DB02: Absolute difference in comparison to previous run | ||
| 25 | DB2DB02TBDYN - TOTALROWS_PERC | Tx DB02: Difference (percent) in comparison to previous run | ||
| 26 | DB2DB02TBDYN - W_SPACEF | Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ||
| 27 | DB2DB02TBDYN - W_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | ||
| 28 | DB2DB02TBDYN - W_TOTALROWS | Number of Rows: changes per week | ||
| 29 | DB2DB02TBSIZE - AVGROWLENGTH | Average row length of table | ||
| 30 | DB2DB02TBSIZE - DBNAME | Database name | ||
| 31 | DB2DB02TBSIZE - PARTITIONS | Number of partitions of a tablespace or index | ||
| 32 | DB2DB02TBSIZE - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 33 | DB2DB02TBSIZE - RTS_ST_CHANGES | RUN.:Changed rows (insert, delete or update) absolute number | ||
| 34 | DB2DB02TBSIZE - RTS_TOTALROWS | Real Time Statistics: Number of rows in Table | ||
| 35 | DB2DB02TBSIZE - SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | ||
| 36 | DB2DB02TBSIZE - STATSTIME | Date and time of last RUNSTATS | ||
| 37 | DB2DB02TBSIZE - STORDATE | Date when the storage information has been collected | ||
| 38 | DB2DB02TBSIZE - STORTIME | Time when the storage information has been collected | ||
| 39 | DB2DB02TBSIZE - TBCREATOR | DB2 creator name | ||
| 40 | DB2DB02TBSIZE - TBNAME | Name of the table on which the index is defined | ||
| 41 | DB2DB02TBSIZE - TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | ||
| 42 | DB2DB02TBSIZE - TSNAME | Name of the tablespace | ||
| 43 | DB2DB02TBSIZE - TS_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 44 | DB2DB02TBSIZE - TS_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 45 | DB2DB02TBTOPGROW - CREATOR | DB2 creator name | ||
| 46 | DB2DB02TBTOPGROW - TBNAME | Name of the table on which the index is defined | ||
| 47 | DB2DB02TS_SUM - DBNAME | Database name | ||
| 48 | DB2DB02TS_SUM - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 49 | DB2DB02TS_SUM - SUM_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 50 | DB2DB02TS_SUM - SUM_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 51 | DB2DB02TS_SUM - TSNAME | Name of the tablespace | ||
| 52 | DB2IXSIZE - ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 53 | DB2IXSIZE - CREATOR | DB2 creator name | ||
| 54 | DB2IXSIZE - DBNAME | Database name | ||
| 55 | DB2IXSIZE - DSNAME | Dataset name | ||
| 56 | DB2IXSIZE - EXTENTS | Total number of extents of a tablespace or index | ||
| 57 | DB2IXSIZE - FREESIZE | Free size of an index in KB (allocated minus used storage) | ||
| 58 | DB2IXSIZE - IXSPACE | Name of the indexspace that contains the index | ||
| 59 | DB2IXSIZE - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 60 | DB2IXSIZE - NAME | Name of a DB2 for OS/390 index | ||
| 61 | DB2IXSIZE - PARTITIONS | Number of partitions of a tablespace or index | ||
| 62 | DB2IXSIZE - PCTUSED | Percentage of used size to allocated size of an index | ||
| 63 | DB2IXSIZE - PQTY | Primary space allocation | ||
| 64 | DB2IXSIZE - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 65 | DB2IXSIZE - SQTY | Secondary space allocation | ||
| 66 | DB2IXSIZE - STORDATE | Date when the storage information has been collected | ||
| 67 | DB2IXSIZE - STORTIME | Time when the storage information has been collected | ||
| 68 | DB2IXSIZE - TBCREATOR | Authorization ID of the owner of the table | ||
| 69 | DB2IXSIZE - TBNAME | Name of the table on which the index is defined | ||
| 70 | DB2IXSIZED - ALLOCSIZE | Total size of an index (allocated storage in KB) | ||
| 71 | DB2IXSIZED - DBNAME | Database name | ||
| 72 | DB2IXSIZED - DSNAME | Dataset name | ||
| 73 | DB2IXSIZED - EXTENTS | Total number of extents of a tablespace or index | ||
| 74 | DB2IXSIZED - FREESIZE | Free size of an index in KB (allocated minus used storage) | ||
| 75 | DB2IXSIZED - IXCREATOR | DB2 creator name | ||
| 76 | DB2IXSIZED - IXNAME | Name of a DB2 for OS/390 index | ||
| 77 | DB2IXSIZED - IXSPACE | Name of the indexspace that contains the index | ||
| 78 | DB2IXSIZED - PCTUSED | Percentage of used size to allocated size of an index | ||
| 79 | DB2IXSIZED - PQTY | Primary space allocation | ||
| 80 | DB2IXSIZED - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 81 | DB2IXSIZED - SQTY | Secondary space allocation | ||
| 82 | DB2IXSIZED - STORDATE | Date when the storage information has been collected | ||
| 83 | DB2IXSIZED - STORTIME | Time when the storage information has been collected | ||
| 84 | DB2IXSIZENEW - CREATOR | DB2 creator name | ||
| 85 | DB2IXSIZENEW - DBNAME | Database name | ||
| 86 | DB2IXSIZENEW - DSNAME | Dataset name | ||
| 87 | DB2IXSIZENEW - IXSPACE | Name of the indexspace that contains the index | ||
| 88 | DB2IXSIZENEW - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 89 | DB2IXSIZENEW - NAME | Name of a DB2 for OS/390 index | ||
| 90 | DB2IXSIZENEW - PARTITIONS | Number of partitions of a tablespace or index | ||
| 91 | DB2IXSIZEP - ALLOCSIZE | Allocated storage of a partition of an index in KB | ||
| 92 | DB2IXSIZEP - DBNAME | Database name | ||
| 93 | DB2IXSIZEP - DSNAME | Dataset name | ||
| 94 | DB2IXSIZEP - EXTENTS | Number of extents of a partition of a tablespace or index | ||
| 95 | DB2IXSIZEP - FREESIZE | Free size of an index partition in KB | ||
| 96 | DB2IXSIZEP - IXCREATOR | DB2 creator name | ||
| 97 | DB2IXSIZEP - IXNAME | Name of a DB2 for OS/390 index | ||
| 98 | DB2IXSIZEP - IXSPACE | Name of the indexspace that contains the index | ||
| 99 | DB2IXSIZEP - PART | Partition number | ||
| 100 | DB2IXSIZEP - PCTUSED | Percentage of used to alloc. size of a partition of an IX | ||
| 101 | DB2IXSIZEP - PQTY | Primary space allocation | ||
| 102 | DB2IXSIZEP - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 103 | DB2IXSIZEP - SQTY | Secondary space allocation | ||
| 104 | DB2IXSIZEP - STORDATE | Date when the storage information has been collected | ||
| 105 | DB2IXSIZEP - STORTIME | Time when the storage information has been collected | ||
| 106 | DB2SAPSYS - DBSCHEMA | DB2 creator name | ||
| 107 | DB2TDUMMY - DB2REL | DB2 release | ||
| 108 | DB2TSHIS - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 109 | DB2TSHIS - DBNAME | Database name | ||
| 110 | DB2TSHIS - EXTENTS | Total number of extents of a tablespace or index | ||
| 111 | DB2TSHIS - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 112 | DB2TSHIS - NAME | Name of the tablespace | ||
| 113 | DB2TSHIS - PART | Partition number | ||
| 114 | DB2TSHIS - PARTITIONS | Number of partitions of a tablespace or index | ||
| 115 | DB2TSHIS - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 116 | DB2TSHIS - STORDATE | Date when the storage information has been collected | ||
| 117 | DB2TSSIZE - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 118 | DB2TSSIZE - DBNAME | Database name | ||
| 119 | DB2TSSIZE - DSNAME | Dataset name | ||
| 120 | DB2TSSIZE - EXTENTS | Total number of extents of a tablespace or index | ||
| 121 | DB2TSSIZE - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 122 | DB2TSSIZE - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 123 | DB2TSSIZE - NAME | Name of the tablespace | ||
| 124 | DB2TSSIZE - PARTITIONS | Number of partitions of a tablespace or index | ||
| 125 | DB2TSSIZE - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 126 | DB2TSSIZE - PQTY | Primary space allocation | ||
| 127 | DB2TSSIZE - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 128 | DB2TSSIZE - SQTY | Secondary space allocation | ||
| 129 | DB2TSSIZE - STORDATE | Date when the storage information has been collected | ||
| 130 | DB2TSSIZE - STORTIME | Time when the storage information has been collected | ||
| 131 | DB2TSSIZED - ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | ||
| 132 | DB2TSSIZED - DBNAME | Database name | ||
| 133 | DB2TSSIZED - DSNAME | Dataset name | ||
| 134 | DB2TSSIZED - EXTENTS | Total number of extents of a tablespace or index | ||
| 135 | DB2TSSIZED - FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 136 | DB2TSSIZED - PCTUSED | Percentage of used size to allocated size of a tablespace | ||
| 137 | DB2TSSIZED - PQTY | Primary space allocation | ||
| 138 | DB2TSSIZED - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 139 | DB2TSSIZED - SQTY | Secondary space allocation | ||
| 140 | DB2TSSIZED - STORDATE | Date when the storage information has been collected | ||
| 141 | DB2TSSIZED - STORTIME | Time when the storage information has been collected | ||
| 142 | DB2TSSIZED - TSNAME | Name of the tablespace | ||
| 143 | DB2TSSIZEO - DBNAME | Database name | ||
| 144 | DB2TSSIZEO - DSNAME | Dataset name | ||
| 145 | DB2TSSIZEO - MAXEXTENTS | Maximum number of extents of a partition of the TS or IX | ||
| 146 | DB2TSSIZEO - NAME | Name of the tablespace | ||
| 147 | DB2TSSIZEO - PARTITIONS | Number of partitions of a tablespace or index | ||
| 148 | DB2TSSIZEP - ALLOCSIZE | Allocated storage of a partition of a tablespace in KB | ||
| 149 | DB2TSSIZEP - DBNAME | Database name | ||
| 150 | DB2TSSIZEP - DSNAME | Dataset name | ||
| 151 | DB2TSSIZEP - EXTENTS | Number of extents of a partition of a tablespace or index | ||
| 152 | DB2TSSIZEP - FREESIZE | Free size of partition of a tablespace in KB | ||
| 153 | DB2TSSIZEP - PART | Partition number | ||
| 154 | DB2TSSIZEP - PCTUSED | Percentage of used to alloc. size of a partition of a TS | ||
| 155 | DB2TSSIZEP - PQTY | Primary space allocation | ||
| 156 | DB2TSSIZEP - QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 157 | DB2TSSIZEP - SQTY | Secondary space allocation | ||
| 158 | DB2TSSIZEP - STORDATE | Date when the storage information has been collected | ||
| 159 | DB2TSSIZEP - STORTIME | Time when the storage information has been collected | ||
| 160 | DB2TSSIZEP - TSNAME | Name of the tablespace | ||
| 161 | DBCON - CON_NAME | Logical name for a database connection | ||
| 162 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 163 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 164 | SYST - UZEIT | ABAP System Field: Current Time of Application Server |