RSDB2A_TABSTAT - DB2 Accelerator: Table statistics (load and read)
DB2 Accelerator: Table statistics (load and read) information is stored in SAP table RSDB2A_TABSTAT.
It is part of development package RSDB2A in software component BW-SYS-DB-DB2. This development package consists of objects that can be grouped under "IBM DB2 Analytics Accelerator suppport".
It is part of development package RSDB2A in software component BW-SYS-DB-DB2. This development package consists of objects that can be grouped under "IBM DB2 Analytics Accelerator suppport".
Fields for table RSDB2A_TABSTAT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
TABNAME | Table Name | X | TABNAME | CHAR | 60 | |
CREATOR | DB2 creator name | X | DB2CREATOR | CHAR | 16 | |
ACCELERATOR | DB2 Accelerator: accelerator name | X | RSDB2A_ACCELERATOR | CHAR | 128 | |
VERSION | X | INT4 | 4 | |||
FIRSTLOADTS | DB2-z/OS: General purpose timestamp in DB2 hex format | DB2TIMESTAMP | NUMC | 40 | ||
LASTLOADTS | DB2-z/OS: General purpose timestamp in DB2 hex format | DB2TIMESTAMP | NUMC | 40 | ||
FIRSTREADTS | DB2-z/OS: General purpose timestamp in DB2 hex format | DB2TIMESTAMP | NUMC | 40 | ||
LASTREADTS | DB2-z/OS: General purpose timestamp in DB2 hex format | DB2TIMESTAMP | NUMC | 40 | ||
READCOUNT | INT4 | 4 | ||||
LOADCOUNT | INT4 | 4 | ||||
LOADFULLCOUNT | INT4 | 4 | ||||
LOADPARTCOUNT | INT4 | 4 | ||||
LOADTIME | INT4 | 4 | ||||
LASTLOADPARTS | INT4 | 4 | ||||
LASTLOADTIME | INT4 | 4 |