DB2DB02IXDYN is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02IXDYN in SAP.
- Table description : Tx DB02: Dynamics of the size of 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 DB2DB02IXDYN 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 | |
| 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 |
| EXTENTS | Number of extents | DB2NUMEXTI | |
| EXTENTS_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| EXTENTS_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| EXTENTS_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_EXTENTS | Number of extents: change per day | DB2CHGEXDI | |
| W_EXTENTS | Number of extents: change per week | DB2CHGEXWI | |
| M_EXTENTS | Number of extents: change per month | DB2CHGEXMI | |
| ALLOCSIZE | Total size of an index (allocated storage in KB) | DB2IXSIZ | DEC11 |
| ALLOCSIZ_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| ALLOCSIZ_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| ALLOCSIZ_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_ALLOCSIZ | Allocated storage in KB: change per day | DB2CHGSIZD | DEC11 |
| W_ALLOCSIZ | Allocated storage in KB: change per week | DB2CHGSIZW | DEC11 |
| M_ALLOCSIZ | Allocated storage in KB: change per month | DB2CHGSIZM | DEC11 |
| FREESIZE | Free size of an index in KB (allocated minus used storage) | DB2IXFREE | DEC11 |
| FREESIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| FREESIZE_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| FREESIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_FREESIZ | Free storage (allocated minus used) in KB: change per day | DB2CHGFRED | DEC11 |
| W_FREESIZ | Free storage (allocated minus used) in KB: change per week | DB2CHGFREW | DEC11 |
| M_FREESIZ | Free storage (allocated minus used) in KB: change per month | DB2CHGFREM | DEC11 |
| RTS_TOTALENTRIES | DB2/zOS: Real-Time Statistics index TOTALENTRIES | DB2RTSTOTALENTRY | FLTP |
| TOTALENTRIES_LAS | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| TOTALENTRIES_PER | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| TOTALENTRIES_FIR | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_TOTALENTRIES | Number of Rows: changes per day | DB2CHGROWD | FLTP |
| W_TOTALENTRIES | Number of Rows: changes per week | DB2CHGROWW | FLTP |
| M_TOTALENTRIES | Number of Rows: changes per month | DB2CHGROWM | FLTP |
DB2DB02IXDYN related tables
| Table | Note |
|---|---|
| DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
| DB2DB02TBDYN | Tx DB02: Dynamics of the size of tables |
| DB2DB02TSDYN | Tx DB02: Dynamics of the size of tablespaces |
| DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor |
| DB2DB02SUMMARY | Tx DB02: Summary information on first screenincl. size histo |
| AMDS | Effective size of tables and indexes in the database |
| BBPD_TREX_INDEX | BBP TREX Indexes: Assign Business Object -> TREX Indexes |
| STRX_LPIXS | Assignment of Physical Indexes to Logical Indexes |
| 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 |
| DB2DB02IXSIZE | Tx DB02: List of indexspace datasets |
| DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up |
| DB2DB02MISSOBJ | Tx DB02: Missing objects |
| DB2DB02TBSIZE | Transaction DB02: List of tables and tablespace (Details) |
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