Table/Structure Field list used by SAP ABAP View DB2TSBACKN (List of TS/IXS needing backup, new structure of DSNACCOR)
SAP ABAP View 
DB2TSBACKN (List of TS/IXS needing backup, new structure of DSNACCOR) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DB2CCDAILY - REBUILDTIM | Timestamp of last REBUILD INDEX | |
| 2 | Table/Structure Field |
DB2CCDAILY - FCUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | |
| 3 | Table/Structure Field |
DB2CCDAILY - FCUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | |
| 4 | Table/Structure Field |
DB2CCDAILY - LOADREPLTI | Timestamp of last LOAD REPLACE | |
| 5 | Table/Structure Field |
DB2CCDAILY - LOADREPLTI | Timestamp of last LOAD REPLACE | |
| 6 | Table/Structure Field |
DB2CCDAILY - OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | |
| 7 | Table/Structure Field |
DB2CCDAILY - OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | |
| 8 | Table/Structure Field |
DB2CCDAILY - OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | |
| 9 | Table/Structure Field |
DB2CCDAILY - OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | |
| 10 | Table/Structure Field |
DB2CCDAILY - REBUILDTIM | Timestamp of last REBUILD INDEX | |
| 11 | Table/Structure Field |
DB2CCDAILY - FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | |
| 12 | Table/Structure Field |
DB2CCDAILY - REORGTIME | Timestamp of last REORG | |
| 13 | Table/Structure Field |
DB2CCDAILY - REORGTIME | Timestamp of last REORG | |
| 14 | Table/Structure Field |
DB2CCDAILY - TIME_ANA | Time of the last check | |
| 15 | Table/Structure Field |
DB2CCDAILY - TIME_ANA | Time of the last check | |
| 16 | Table/Structure Field |
DB2CCDAILY - TSNAM | Name of the tablespace | |
| 17 | Table/Structure Field |
DB2CCDAILY - TSNAM | Name of the tablespace | |
| 18 | Table/Structure Field |
DB2CCDAILY - TSPART | Partition number | |
| 19 | Table/Structure Field |
DB2CCDAILY - TSPART | Partition number | |
| 20 | Table/Structure Field |
DB2CCDAILY - DBNAM | Database name | |
| 21 | Table/Structure Field |
DB2CCDAILY - ASSOCTS | Associated tablespace for indexspace | |
| 22 | Table/Structure Field |
DB2CCDAILY - COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | |
| 23 | Table/Structure Field |
DB2CCDAILY - COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | |
| 24 | Table/Structure Field |
DB2CCDAILY - COPYTIME | Timestamp of last full image COPY | |
| 25 | Table/Structure Field |
DB2CCDAILY - COPYTIME | Timestamp of last full image COPY | |
| 26 | Table/Structure Field |
DB2CCDAILY - CREATOR | DB2 creator name | |
| 27 | Table/Structure Field |
DB2CCDAILY - CREATOR | DB2 creator name | |
| 28 | Table/Structure Field |
DB2CCDAILY - DATE_ANA | Date of the last check | |
| 29 | Table/Structure Field |
DB2CCDAILY - DATE_ANA | Date of the last check | |
| 30 | Table/Structure Field |
DB2CCDAILY - ASSOCTS | Associated tablespace for indexspace | |
| 31 | Table/Structure Field |
DB2CCDAILY - DBNAM | Database name | |
| 32 | Table/Structure Field |
DB2CCDAILY - EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | |
| 33 | Table/Structure Field |
DB2CCDAILY - EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | |
| 34 | Table/Structure Field |
DB2CCDAILY - FCCHGPCT | Full/Inc. Copy: Changed rows in percent | |
| 35 | Table/Structure Field |
DB2CCDAILY - FCCHGPCT | Full/Inc. Copy: Changed rows in percent | |
| 36 | Table/Structure Field |
DB2CCDAILY - FCDAYSCOPY | Full Copy: Number of days since last COPY | |
| 37 | Table/Structure Field |
DB2CCDAILY - FCDAYSCOPY | Full Copy: Number of days since last COPY | |
| 38 | Table/Structure Field |
DB2CCDAILY - FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) |
