SAP ABAP Table DB2CCREORGTS (DB2CCREORG without keys)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB2 (Application Component) DB2 for z/OS
     STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category INTTAB    Structure 
Structure DB2CCREORGTS   Table Relationship Diagram
Short Description DB2CCREORG without keys    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 DATE_ANA DB2BCKDATE DATUM DATS 8   0   Date of the last check  
2 TIME_ANA DB2BCKTIME TIME TIMS 6   0   Time of the last check  
3 DBNAME DB2DBNAME D2DBNAME CHAR 8   0   Database name  
4 TSNAME DB2TSNAME CHAR8 CHAR 8   0   Name of the tablespace  
5 PARTI DB2PARTNRS DB2SINT INT2 5   0   Partition number  
6 CREATOR DB2CREATOR CHAR8 CHAR 8   0   DB2 creator name  
7 OBJTYPE DB2CCOBJT CHAR2 CHAR 2   0   DB2 object type: TS for tablespace, IX for indexspace  
8 OBJSTATUS DB2CCOBJS CHAR36 CHAR 36   0   DB2 object status: NULL, restricted states or orphaned  
9 REORGREC DB2CCOREC CHAR3 CHAR 3   0   REORG Recommendation: YES or NO  
10 EXCTABLE DB2CCEXCL CHAR40 CHAR 40   0   Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)  
11 REORGTIME DB2CCOTIME DB2TMSTMP CHAR 26   0   Timestamp of last REORG  
12 RTINSDELUP DB2CCRCHGS   INT4 10   0   REORG TS/IX: Changed rows in percent  
13 RTINSDELUPABS DB2CCRCHGA   INT4 10   0   REO.:Changed rows (insert, delete or update) absolute number  
14 RTINSPCT     FLTP 16   16    
15 RTINSABS     INT4 10   0    
16 RTDELPCT     FLTP 16   16    
17 RTDELABS     INT4 10   0    
18 RTUNCLUST     FLTP 16   16    
19 RTLOBPCT     FLTP 16   16    
20 RTDATASPRAT     FLTP 16   16    
21 RTMASSDEL DB2CCRMASS   INT4 10   0   REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)  
22 RTINDREF     FLTP 16   16    
23 RTACTIVEPAGES DB2CCRROWS   INT4 10   0   REORG TS/IX: Number of active pages  
24 EXTENT_NO DB2CCEXTNO INT2 INT2 5   0   Number of physical extents in TS, IS or partition  
History
Last changed by/on SAP  20130604 
SAP Release Created in 703