SAP ABAP Table DB2SPREBIX (REBUILD INDEX Parameters for Stored Procedures)
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
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category | INTTAB | Structure |
Structure | DB2SPREBIX | Table Relationship Diagram |
Short Description | REBUILD INDEX Parameters for Stored Procedures |
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 | FIELD1 | DB2RBIXFLD | DB2RBIXFLD | CHAR | 80 | 0 | Index definitions for the REBUILD INDEX statement | ||
2 | FIELD2 | DB2RBIXFLD | DB2RBIXFLD | CHAR | 80 | 0 | Index definitions for the REBUILD INDEX statement | ||
3 | FIELD3 | DB2RBIXFLD | DB2RBIXFLD | CHAR | 80 | 0 | Index definitions for the REBUILD INDEX statement | ||
4 | REUSE | DB2REUSE | DB2REUSE | CHAR | 1 | 0 | Specified if DB2-managed dataset | ||
5 | SORTKEYS | DB2SORTKEY | DB2SORTKEY | CHAR | 1 | 0 | Specifies that index keys are to be sorted | ||
6 | REPORT | DB2REPORT | DB2REPORT | CHAR | 3 | 0 | RUNSTATS parameter REPORT | ||
7 | UPDATE | DB2UPDATE | DB2UPDATE | CHAR | 10 | 0 | RUNSTATS parameter UPDATE | ||
8 | KEYCARD | DB2KYCRD | DB2KYCRD | CHAR | 1 | 0 | KEYCARD collects all distinct values | ||
9 | FREQVAL | DB2RBIXFRQ | DB2RBIXFRQ | CHAR | 80 | 0 | Controls the collection of frequent value statistics |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 710 |