RSDB2A_CONTROL - DB2 Accelerator: conrol center TOC
DB2 Accelerator: conrol center TOC information is stored in SAP table RSDB2A_CONTROL.
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_CONTROL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| ITEM_ID | X | INT4 | 4 | |||
| ACCELERATOR | DB2 Accelerator: accelerator name | X | RSDB2A_ACCELERATOR | CHAR | 128 | |
| HIERLEVEL | INT4 | 4 | ||||
| PARENT_ID | INT4 | 4 | ||||
| NAME | DB2 Accelerator: table name | RSDB2A_TABNAME | CHAR | 60 | ||
| ITEM_TYPE | DB2 Accelerator: Flag | RSDB2A_FLAG | CHAR | 2 | ||
| REPLICATION | DB2 Accelerator: replication type | RSDB2A_REPLICATION | CHAR | 2 | ||
| DEPLOYMENT | DB2 Accelerator: Flag | RSDB2A_FLAG | CHAR | 2 | ||
| LASTCHECK | DB2-z/OS: General purpose timestamp in DB2 hex format | DB2TIMESTAMP | NUMC | 40 | ||
| DATASTATUS | DB2 Accelerator: data status in accelerator | RSDB2A_DATASTATUS | INT4 | 4 | ||
| PARTNO | Number of partitions of the tablespace or indexspace | DB2PART | INT2 | 2 | ||
| XLOADSTATUS | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XACCELERATIONSTA | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XINTEGRITYSTATUS | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XREPLICATIONSTAT | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XUSEDDISKSPACEIN | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XROWCOUNT | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XLASTLOADTIMESTA | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XDISTRIBUTIONKEY | DB2 Accelerator: Character string length 128 | RSDB2A_CHAR128 | CHAR | 256 | ||
| XSKEW | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XORGANIZINGKEY_N | DB2 Accelerator: Character string length 128 | RSDB2A_CHAR128 | CHAR | 256 | ||
| XORGANIZEDPERCEN | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XCAPTUREPOINTTIM | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XARCHIVESTATUS | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XARCHIVEDISKSPAC | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XARCHIVEROWCOUNT | DB2 Accelerator: property value read from xml | RSDB2A_CHARVAL | CHAR | 64 | ||
| XLOADSTATUS_APPL | DB2 Accelerator: Flag | RSDB2A_FLAG | CHAR | 2 |