DB2TSBACK is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2TSBACK in SAP.
- Table description : List of tablespaces that need a backup
- Module : BC-DB-DB2
- Parent Module : BC
- Package : STU2
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DB2TSBACK Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| DATE_ANA | Date of the last check | DB2BCKDATE | DATUM |
| TIME_ANA | Time of the last check | DB2BCKTIME | TIME |
| DBNAM | Database name | DB2DBNAME | D2DBNAME |
| TSNAM | Name of the tablespace | DB2TSNAME | CHAR8 |
| TSPART | Partition number | DB2PARTNRS | DB2SINT |
| .INCLUDE | Output List of Tablespace of CC/390 Stored Procedures | ||
| NAME | Name of the tablespace | DB2TSNAME | CHAR8 |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| BPOOL | DB2 buffer pool name | DB2BPNAME | DB2BPNAME |
| LOCKRULE | Lock size of the tablespace | DB2LRULE | DB2LRULE |
| LOCKMAX | Maximum number of locks per user before escalating | DB2LMAX | DB2LMAX |
| CLOSERULE | Data sets for closure when limit of open data sets reached | DB2CRULE | DB2CRULE |
| ENCODING | Default encoding scheme of the tablespace | DB2ENCODE | DB2ENCODE |
| LOCKPART | Lockpart for the tablespace | DB2LPART | DB2LPART |
| MAXROWS | Maximum number of rows that DB2 will place on a data page | DB2MROW | DB2MROW |
| PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | DB2PART |
| TYPE | Tablespace type | DB2TYPE | DB2TYPE |
| SEGSIZE | Number of pages in each segment of a segmented tablespace | DB2SSIZE | DB2SSIZE |
| SPACE | Number of KB of DASD Storage Allocated to Tablespace | DB2SPACE | DB2SPACE |
| NTABLES | Number of tables defined in the tablespace | DB2NTAB | DB2NTAB |
| STATUS | Availability status of tablespace | DB2STATS | DB2STATS |
| STATSTIME | Date and time of last RUNSTATS | DB2STATSTM | DB2TMSTMP |
| ERASERULE | Datasets are to be erased when dropped | DB2ERULE | DB2ERULE |
| DBNAME | Database name | DB2DBNAME | D2DBNAME |
| DSETPASS | The password for the datasets of the tablespace | DB2DPASS | DB2DPASS |
| LOG | Whether the changes to a tablespace are to be logged | DB2LOG | DB2LOG |
| DSSIZE | Maximum size of a dataset in KBytes | DB2DSIZE | DB2DSIZE |
| PARTNR | Partition number | DB2PARTNRS | DB2SINT |
| OPERATION | Date and time of last RUNSTATS | DB2STATSTM | DB2TMSTMP |
| NDAYS | Number of days since last invocation | DB2DAYS | DB2DAYS |
| PERCOFFPOS | Different of far and near optimal position in page | DB2OFFPOS | DB2OFFPOS |
| PERCINDREF | Different of far and near relocated position in page | DB2INDREF | DB2INDREF |
| PERCDROP | Percentage of space occupied by rows of dropped tables | DB2CDROP | DB2CDROP |
| EXTENTS | Number of extents of a tablespace | DB2EXTENT | DB2EXTENT |
| REASON | Reason running utility is recommended | DB2REASON | DB2REASON |
DB2TSBACK related tables
| Table | Note |
|---|---|
| DB2TSBACK | List of tablespaces that need a backup |
| DB2IXBACK | List of indexes that need a backup |
| CNVTDMS_EC_GRDEL | Contains list of sel. groups,which need not be shown to user |
| GUPDLAYOUT | List of Table Layouts that Need to Be Updated |
| DB2DB02TSDYN | Tx DB02: Dynamics of the size of tablespaces |
| DB2REOTS | REORG of Tablespaces |
| DB2TSSIZE_T | DB2/390: Storage Information on R/3 Tablespaces |
| DB6PMCK_P | DB6: All Backed Up Tablespaces of History File |
| LADB6 | DB6: Tablespaces for LOB data |
| TADB6 | DB6: Current DB2 UDB Tablespaces (Mapp.: Table Type->Table C |
| TAORA | Current ORACLE tablespaces |
| TSDB6 | DB6: Table With Tablespaces Allowed for DB2 Universal Databa |
| TSORA | Table of valid ORACLE tablespaces |
| CRMC_FS_NEEDCA_T | AO FS : Need Category Descriptions |
| CRMC_FS_NEEDTY_T | AO FS : Need Type Descriptions |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP