SAP DB2TSBACK table - List of tablespaces that need a backup details in SAP


SAP DB2TSBACK table summary

Object Name: DB2TSBACK
Dictionary Type: Transparent table
Description: List of tablespaces that need a backup


Field list for DB2TSBACK table on an S/4 SAP system

Details
DB2TSBACK-DATE_ANA table field - Date of the last check

Description: Date of the last check
Field Name: DATE_ANA
Data Element: DB2BCKDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_ANA

DB2TSBACK-TIME_ANA table field - Time of the last check

Description: Time of the last check
Field Name: TIME_ANA
Data Element: DB2BCKTIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_ANA

DB2TSBACK-DBNAM table field - Database name

Description: Database name
Field Name: DBNAM
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAM

DB2TSBACK-TSNAM table field - Name of the tablespace

Description: Name of the tablespace
Field Name: TSNAM
Data Element: DB2TSNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSNAM

DB2TSBACK-TSPART table field - Partition number

Description: Partition number
Field Name: TSPART
Data Element: DB2PARTNRS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSPART

DB2TSBACK-NAME table field - Name of the tablespace

Description: Name of the tablespace
Field Name: NAME
Data Element: DB2TSNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

DB2TSBACK-CREATOR table field - DB2 creator name

Description: DB2 creator name
Field Name: CREATOR
Data Element: DB2CREATOR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATOR

DB2TSBACK-BPOOL table field - DB2 buffer pool name

Description: DB2 buffer pool name
Field Name: BPOOL
Data Element: DB2BPNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPOOL

DB2TSBACK-LOCKRULE table field - Lock size of the tablespace

Description: Lock size of the tablespace
Field Name: LOCKRULE
Data Element: DB2LRULE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2LRULE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKRULE

DB2TSBACK-LOCKMAX table field - Maximum number of locks per user before escalating

Description: Maximum number of locks per user before escalating
Field Name: LOCKMAX
Data Element: DB2LMAX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2LMAX
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKMAX

DB2TSBACK-CLOSERULE table field - Data sets for closure when limit of open data sets reached

Description: Data sets for closure when limit of open data sets reached
Field Name: CLOSERULE
Data Element: DB2CRULE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2CRULE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLOSERULE

DB2TSBACK-ENCODING table field - Default encoding scheme of the tablespace

Description: Default encoding scheme of the tablespace
Field Name: ENCODING
Data Element: DB2ENCODE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2ENCODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENCODING

DB2TSBACK-LOCKPART table field - Lockpart for the tablespace

Description: Lockpart for the tablespace
Field Name: LOCKPART
Data Element: DB2LPART
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2LPART
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKPART

DB2TSBACK-MAXROWS table field - Maximum number of rows that DB2 will place on a data page

Description: Maximum number of rows that DB2 will place on a data page
Field Name: MAXROWS
Data Element: DB2MROW
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2MROW
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXROWS

DB2TSBACK-PARTITIONS table field - Number of partitions of the tablespace or indexspace

Description: Number of partitions of the tablespace or indexspace
Field Name: PARTITIONS
Data Element: DB2PART
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PART
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITIONS

DB2TSBACK-TYPE table field - Tablespace type

Description: Tablespace type
Field Name: TYPE
Data Element: DB2TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

DB2TSBACK-SEGSIZE table field - Number of pages in each segment of a segmented tablespace

Description: Number of pages in each segment of a segmented tablespace
Field Name: SEGSIZE
Data Element: DB2SSIZE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGSIZE

DB2TSBACK-SPACE table field - Number of KB of DASD Storage Allocated to Tablespace

Description: Number of KB of DASD Storage Allocated to Tablespace
Field Name: SPACE
Data Element: DB2SPACE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2SPACE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPACE

DB2TSBACK-NTABLES table field - Number of tables defined in the tablespace

Description: Number of tables defined in the tablespace
Field Name: NTABLES
Data Element: DB2NTAB
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2NTAB
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTABLES

DB2TSBACK-STATUS table field - Availability status of tablespace

Description: Availability status of tablespace
Field Name: STATUS
Data Element: DB2STATS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2STATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

DB2TSBACK-STATSTIME table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: STATSTIME
Data Element: DB2STATSTM
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: DB2TMSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATSTIME

DB2TSBACK-ERASERULE table field - Datasets are to be erased when dropped

Description: Datasets are to be erased when dropped
Field Name: ERASERULE
Data Element: DB2ERULE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2ERULE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERASERULE

DB2TSBACK-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

DB2TSBACK-DSETPASS table field - The password for the datasets of the tablespace

Description: The password for the datasets of the tablespace
Field Name: DSETPASS
Data Element: DB2DPASS
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DPASS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSETPASS

DB2TSBACK-LOG table field - Whether the changes to a tablespace are to be logged

Description: Whether the changes to a tablespace are to be logged
Field Name: LOG
Data Element: DB2LOG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2LOG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOG

DB2TSBACK-DSSIZE table field - Maximum size of a dataset in KBytes

Description: Maximum size of a dataset in KBytes
Field Name: DSSIZE
Data Element: DB2DSIZE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSIZE

DB2TSBACK-PARTNR table field - Partition number

Description: Partition number
Field Name: PARTNR
Data Element: DB2PARTNRS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTNR

DB2TSBACK-OPERATION table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: OPERATION
Data Element: DB2STATSTM
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: DB2TMSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPERATION

DB2TSBACK-NDAYS table field - Number of days since last invocation

Description: Number of days since last invocation
Field Name: NDAYS
Data Element: DB2DAYS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DAYS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NDAYS

DB2TSBACK-PERCOFFPOS table field - Different of far and near optimal position in page

Description: Different of far and near optimal position in page
Field Name: PERCOFFPOS
Data Element: DB2OFFPOS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2OFFPOS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERCOFFPOS

DB2TSBACK-PERCINDREF table field - Different of far and near relocated position in page

Description: Different of far and near relocated position in page
Field Name: PERCINDREF
Data Element: DB2INDREF
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2INDREF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERCINDREF

DB2TSBACK-PERCDROP table field - Percentage of space occupied by rows of dropped tables

Description: Percentage of space occupied by rows of dropped tables
Field Name: PERCDROP
Data Element: DB2CDROP
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CDROP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERCDROP

DB2TSBACK-EXTENTS table field - Number of extents of a tablespace

Description: Number of extents of a tablespace
Field Name: EXTENTS
Data Element: DB2EXTENT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2EXTENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENTS

DB2TSBACK-REASON table field - Reason running utility is recommended

Description: Reason running utility is recommended
Field Name: REASON
Data Element: DB2REASON
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: DB2REASON
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REASON


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table