DB2DB02TS_SUM is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02TS_SUM in SAP.
- Table description : Tx DB02: Summary of TS info. Partitions are summed up
- 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 DB2DB02TS_SUM Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
DBNAME | Database name | DB2DBNAME | D2DBNAME |
TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
STORDATE | Date when the storage information has been collected | DB2STODATE | DATUM |
STORTIME | Time when the storage information has been collected | DB2STOTIME | TIME |
CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | DB2SINT |
MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | DB2MAXEXTS | |
SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | DB2SUMEXTS | |
SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | DB2DASD_USE_SUM | FLTP |
SUM_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DB2TSSIZ | DEC11 |
SUM_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_LAST_REORG | Timestamp of last REORG | DB2CCOTIME | DB2TMSTMP |
RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | FLTP |
RTS_CHANGES | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | |
RTS_REORG_RECS | DB2/zOS: Number of REORG recommendations by DSNACCOR | DB2CCREORGRECS | |
BASE_TS_DBNAME | Database name | DB2DBNAME | D2DBNAME |
BASE_TS_TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
DB2DB02TS_SUM related tables
Table | Note |
---|---|
DB2DB02IX_SUM | Tx DB02: Summary of Index info. Partitions are summed up |
DB2DB02TS_SUM | Tx DB02: Summary of TS info. Partitions are summed up |
DB2DB02EXTENTS | Tx DB02: Data for DB02's Extent Monitor |
DB2DB02SUMMARY | Tx DB02: Summary information on first screenincl. size histo |
DB2DB02TS_HIS | Tx DB02: Short history of TS info |
AIN_TEPC_PRTTN | Partitions |
DAAG_PARTITIONS | History of Partitions Created for Tables |
RSDB2NLS_QUEUE | DB2-z/OS HiPe NLS: Partitions waiting for archiving |
RSLPOPART | Logical Partitioning: Partitions of a LPO |
/AIN/TEPC_PRTTN | Partitions |
/SDF/DB6PMCN | DB6: Configuration Nodes (Partitions) |
DB02_COLL_LOG | Oracle monitoring: DB02 collector log |
DB02_COLL_PLAN | Oracle monitoring: List of coll. functions for DB02 |
DB2DB02CONTROL | Control table for information in DB02 |
DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
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