DB2DB02TSDYN - Tx DB02: Dynamics of the size of tablespaces

Tx DB02: Dynamics of the size of tablespaces information is stored in SAP table DB2DB02TSDYN.
 It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".

Fields for table DB2DB02TSDYN

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
DBNAMEDatabase nameXDB2DBNAMECHAR8
TSNAMEName of the tablespaceXDB2TSNAMECHAR8
PART_NRPartition numberXDB2PARTNRSINT22
CREATORDB2 creator nameDB2CREATORCHAR8
EXTENTSNumber of extentsDB2NUMEXTIINT44
D_EXTENTSNumber of extents: change per dayDB2CHGEXDIINT44
W_EXTENTSNumber of extents: change per weekDB2CHGEXWIINT44
M_EXTENTSNumber of extents: change per monthDB2CHGEXMIINT44
ALLOCSIZETotal size of a tablespace (allocated storage in KB)DB2TSSIZDEC6
D_ALLOCSIZAllocated storage in KB: change per dayDB2CHGSIZDDEC6
W_ALLOCSIZAllocated storage in KB: change per weekDB2CHGSIZWDEC6
M_ALLOCSIZAllocated storage in KB: change per monthDB2CHGSIZMDEC6
FREESIZEFree size of a tablespace in KB (allocated minus used stor.)DB2TSFREEDEC6
D_FREESIZFree storage (allocated minus used) in KB: change per dayDB2CHGFREDDEC6
W_FREESIZFree storage (allocated minus used) in KB: change per weekDB2CHGFREWDEC6
M_FREESIZFree storage (allocated minus used) in KB: change per monthDB2CHGFREMDEC6
RTS_TOTALROWSDB2/zOS: Real-Time Statistics tablespace TOTALROWSDB2RTSTOTALROWSFLTP8
D_TOTALROWSNumber of Rows: changes per dayDB2CHGROWDFLTP8
W_TOTALROWSNumber of Rows: changes per weekDB2CHGROWWFLTP8
M_TOTALROWSNumber of Rows: changes per monthDB2CHGROWMFLTP8
Privacy Policy