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