SAP ABAP Table DB2TSBACK (List of tablespaces that need a backup)

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

Table Category	TRANSP	Transparent table
Transparent table	DB2TSBACK	Table Relationship Diagram
Short Description	List of tablespaces that need a backup

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	DBNAM	☑	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
4	TSNAM	☑	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
5	TSPART	☑	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
6	.INCLUDE	☐				0	0	Output List of Tablespace of CC/390 Stored Procedures
7	NAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
8	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
9	BPOOL	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
10	LOCKRULE	☐	DB2LRULE	DB2LRULE	CHAR	1	0	Lock size of the tablespace
11	LOCKMAX	☐	DB2LMAX	DB2LMAX	INT4	10	0	Maximum number of locks per user before escalating
12	CLOSERULE	☐	DB2CRULE	DB2CRULE	CHAR	1	0	Data sets for closure when limit of open data sets reached
13	ENCODING	☐	DB2ENCODE	DB2ENCODE	CHAR	1	0	Default encoding scheme of the tablespace
14	LOCKPART	☐	DB2LPART	DB2LPART	CHAR	1	0	Lockpart for the tablespace
15	MAXROWS	☐	DB2MROW	DB2MROW	INT2	5	0	Maximum number of rows that DB2 will place on a data page
16	PARTITIONS	☐	DB2PART	DB2PART	INT2	5	0	Number of partitions of the tablespace or indexspace
17	TYPE	☐	DB2TYPE	DB2TYPE	CHAR	1	0	Tablespace type
18	SEGSIZE	☐	DB2SSIZE	DB2SSIZE	INT2	5	0	Number of pages in each segment of a segmented tablespace
19	SPACE	☐	DB2SPACE	DB2SPACE	INT4	10	0	Number of KB of DASD Storage Allocated to Tablespace
20	NTABLES	☐	DB2NTAB	DB2NTAB	INT2	5	0	Number of tables defined in the tablespace
21	STATUS	☐	DB2STATS	DB2STATS	CHAR	1	0	Availability status of tablespace
22	STATSTIME	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
23	ERASERULE	☐	DB2ERULE	DB2ERULE	CHAR	1	0	Datasets are to be erased when dropped
24	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
25	DSETPASS	☐	DB2DPASS	DB2DPASS	CHAR	8	0	The password for the datasets of the tablespace
26	LOG	☐	DB2LOG	DB2LOG	CHAR	1	0	Whether the changes to a tablespace are to be logged
27	DSSIZE	☐	DB2DSIZE	DB2DSIZE	INT4	10	0	Maximum size of a dataset in KBytes
28	PARTNR	☐	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
29	OPERATION	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
30	NDAYS	☐	DB2DAYS	DB2DAYS	INT4	10	0	Number of days since last invocation
31	PERCOFFPOS	☐	DB2OFFPOS	DB2OFFPOS	INT2	5	0	Different of far and near optimal position in page
32	PERCINDREF	☐	DB2INDREF	DB2INDREF	INT2	5	0	Different of far and near relocated position in page
33	PERCDROP	☐	DB2CDROP	DB2CDROP	INT2	5	0	Percentage of space occupied by rows of dropped tables
34	EXTENTS	☐	DB2EXTENT	DB2EXTENT	INT4	10	0	Number of extents of a tablespace
35	REASON	☐	DB2REASON	DB2REASON	CHAR	18	0	Reason running utility is recommended

History

Last changed by/on	SAP	20110908
SAP Release Created in	732