RSDB2STAR_DIR - DB2 STAR aggregates: directory
DB2 STAR aggregates: directory information is stored in SAP table RSDB2STAR_DIR.
It is part of development package RSDB2 in software component BW-SYS-DB-DB2. This development package consists of objects that can be grouped under "BW: Porting DB2-z/OS".
It is part of development package RSDB2 in software component BW-SYS-DB-DB2. This development package consists of objects that can be grouped under "BW: Porting DB2-z/OS".
Fields for table RSDB2STAR_DIR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
HASH | Hash Value (160 Bits) | X | HASH160 | CHAR | 80 | |
ENTRYNO | X | INT4 | 4 | |||
CACHESTATUS | INT4 | 4 | ||||
HITS | INT4 | 4 | ||||
FAULTS | INT4 | 4 | ||||
LASTUSED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
CACHEID | NUMC | 16 | ||||
RECORDCOUNT | INT4 | 4 | ||||
SELECTEDCOUNT | INT4 | 4 | ||||
BUILDSTART | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
LASTBUILDTIME | INT4 | 4 | ||||
INFOPROV | InfoCube | RSINFOCUBE | CHAR | 60 | ||
FIELDS | CHAR | 256 | ||||
TYPE01 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW01 | CHAR | 120 | ||||
HIGH01 | CHAR | 120 | ||||
TYPE02 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW02 | CHAR | 120 | ||||
HIGH02 | CHAR | 120 | ||||
TYPE03 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW03 | CHAR | 120 | ||||
HIGH03 | CHAR | 120 | ||||
TYPE04 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW04 | CHAR | 120 | ||||
HIGH04 | CHAR | 120 | ||||
TYPE05 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW05 | CHAR | 120 | ||||
HIGH05 | CHAR | 120 | ||||
TYPE06 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW06 | CHAR | 120 | ||||
HIGH06 | CHAR | 120 | ||||
TYPE07 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW07 | CHAR | 120 | ||||
HIGH07 | CHAR | 120 | ||||
TYPE08 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW08 | CHAR | 120 | ||||
HIGH08 | CHAR | 120 | ||||
TYPE09 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW09 | CHAR | 120 | ||||
HIGH09 | CHAR | 120 | ||||
TYPE10 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW10 | CHAR | 120 | ||||
HIGH10 | CHAR | 120 | ||||
TYPE11 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW11 | CHAR | 120 | ||||
HIGH11 | CHAR | 120 | ||||
TYPE12 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
LOW12 | CHAR | 120 | ||||
HIGH12 | CHAR | 120 |