DB2TBLX - RFC - Table Extents
RFC - Table Extents information is stored in SAP table DB2TBLX.
It is part of development package STU3 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "Development Class for Database Monitor".
It is part of development package STU3 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "Development Class for Database Monitor".
Fields for table DB2TBLX
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TBLXSSID | DB2 subsystem ID | X | DB2SWPSSID | CHAR | 4 | |
| TBLXDATE | Field of type DATS | X | DATS | DATS | 8 | |
| TBLXTIME | Field of type TIMS | X | TIMS | TIMS | 6 | |
| TBLXMSEC | Event time stamp (milliseconds) | X | DB2EVTTMS | CHAR | 6 | |
| TBLXDS | Dataset name | X | DB2DSNAME | CHAR | 44 | |
| TBLXDSGN | DB2/390: Data sharing group | DB2DSGN | CHAR | 8 | ||
| TBLXMEMN | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | ||
| TBLXTS | Char 20 | CHAR20 | CHAR | 20 | ||
| TBLXDB | DBID | DB2DBID | INT2 | 2 | ||
| TBLXPS | DB2 page set ID | DB2PSID | INT2 | 2 | ||
| TBLXDN | Database name | DB2DBNAME | CHAR | 8 | ||
| TBLXTN | Tablespace/indexspace name | DB2TSIXNM | CHAR | 8 | ||
| TBLXPQ | DB2/390: Primary quantity | DB2PRIQTY | NUMC | 10 | ||
| TBLXSQ | DB2/390: Secondary quantity | DB2SECQTY | NUMC | 10 | ||
| TBLXMS | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 4 | ||
| TBLXHB | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 4 | ||
| TBLXHA | High allocated after extent, 4KB | DB2TBLXHA | NUMC | 10 | ||
| TBLXXM | Maximum number of extents | DB2TBKXXM | NUMC | 5 | ||
| TBLXXB | Number of extents before a new extent has been created | DB2TBKXXB | NUMC | 5 | ||
| TBLXXA | Number of extents after a new extent has been created | DB2TBKXXA | NUMC | 5 | ||
| TBLXVM | Maximum volumes | DB2TBLXVM | NUMC | 5 | ||
| TBLXVB | Number of volumes before extent has been created | DB2TBLXVB | NUMC | 5 | ||
| TBLXVA | Number of volumes after a new extent has been created | DB2TBLXVA | NUMC | 5 | ||
| TBLXTODO | DB2 for OS/390: Flag for updating DB02 extent monitor | DB2TBLXTD | CHAR | 5 |