DB2DB02TBTOPGROW SAP (Tx DB02: Top Twenty of table growth for fast access) Table details
Description: Tx DB02: Top Twenty of table growth for fast access
Related tables to DB2DB02TBTOPGROW
Access table DB2DB02TBTOPGROW
Table field list including key, data, relationships and ABAP select examples
DB2DB02TBTOPGROW is a standard SAP Table which is used to store Tx DB02: Top Twenty of table growth for fast access data and is available within R/3 SAP systems depending on the version and release level.
The DB2DB02TBTOPGROW table consists of various fields, each holding specific information or linking keys about Tx DB02: Top Twenty of table growth for fast access 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 DB2DB02TBTOPGROW 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 DB2DB02TBTOPGROW using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB2DB02TBTOPGROW to SELECT all data from the tableDATA: WA_DB2DB02TBTOPGROW TYPE DB2DB02TBTOPGROW.
SELECT SINGLE *
FROM DB2DB02TBTOPGROW
INTO CORRESPONDING FIELDS OF WA_DB2DB02TBTOPGROW
WHERE...
How to access SAP table DB2DB02TBTOPGROW
Within an ECC or HANA version of SAP you can also view further information about DB2DB02TBTOPGROW 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