RSDB2A_STA_STD - DB2 Accelerator: current table data status in accelerator
DB2 Accelerator: current table data status in accelerator information is stored in SAP table RSDB2A_STA_STD.
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_STA_STD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
TABNAME | DB2 Accelerator: table name | X | RSDB2A_TABNAME | CHAR | 60 | |
PARTNO | Number of partitions of the tablespace or indexspace | X | DB2PART | INT2 | 2 | |
ACCELERATOR | DB2 Accelerator: accelerator name | X | RSDB2A_ACCELERATOR | CHAR | 128 | |
LASTUPDATE | DB2-z/OS: General purpose timestamp in DB2 hex format | DB2TIMESTAMP | NUMC | 40 | ||
STATSINSERTS | INT4 | 4 | ||||
STATSDELETES | INT4 | 4 | ||||
STATSUPDATES | INT4 | 4 | ||||
STATSMASSDELETE | INT4 | 4 | ||||
REORGINSERTS | INT4 | 4 | ||||
REORGDELETES | INT4 | 4 | ||||
REORGUPDATES | INT4 | 4 | ||||
REORGMASSDELETE | INT4 | 4 |