SAP ABAP View DB2TSBACKN (List of TS/IXS needing backup, new structure of DSNACCOR)

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

View Type	D	Database View
Database View	DB2TSBACKN
Short Description	List of TS/IXS needing backup, new structure of DSNACCOR
Root table	DB2CCDAILY	List of TS/IXS needing utility treatment (DSNACCOR Daily)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DB2CCDAILY	DB2CCDAILY

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DB2CCDAILY	COPYREC		NE	'NO'		AND	0	0
2	DB2CCDAILY	COPYREC		NE	''			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	DATE_ANA	DB2CCDAILY	DATE_ANA		☐	DB2BCKDATE	☐	Date of the last check
2	TIME_ANA	DB2CCDAILY	TIME_ANA		☐	DB2BCKTIME	☐	Time of the last check
3	DBNAME	DB2CCDAILY	DBNAM		☐	DB2DBNAME	☐	Database name
4	TSNAME	DB2CCDAILY	TSNAM		☐	DB2TSNAME	☐	Name of the tablespace
5	PARTI	DB2CCDAILY	TSPART		☐	DB2PARTNRS	☐	Partition number
6	CREATOR	DB2CCDAILY	CREATOR		☐	DB2CREATOR	☐	DB2 creator name
7	OBJTYPE	DB2CCDAILY	OBJTYPE		☐	DB2CCOBJT	☐	DB2 object type: TS for tablespace, IX for indexspace
8	OBJSTATUS	DB2CCDAILY	OBJSTATUS		☐	DB2CCOBJS	☐	DB2 object status: NULL, restricted states or orphaned
9	COPYREC	DB2CCDAILY	COPYREC		☐	DB2CCCPYR	☐	COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)
10	EXCTABLE	DB2CCDAILY	EXCTABLE		☐	DB2CCEXCL	☐	Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
11	ASSOCTS	DB2CCDAILY	ASSOCTS		☐	DB2CCASSTS	☐	Associated tablespace for indexspace
12	COPYTIME	DB2CCDAILY	COPYTIME		☐	DB2CCCTIME	☐	Timestamp of last full image COPY
13	LOADREPLTI	DB2CCDAILY	LOADREPLTI		☐	DB2CCLTIME	☐	Timestamp of last LOAD REPLACE
14	REBUILDTIM	DB2CCDAILY	REBUILDTIM		☐	DB2CCRTIME	☐	Timestamp of last REBUILD INDEX
15	FCUPDPGS	DB2CCDAILY	FCUPDPGS		☐	DB2CCUPDPG	☐	Full/Inc. Copy: Updated pages in percent of preformatted pag
16	FCCHGPCT	DB2CCDAILY	FCCHGPCT		☐	DB2CCCCHGS	☐	Full/Inc. Copy: Changed rows in percent
17	FCDAYSCOPY	DB2CCDAILY	FCDAYSCOPY		☐	DB2CCCDAYS	☐	Full Copy: Number of days since last COPY
18	FCINDEXSIZ	DB2CCDAILY	FCINDEXSIZ		☐	DB2CCISIZE	☐	Full Copy: Minimum size of index in pages (NACTIVE)
19	REORGTIME	DB2CCDAILY	REORGTIME		☐	DB2CCOTIME	☐	Timestamp of last REORG

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in	620