DB2DB02IX_SUM is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02IX_SUM in SAP.
- Table description : Tx DB02: Summary of Index info. Partitions are summed up
- 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 DB2DB02IX_SUM Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
IXCREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
IXNAME | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR18 |
STORDATE | Date when the storage information has been collected | DB2STODATE | DATUM |
STORTIME | Time when the storage information has been collected | DB2STOTIME | TIME |
DBNAME | Database name | DB2DBNAME | D2DBNAME |
IXSPACE | Name of the indexspace that contains the index | DB2IXSPACE | CHAR8 |
PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | DB2SINT |
MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | DB2MAXEXTS | |
SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | DB2SUMEXTS | |
SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | DB2DASD_USE_SUM | FLTP |
SUM_ALLOCSIZE | Total size of an index (allocated storage in KB) | DB2IXSIZ | DEC11 |
SUM_FREESIZE | Free size of an index in KB (allocated minus used storage) | DB2IXFREE | DEC11 |
PCTUSED | Percentage of used size to allocated size of an index | DB2IXPCTUS | DEC3 |
RTS_LAST_REORG | Timestamp of last REORG | DB2CCOTIME | DB2TMSTMP |
RTS_TOTALENTRIES | DB2/zOS: Real-Time Statistics index TOTALENTRIES | DB2RTSTOTALENTRY | FLTP |
RTS_CHANGES | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | |
RTS_REORG_RECS | DB2/zOS: Number of REORG recommendations by DSNACCOR | DB2CCREORGRECS | |
TBCREATOR | Authorization ID of the owner of the table | DB2TBCREA | CHAR8 |
TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR18 |
TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
DB2DB02IX_SUM related tables
Table | Note |
---|---|
DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up |
DB2DB02TS_SUM | Tx DB02: Summary of TS info. Partitions are summed up |
DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor |
DB2DB02SUMMARY | Tx DB02: Summary information on first screenincl. size histo |
DB2DB02TS_HIS | Tx DB02: Short history of TS info |
AIN_TEPC_PRTTN | Partitions |
DAAG_PARTITIONS | History of Partitions Created for Tables |
RSDB2NLS_QUEUE | DB2-z/OS HiPe NLS: Partitions waiting for archiving |
RSLPOPART | Logical Partitioning: Partitions of a LPO |
/AIN/TEPC_PRTTN | Partitions |
/SDF/DB6PMCN | DB6: Configuration Nodes (Partitions) |
DB02_COLL_LOG | Oracle monitoring: DB02 collector log |
DB02_COLL_PLAN | Oracle monitoring: List of coll. functions for DB02 |
DB2DB02CONTROL | Control table for information in DB02 |
DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
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