DB2DB02TBDYN SAP (Tx DB02: Dynamics of the size of tables) Table details
Description: Tx DB02: Dynamics of the size of tables
Table field list including key, data, relationships and ABAP select examples
DB2DB02TBDYN is a standard SAP Table which is used to store Tx DB02: Dynamics of the size of tables data and is available within R/3 SAP systems depending on the version and release level.
The DB2DB02TBDYN table consists of various fields, each holding specific information or linking keys about Tx DB02: Dynamics of the size of tables data available in SAP. These include TBNAME (Name of the table on which the index is defined), DBNAME (Database name), TSNAME (Name of the tablespace), TBSIZE (Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DB2DB02TBDYN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | CHAR8 | ||||
TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR | 18 | CHAR18 | ||||
DBNAME | Database name | DB2DBNAME | CHAR | 8 | D2DBNAME | ||||
TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | CHAR8 | ||||
TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | DB2RTSTBSIZE | FLTP | 16(16) | FLTP | ||||
TBSIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 16(16) | FLTP | ||||
TBSIZE_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 10 | |||||
TBSIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 16(16) | FLTP | ||||
D_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | DB2CHGTBSD | FLTP | 16(16) | FLTP | ||||
W_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | DB2CHGTBSW | FLTP | 16(16) | FLTP | ||||
M_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | DB2CHGTBSM | FLTP | 16(16) | FLTP | ||||
RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | FLTP | 16(16) | FLTP | ||||
TOTALROWS_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 16(16) | FLTP | ||||
TOTALROWS_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 10 | |||||
TOTALROWS_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 16(16) | FLTP | ||||
D_TOTALROWS | Number of Rows: changes per day | DB2CHGROWD | FLTP | 16(16) | FLTP | ||||
W_TOTALROWS | Number of Rows: changes per week | DB2CHGROWW | FLTP | 16(16) | FLTP | ||||
M_TOTALROWS | Number of Rows: changes per month | DB2CHGROWM | FLTP | 16(16) | FLTP | ||||
SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | DB2TBSPACEF | FLTP | 16(16) | FLTP | ||||
SPACEF_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 16(16) | FLTP | ||||
SPACEF_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 10 | |||||
SPACEF_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 16(16) | FLTP | ||||
D_SPACEF | Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFD | FLTP | 16(16) | FLTP | ||||
W_SPACEF | Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFW | FLTP | 16(16) | FLTP | ||||
M_SPACEF | Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFM | FLTP | 16(16) | FLTP |
Key field | Non-key field |
How do I retrieve data from SAP table DB2DB02TBDYN using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB2DB02TBDYN to SELECT all data from the tableDATA: WA_DB2DB02TBDYN TYPE DB2DB02TBDYN.
SELECT SINGLE *
FROM DB2DB02TBDYN
INTO CORRESPONDING FIELDS OF WA_DB2DB02TBDYN
WHERE...
How to access SAP table DB2DB02TBDYN
Within an ECC or HANA version of SAP you can also view further information about DB2DB02TBDYN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects