DB2DB02TBDYN is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02TBDYN in SAP.
- Table description : Tx DB02: Dynamics of the size of tables
- 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 DB2DB02TBDYN Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR18 |
| DBNAME | Database name | DB2DBNAME | D2DBNAME |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
| TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | DB2RTSTBSIZE | FLTP |
| TBSIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| TBSIZE_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| TBSIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | DB2CHGTBSD | FLTP |
| W_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | DB2CHGTBSW | FLTP |
| M_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | DB2CHGTBSM | FLTP |
| RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | FLTP |
| TOTALROWS_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| TOTALROWS_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| TOTALROWS_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_TOTALROWS | Number of Rows: changes per day | DB2CHGROWD | FLTP |
| W_TOTALROWS | Number of Rows: changes per week | DB2CHGROWW | FLTP |
| M_TOTALROWS | Number of Rows: changes per month | DB2CHGROWM | FLTP |
| SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | DB2TBSPACEF | FLTP |
| SPACEF_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP |
| SPACEF_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | |
| SPACEF_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP |
| D_SPACEF | Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFD | FLTP |
| W_SPACEF | Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFW | FLTP |
| M_SPACEF | Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFM | FLTP |
DB2DB02TBDYN related tables
| Table | Note |
|---|---|
| DB2DB02TBDYN | Tx DB02: Dynamics of the size of tables |
| DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
| 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 |
| DB2DB02TBSIZE | Transaction DB02: List of tables and tablespace (Details) |
| AMDS | Effective size of tables and indexes in the database |
| CNVMBTSHELL_SIZE | Shell Creation: Size determination method for tables |
| CNV_CMIS_A_SIZE | TABLE TO STORE WORKLIST TABLES FOR SIZE CALCULATIONS |
| DBSTATHADA | Actual size of tables on the database (history) |
| DBSTATHORA | Actual size of tables on the database (history) |
| DBSTATTADA | Actual size of tables on the database |
| DBSTATTORA | Actual size of tables on the database |
| MLTTSTTEM2 | MLT Test Cases: Template for Medium-Size Tables |
| RSDDSTATDTASIZE | Size of tables associated to a dta |
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