DB2DB02TBSIZE SAP (Transaction DB02: List of tables and tablespace (Details)) Table details
Description: Transaction DB02: List of tables and tablespace (Details)
Related tables to DB2DB02TBSIZE
Access table DB2DB02TBSIZE
Table field list including key, data, relationships and ABAP select examples
DB2DB02TBSIZE is a standard SAP Table which is used to store Transaction DB02: List of tables and tablespace (Details) data and is available within R/3 SAP systems depending on the version and release level.
The DB2DB02TBSIZE table consists of various fields, each holding specific information or linking keys about Transaction DB02: List of tables and tablespace (Details) data available in SAP. These include TBNAME (Name of the table on which the index is defined), STORDATE (Date when the storage information has been collected), STORTIME (Time when the storage information has been collected), TSNAME (Name of the tablespace).. 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: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DB2DB02TBSIZE 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 |
TBCREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | CHAR8 | ||||
TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR | 18 | CHAR18 | ||||
STORDATE | Date when the storage information has been collected | DB2STODATE | DATS | 8 | DATUM | ||||
STORTIME | Time when the storage information has been collected | DB2STOTIME | TIMS | 6 | TIME | ||||
TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | CHAR8 | ||||
DBNAME | Database name | DB2DBNAME | CHAR | 8 | D2DBNAME | ||||
PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 | 5 | DB2SINT | ||||
TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | DB2RTSTBSIZE | FLTP | 16(16) | FLTP | ||||
SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | DB2TBSPACEF | FLTP | 16(16) | FLTP | ||||
STATSTIME | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | DB2TMSTMP | ||||
TS_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DB2TSSIZ | DEC | 11 | DEC11 | ||||
TS_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | DB2TSFREE | DEC | 11 | DEC11 | ||||
PCTUSED | Percentage of used size to allocated size of a tablespace | DB2TSPCTU | DEC | 3 | DEC3 | ||||
RTS_TOTALROWS | Real Time Statistics: Number of rows in Table | DB2TBTOTALROWS | FLTP | 16(16) | FLTP | ||||
AVGROWLENGTH | Average row length of table | DB2TBAVGROWLEN | INT4 | 10 | |||||
RTS_ST_CHANGES | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 16(16) | FLTP |
Key field | Non-key field |
How do I retrieve data from SAP table DB2DB02TBSIZE using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB2DB02TBSIZE to SELECT all data from the tableDATA: WA_DB2DB02TBSIZE TYPE DB2DB02TBSIZE.
SELECT SINGLE *
FROM DB2DB02TBSIZE
INTO CORRESPONDING FIELDS OF WA_DB2DB02TBSIZE
WHERE...
How to access SAP table DB2DB02TBSIZE
Within an ECC or HANA version of SAP you can also view further information about DB2DB02TBSIZE 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