DB2DB02IXSIZE is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02IXSIZE in SAP.
- Table description : Tx DB02: List of indexspace datasets
- 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 DB2DB02IXSIZE 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 |
| PART_EXTENSION | Extension or Partition (non-partitioned TS) number | DB2PARTEXT | |
| 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 |
| DSNAME | Dataset name | DB2DSNAME | DB2CHAR44 |
| EXTENTS | Number of extents | DB2NUMEXTI | |
| DASD_USAGE | Actual DASD usage (in KB) of dataset | DB2DASD_USAGE | |
| ALLOCSIZE | Allocated storage of a partition of an index in KB | DB2IXSIZP | DEC11 |
| FREESIZE | Free size of an index partition in KB | DB2IXFREEP | DEC11 |
| PCTUSED | Percentage of used to alloc. size of a partition of an IX | DB2IXPCTUP | DEC3 |
| PQTY | Primary space allocation | DB2PQTY | |
| SQTY | Secondary space allocation | DB2SQTY | |
| QTYUNIT | Unit in which primary and secondary allocation are given | DB2QTYUNIT | DB2QTYUNIT |
DB2DB02IXSIZE related tables
| Table | Note |
|---|---|
| DB2DB02IXSIZE | Tx DB02: List of indexspace datasets |
| DB2DB02TSSIZE | Transaction DB02: List of tablespace datasets |
| DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor |
| DB02_COLL_PLAN | Oracle monitoring: List of coll. functions for DB02 |
| DB2DB02TBSIZE | Transaction DB02: List of tables and tablespace (Details) |
| DB2DB02VOLFREE | Tx DB02: Volume freespace list |
| DB02_COLL_LOG | Oracle monitoring: DB02 collector log |
| DB2DB02CONTROL | Control table for information in DB02 |
| DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
| DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up |
| DB2DB02MISSOBJ | Tx DB02: Missing objects |
| DB2DB02SUMMARY | Tx DB02: Summary information on first screenincl. size histo |
| DB2DB02TBDYN | Tx DB02: Dynamics of the size of tables |
| DB2DB02TBTOPGROW | Tx DB02: Top Twenty of table growth for fast access |
| DB2DB02TSDYN | Tx DB02: Dynamics of the size of tablespaces |
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