DB2TSBACK - List of tablespaces that need a backup
List of tablespaces that need a backup information is stored in SAP table DB2TSBACK.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2TSBACK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DATE_ANA | Date of the last check | X | DB2BCKDATE | DATS | 8 | |
| TIME_ANA | Time of the last check | X | DB2BCKTIME | TIMS | 6 | |
| DBNAM | Database name | X | DB2DBNAME | CHAR | 8 | |
| TSNAM | Name of the tablespace | X | DB2TSNAME | CHAR | 8 | |
| TSPART | Partition number | X | DB2PARTNRS | INT2 | 2 | |
| .INCLUDE | DB2CCOUTTS | 0 | ||||
| NAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | ||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| BPOOL | DB2 buffer pool name | DB2BPNAME | CHAR | 8 | ||
| LOCKRULE | Lock size of the tablespace | DB2LRULE | CHAR | 1 | ||
| LOCKMAX | Maximum number of locks per user before escalating | DB2LMAX | INT4 | 4 | ||
| CLOSERULE | Data sets for closure when limit of open data sets reached | DB2CRULE | CHAR | 1 | ||
| ENCODING | Default encoding scheme of the tablespace | DB2ENCODE | CHAR | 1 | ||
| LOCKPART | Lockpart for the tablespace | DB2LPART | CHAR | 1 | ||
| MAXROWS | Maximum number of rows that DB2 will place on a data page | DB2MROW | INT2 | 2 | ||
| PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | INT2 | 2 | ||
| TYPE | Tablespace type | DB2TYPE | CHAR | 1 | ||
| SEGSIZE | Number of pages in each segment of a segmented tablespace | DB2SSIZE | INT2 | 2 | ||
| SPACE | Number of KB of DASD Storage Allocated to Tablespace | DB2SPACE | INT4 | 4 | ||
| NTABLES | Number of tables defined in the tablespace | DB2NTAB | INT2 | 2 | ||
| STATUS | Availability status of tablespace | DB2STATS | CHAR | 1 | ||
| STATSTIME | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | ||
| ERASERULE | Datasets are to be erased when dropped | DB2ERULE | CHAR | 1 | ||
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| DSETPASS | The password for the datasets of the tablespace | DB2DPASS | CHAR | 8 | ||
| LOG | Whether the changes to a tablespace are to be logged | DB2LOG | CHAR | 1 | ||
| DSSIZE | Maximum size of a dataset in KBytes | DB2DSIZE | INT4 | 4 | ||
| PARTNR | Partition number | DB2PARTNRS | INT2 | 2 | ||
| OPERATION | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | ||
| NDAYS | Number of days since last invocation | DB2DAYS | INT4 | 4 | ||
| PERCOFFPOS | Different of far and near optimal position in page | DB2OFFPOS | INT2 | 2 | ||
| PERCINDREF | Different of far and near relocated position in page | DB2INDREF | INT2 | 2 | ||
| PERCDROP | Percentage of space occupied by rows of dropped tables | DB2CDROP | INT2 | 2 | ||
| EXTENTS | Number of extents of a tablespace | DB2EXTENT | INT4 | 4 | ||
| REASON | Reason running utility is recommended | DB2REASON | CHAR | 18 |