DB2DB02TBSIZE is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02TBSIZE in SAP.
- Table description : Transaction DB02: List of tables and tablespace (Details)
- 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 DB2DB02TBSIZE Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| TBCREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR18 |
| STORDATE | Date when the storage information has been collected | DB2STODATE | DATUM |
| STORTIME | Time when the storage information has been collected | DB2STOTIME | TIME |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
| DBNAME | Database name | DB2DBNAME | D2DBNAME |
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | DB2SINT |
| TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | DB2RTSTBSIZE | FLTP |
| SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | DB2TBSPACEF | FLTP |
| STATSTIME | Date and time of last RUNSTATS | DB2STATSTM | DB2TMSTMP |
| TS_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DB2TSSIZ | DEC11 |
| TS_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | DB2TSFREE | DEC11 |
| PCTUSED | Percentage of used size to allocated size of a tablespace | DB2TSPCTU | DEC3 |
| RTS_TOTALROWS | Real Time Statistics: Number of rows in Table | DB2TBTOTALROWS | FLTP |
| AVGROWLENGTH | Average row length of table | DB2TBAVGROWLEN | |
| RTS_ST_CHANGES | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP |
DB2DB02TBSIZE related tables
| Table | Note |
|---|---|
| DB2DB02TBSIZE | Transaction DB02: List of tables and tablespace (Details) |
| DB2DB02TSSIZE | Transaction DB02: List of tablespace datasets |
| DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor |
| DB2DB02TBDYN | Tx DB02: Dynamics of the size of tables |
| DB6PMHXP | DB6: Detail Record of Tablespace and DB Space Statistics |
| DB6PMHXPHD | DB6: Summary Record of Tablespace And DB Space Statistics |
| DB6PMHXT | DB6: Detail Record of Tablespace and DB Table/Index Stats |
| DB6PMHXTHD | DB6: Summary Rec. of Tablespace and DB Table/Index Stats |
| DB02_COLL_PLAN | Oracle monitoring: List of coll. functions for DB02 |
| DB2DB02IXSIZE | Tx DB02: List of indexspace datasets |
| DB2DB02VOLFREE | Tx DB02: Volume freespace list |
| BC505TS | Table for tablespace full training, Oracle DBA courses |
| ORATSPINFO | Tablespace Information |
| RSMDMCNVTAB | Conversion Table Model (Determines Data Class / Tablespace) |
| TPTSP | Tablespace parameters for DB2 |
Sap bank details transaction TablesBank account number details tables in sap TablesWbs element settlement rule transaction tables in sap TablesUsers list transaction TablesSe16n list for transaction TablesTransaction code to check vendor email address tables in sap TablesPurchase order list transaction TablesList of tables Tables
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