DBSTAIHDB2 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DBSTAIHDB2 in SAP.
- Table description : DB2/390 Statistics for Indexes
- Module : BC-DB-DB2
- Parent Module : BC
- Package : STU2
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DBSTAIHDB2 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| NAME | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR18 |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| TIMESTAMP | Date and time of last RUNSTATS | DB2STATSTM | DB2TMSTMP |
| TBNAME | DB2 table name | DB2TABNAME | CHAR18 |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | AM_VWTYPE |
| CLURATIO | DB2 for OS/390 cluster ratio | DB2CLURAT | INT1 |
| FIRSTKCARD | Number of distinct values in key (first column or full key) | DB2KEYCARD | FLOATING |
| FULLKCARD | Number of distinct values in key (first column or full key) | DB2KEYCARD | FLOATING |
| NLEAF | Number of active leaf pages in the index | DB2NLEAF | |
| NLEVELS | DB2 for OS/390 number of levels in the index tree | DB2NLEVELS | DB2SINT |
| NEAROFFPOS | Number of referred to rows near/far from optimal position | DB2OFFPOSF | FLOATING |
| FAROFFPOS | Number of referred to rows near/far from optimal position | DB2OFFPOSF | FLOATING |
| LEAFDIST | 100 * avg number of leaf pages between successive leaf pages | DB2LEAFDIS | |
| DSSIZE | DB2 for OS/390 size of a dataset in KBytes | DB2SIZEK | DB2SIZEK |
DBSTAIHDB2 related tables
| Table | Note |
|---|---|
| DBSTAIHDB2 | DB2/390 Statistics for Indexes |
| DBSTATIDB2 | DB2/390 Statistics for Indexes |
| STU3COTABC | Definition of DB2 OS/390 and OS/390 Commands(Customer Table) |
| STU3COTABS | Definition of DB2 for OS/390 and OS/390 Commands (SAP Table) |
| DB2UTPARM | DB2/390: Parameters for DB2 Utilities |
| DBSTATHDB2 | DB2/390 Statistics for Tables (History) |
| DBSTATTDB2 | DB2/390 Statistics for Tables |
| DB2BPTUNE | DB2/390: Buffer Pool Tuning Settings |
| DB2MON | DB2/390 Monitor Table |
| DB2PROC | Stored procedures for DB2/390 |
| DB2TSSIZE_T | DB2/390: Storage Information on R/3 Tablespaces |
| DBCHECKDB2 | Configuration of DB2/390 System Check Parameters |
| DBMSGDB2 | DB2/390 System Check Messages |
| DBSYCHKDB2 | DB2/390: Global Information for Database System Check |
| DD02DB2 | DB2/390: Table Parameters |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP