DB2TSBACK SAP (List of tablespaces that need a backup) Table details
Dictionary Type: Table
Description: List of tablespaces that need a backup
Description: List of tablespaces that need a backup
Table field list including key, data, relationships and ABAP select examples
DB2TSBACK is a standard SAP Table which is used to store List of tablespaces that need a backup data and is available within R/3 SAP systems depending on the version and release level.
The DB2TSBACK table consists of various fields, each holding specific information or linking keys about List of tablespaces that need a backup data available in SAP. These include TIME_ANA (Time of the last check), DBNAM (Database name), TSNAM (Name of the tablespace), TSPART (Partition number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP DB2TSBACK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DATE_ANA | Date of the last check | DB2BCKDATE | DATS | 8 | DATUM | ||||
TIME_ANA | Time of the last check | DB2BCKTIME | TIMS | 6 | TIME | ||||
DBNAM | Database name | DB2DBNAME | CHAR | 8 | D2DBNAME | ||||
TSNAM | Name of the tablespace | DB2TSNAME | CHAR | 8 | CHAR8 | ||||
TSPART | Partition number | DB2PARTNRS | INT2 | 5 | DB2SINT | ||||
NAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | CHAR8 | ||||
CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | CHAR8 | ||||
BPOOL | DB2 buffer pool name | DB2BPNAME | CHAR | 8 | DB2BPNAME | ||||
LOCKRULE | Lock size of the tablespace | DB2LRULE | CHAR | 1 | DB2LRULE | ||||
LOCKMAX | Maximum number of locks per user before escalating | DB2LMAX | INT4 | 10 | DB2LMAX | ||||
CLOSERULE | Data sets for closure when limit of open data sets reached | DB2CRULE | CHAR | 1 | DB2CRULE | ||||
ENCODING | Default encoding scheme of the tablespace | DB2ENCODE | CHAR | 1 | DB2ENCODE | ||||
LOCKPART | Lockpart for the tablespace | DB2LPART | CHAR | 1 | DB2LPART | ||||
MAXROWS | Maximum number of rows that DB2 will place on a data page | DB2MROW | INT2 | 5 | DB2MROW | ||||
PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | INT2 | 5 | DB2PART | ||||
TYPE | Tablespace type | DB2TYPE | CHAR | 1 | DB2TYPE | ||||
SEGSIZE | Number of pages in each segment of a segmented tablespace | DB2SSIZE | INT2 | 5 | DB2SSIZE | ||||
SPACE | Number of KB of DASD Storage Allocated to Tablespace | DB2SPACE | INT4 | 10 | DB2SPACE | ||||
NTABLES | Number of tables defined in the tablespace | DB2NTAB | INT2 | 5 | DB2NTAB | ||||
STATUS | Availability status of tablespace | DB2STATS | CHAR | 1 | DB2STATS | ||||
STATSTIME | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | DB2TMSTMP | ||||
ERASERULE | Datasets are to be erased when dropped | DB2ERULE | CHAR | 1 | DB2ERULE | ||||
DBNAME | Database name | DB2DBNAME | CHAR | 8 | D2DBNAME | ||||
DSETPASS | The password for the datasets of the tablespace | DB2DPASS | CHAR | 8 | DB2DPASS | ||||
LOG | Whether the changes to a tablespace are to be logged | DB2LOG | CHAR | 1 | DB2LOG | ||||
DSSIZE | Maximum size of a dataset in KBytes | DB2DSIZE | INT4 | 10 | DB2DSIZE | ||||
PARTNR | Partition number | DB2PARTNRS | INT2 | 5 | DB2SINT | ||||
OPERATION | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | DB2TMSTMP | ||||
NDAYS | Number of days since last invocation | DB2DAYS | INT4 | 10 | DB2DAYS | ||||
PERCOFFPOS | Different of far and near optimal position in page | DB2OFFPOS | INT2 | 5 | DB2OFFPOS | ||||
PERCINDREF | Different of far and near relocated position in page | DB2INDREF | INT2 | 5 | DB2INDREF | ||||
PERCDROP | Percentage of space occupied by rows of dropped tables | DB2CDROP | INT2 | 5 | DB2CDROP | ||||
EXTENTS | Number of extents of a tablespace | DB2EXTENT | INT4 | 10 | DB2EXTENT | ||||
REASON | Reason running utility is recommended | DB2REASON | CHAR | 18 | DB2REASON |
Key field | Non-key field |
How do I retrieve data from SAP table DB2TSBACK using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB2TSBACK to SELECT all data from the tableDATA: WA_DB2TSBACK TYPE DB2TSBACK.
SELECT SINGLE *
FROM DB2TSBACK
INTO CORRESPONDING FIELDS OF WA_DB2TSBACK
WHERE...
How to access SAP table DB2TSBACK
Within an ECC or HANA version of SAP you can also view further information about DB2TSBACK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects