SAP ABAP Table DB2SPRUNTS (RUNSTATS 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
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 | DB2SPRUNTS |
Table Relationship Diagram 
|
| Short Description | RUNSTATS 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 |  DBNAME |
DB2DBNAM1 | DB2DBNAME | CHAR | 8 | 0 | Name of database | ||
| 2 | TSNAME |
DB2TSNAM1 | DB2TSNAME | CHAR | 8 | 0 | Name of tablespace | ||
| 3 | TSPARTION |
DB2PARTNR | DB2CHAR03 | CHAR | 3 | 0 | Row ID or partition number, depending on resource type | ||
| 4 | SHRLEVEL |
DB2SHRLVL | DB2SHRLVL1 | CHAR | 9 | 0 | RUNSTATS parameter SHRLEVEL | ||
| 5 | REPORTNAME |
DB2REPORT | DB2REPORT | CHAR | 3 | 0 | RUNSTATS parameter REPORT | ||
| 6 | UPDATE |
DB2UPDATE | DB2UPDATE | CHAR | 10 | 0 | RUNSTATS parameter UPDATE | ||
| 7 | TABLEALL |
DB2TBLALL | DB2TBLALL | CHAR | 1 | 0 | Parameter if TABLE ALL should used for a RUNSTATS | ||
| 8 | INDEXALL |
DB2INDXALL | DB2INDXALL | CHAR | 1 | 0 | Parameter if INDEX ALL should used for a RUNSTATS | ||
| 9 | TSFIELD |
DB2RUNFDTS | DB2RUNFDTS | CHAR | 80 | 0 | Table definition for RUNSTATS TABLESPACE statement | ||
| 10 | IXFIELD |
DB2RUNFDIX | DB2RUNFDIX | CHAR | 80 | 0 | Index definition for RUNSTATS TABLESPACE statement | ||
| 11 | KEYCARD |
DB2KYCRD | DB2KYCRD | CHAR | 1 | 0 | KEYCARD collects all distinct values |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
