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 |