SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

DB2DB02TS_SUM Table in SAP | Tx DB02: Summary of TS info. Partitions are summed up Table & Fields List

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
DB2DB02TS_SUM table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
DBNAMEDatabase nameDB2DBNAMED2DBNAME
TSNAMEName of the tablespaceDB2TSNAMECHAR8
STORDATEDate when the storage information has been collectedDB2STODATEDATUM
STORTIMETime when the storage information has been collectedDB2STOTIMETIME
CREATORDB2 creator nameDB2CREATORCHAR8
PARTITIONSNumber of partitions of a tablespace or indexDB2NUMPARTDB2SINT
MAX_EXTENTSMaximum number of extents of a partition of the TS or IXDB2MAXEXTS  
SUM_EXTENTSTotal number of extents of a TS or index (parts summed up)DB2SUMEXTS  
SUM_DASD_USAGEActual DASD usage (in KB) of TS (sum of partitions)DB2DASD_USE_SUMFLTP
SUM_ALLOCSIZETotal size of a tablespace (allocated storage in KB)DB2TSSIZDEC11
SUM_FREESIZEFree size of a tablespace in KB (allocated minus used stor.)DB2TSFREEDEC11
PCTUSEDPercentage of used size to allocated size of a tablespaceDB2TSPCTUDEC3
RTS_LAST_REORGTimestamp of last REORGDB2CCOTIMEDB2TMSTMP
RTS_TOTALROWSDB2/zOS: Real-Time Statistics tablespace TOTALROWSDB2RTSTOTALROWSFLTP
RTS_CHANGESREO.:Changed rows (insert, delete or update) absolute numberDB2CCRCHGA  
RTS_REORG_RECSDB2/zOS: Number of REORG recommendations by DSNACCORDB2CCREORGRECS  
BASE_TS_DBNAMEDatabase nameDB2DBNAMED2DBNAME
BASE_TS_TSNAMEName of the tablespaceDB2TSNAMECHAR8

DB2DB02TS_SUM related tables

TableNote
DB2DB02IX_SUMTx DB02: Summary of Index info. Partitions are summed up
DB2DB02TS_SUMTx DB02: Summary of TS info. Partitions are summed up
DB2DB02EXTENTSTx DB02: Data for DB02's Extent Monitor
DB2DB02SUMMARYTx DB02: Summary information on first screenincl. size histo
DB2DB02TS_HISTx DB02: Short history of TS info
AIN_TEPC_PRTTNPartitions
DAAG_PARTITIONSHistory of Partitions Created for Tables
RSDB2NLS_QUEUEDB2-z/OS HiPe NLS: Partitions waiting for archiving
RSLPOPARTLogical Partitioning: Partitions of a LPO
/AIN/TEPC_PRTTNPartitions
/SDF/DB6PMCNDB6: Configuration Nodes (Partitions)
DB02_COLL_LOGOracle monitoring: DB02 collector log
DB02_COLL_PLANOracle monitoring: List of coll. functions for DB02
DB2DB02CONTROLControl table for information in DB02
DB2DB02IXDYNTx DB02: Dynamics of the size of indexes
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com