SAP ABAP Table DB2TSBACKN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	DB2TSBACKN	Table Relationship Diagram
Short Description	Generated Table for View

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	COPYREC	☐	DB2CCCPYR	CHAR3	CHAR	3	0	COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)
10	EXCTABLE	☐	DB2CCEXCL	CHAR40	CHAR	40	0	Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
11	ASSOCTS	☐	DB2CCASSTS	DB2TSNAME	CHAR	8	0	Associated tablespace for indexspace
12	COPYTIME	☐	DB2CCCTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last full image COPY
13	LOADREPLTI	☐	DB2CCLTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last LOAD REPLACE
14	REBUILDTIM	☐	DB2CCRTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REBUILD INDEX
15	FCUPDPGS	☐	DB2CCUPDPG		INT4	10	0	Full/Inc. Copy: Updated pages in percent of preformatted pag
16	FCCHGPCT	☐	DB2CCCCHGS		INT4	10	0	Full/Inc. Copy: Changed rows in percent
17	FCDAYSCOPY	☐	DB2CCCDAYS		INT4	10	0	Full Copy: Number of days since last COPY
18	FCINDEXSIZ	☐	DB2CCISIZE		INT4	10	0	Full Copy: Minimum size of index in pages (NACTIVE)
19	REORGTIME	☐	DB2CCOTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REORG

History

Last changed by/on	SAP	20130604
SAP Release Created in