SAP ABAP Table DB2_DB02_IX_HIST (DB02: structure for history of indexes)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB2_DB02_IX_HIST |
Table Relationship Diagram 
|
| Short Description | DB02: structure for history of indexes |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  FROM_INTERVAL |
DB2DATE | DB2DATE | DATS | 8 | 0 | Field type date, YYYYMMDD | ||
| 2 | TO_INTERVAL |
DB2DATE | DB2DATE | DATS | 8 | 0 | Field type date, YYYYMMDD | ||
| 3 | IT_IX |
DB_T_TABHIST | TTYP | 0 | 0 | ||||
| 4 | RANGE |
DB2HIST_RANGE | CHAR | 8 | 0 | Range for History ( daily, weekly, monthly ) | |||
| 5 | RANGE_LIST |
DBA_LISTBOX_LIST | TTYP | 0 | 0 | ||||
| 6 | COLLAPSED |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 7 | EXPANDED |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 8 | RANGE_PREV |
DB2HIST_RANGE | CHAR | 8 | 0 | Range for History ( daily, weekly, monthly ) | |||
| 9 | HIST_KEEP_DAYS |
NUMC4 | NUMC4 | NUMC | 4 | 0 | Count parameters | ||
| 10 | HIST_KEEP_WEEKS |
NUMC4 | NUMC4 | NUMC | 4 | 0 | Count parameters | ||
| 11 | HIST_KEEP_MONTHS |
NUMC4 | NUMC4 | NUMC | 4 | 0 | Count parameters |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
