| DBNAME |
Database name |
CHAR |
8 |
0 |
|
DB2DBNAME
|
|
| TSNAME |
Name of the tablespace |
CHAR |
8 |
0 |
|
DB2TSNAME
|
|
| PARTI |
Data set number or partition number |
INT2 |
5 |
0 |
|
DB2CCPART
|
|
| OBJTYPE |
DB2 object type: TS for tablespace, IX for indexspace |
CHAR |
2 |
0 |
|
DB2CCOBJT
|
|
| OBJSTATUS |
DB2 object status: NULL, restricted states or orphaned |
CHAR |
36 |
0 |
|
DB2CCOBJS
|
|
| COPYREC |
COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) |
CHAR |
3 |
0 |
|
DB2CCCPYR
|
|
| RUNSTREC |
RUNSTATS Recommendation: YES or NO |
CHAR |
3 |
0 |
|
DB2CCSREC
|
|
| EXTENTS |
Extentlimit was exceeded: YES or NO |
CHAR |
3 |
0 |
|
DB2CCEXTL
|
|
| REORGREC |
REORG Recommendation: YES or NO |
CHAR |
3 |
0 |
|
DB2CCOREC
|
|
| EXCTABLE |
Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) |
CHAR |
40 |
0 |
|
DB2CCEXCL
|
|
| ASSOCTS |
Associated tablespace for indexspace |
CHAR |
8 |
0 |
|
DB2CCASSTS
|
|
| COPYTIME |
Timestamp of last full image COPY |
CHAR |
26 |
0 |
|
DB2CCCTIME
|
|
| LOADREPLTI |
Timestamp of last LOAD REPLACE |
CHAR |
26 |
0 |
|
DB2CCLTIME
|
|
| REBUILDTIM |
Timestamp of last REBUILD INDEX |
CHAR |
26 |
0 |
|
DB2CCRTIME
|
|
| FCUPDPGS |
Full/Inc. Copy: Updated pages in percent of preformatted pag |
INT4 |
10 |
0 |
|
DB2CCUPDPG
|
|
| FCCHGPCT |
Full/Inc. Copy: Changed rows in percent |
INT4 |
10 |
0 |
|
DB2CCCCHGS
|
|
| FCDAYSCOPY |
Full Copy: Number of days since last COPY |
INT4 |
10 |
0 |
|
DB2CCCDAYS
|
|
| FCINDEXSIZ |
Full Copy: Minimum size of index in pages (NACTIVE) |
INT4 |
10 |
0 |
|
DB2CCISIZE
|
|
| REORGTIME |
Timestamp of last REORG |
CHAR |
26 |
0 |
|
DB2CCOTIME
|
|
| RTINSDELUP |
REORG TS/IX: Changed rows in percent |
INT4 |
10 |
0 |
|
DB2CCRCHGS
|
|
| RTUNCLUST |
REORG TS: Unclustered inserts in percent |
INT4 |
10 |
0 |
|
DB2CCUNCLU
|
|
| RTLOBPCT |
REORG TS: Disorganized LOBs in percent |
INT4 |
10 |
0 |
|
DB2CCLOB
|
|
| RTMASSDEL |
REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) |
INT4 |
10 |
0 |
|
DB2CCRMASS
|
|
| RTINDREF |
REORG TS: Indirect references (overflow records) in percent |
INT4 |
10 |
0 |
|
DB2CCIND
|
|
| RIINSDEL |
REORG TS/IX: Changed rows in percent |
INT4 |
10 |
0 |
|
DB2CCRCHGS
|
|
| RIAPPINS |
REORG Index: Appended rows (with greater key) in percent |
INT4 |
10 |
0 |
|
DB2CCAPP
|
|
| RIPSEUDODE |
REORG Index: Pseudo deletes in percent |
INT4 |
10 |
0 |
|
DB2CCPSEUD
|
|
| RIMASSDEL |
REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) |
INT4 |
10 |
0 |
|
DB2CCRMASS
|
|
| RILEAFLIM |
REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent |
INT4 |
10 |
0 |
|
DB2CCLEAF
|
|
| RINUMLEVEL |
REORG Index: Change to number of index tree levels absolute |
INT4 |
10 |
0 |
|
DB2CCLEVEL
|
|
| RUNSTATSTI |
Timestamp of last RUNSTATS |
CHAR |
26 |
0 |
|
DB2CCSTIME
|
|
| STINSDELP |
RUNSTATS TS/IX: Changed rows in percent |
INT4 |
10 |
0 |
|
DB2CCSCHGS
|
|
| STINSDELA |
RUN.:Changed rows (insert, delete or update) absolute number |
FLTP |
16 |
16 |
|
DB2CCCHGA
|
|
| STMASSDEL |
RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) |
INT4 |
10 |
0 |
|
DB2CCSMASS
|
|
| SIINSDELP |
RUNSTATS TS/IX: Changed rows in percent |
INT4 |
10 |
0 |
|
DB2CCSCHGS
|
|
| SIINSDELA |
RUN.:Changed rows (insert, delete or update) absolute number |
FLTP |
16 |
16 |
|
DB2CCCHGA
|
|
| SIMASSDEL |
RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) |
INT4 |
10 |
0 |
|
DB2CCSMASS
|
|
| EXTENT_NO |
Number of physical extents in TS, IS or partition |
INT2 |
5 |
0 |
|
DB2CCEXTNO
|
|