SAP DB2TSDETL table - Detailed Information on a DB2 Tablespace details in SAP

  


SAP DB2TSDETL table summary

Object Name: DB2TSDETL
Dictionary Type: Structure
Description: Detailed Information on a DB2 Tablespace


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

Details
DB2TSDETL-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

DB2TSDETL-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

DB2TSDETL-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

DB2TSDETL-BPOOL table field - DB2/390: Buffer pool ▼

Description: DB2/390: Buffer pool
Field Name: BPOOL
Data Element: DB2BUFPOOL
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BUFPOOL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPOOL

DB2TSDETL-STATUS table field - Availability status of the tablespace ▼

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

See all SAP tables containing field STATUS

DB2TSDETL-PARTITIONS table field - Number of partitions of a tablespace or index ▼

Description: Number of partitions of a tablespace or index
Field Name: PARTITIONS
Data Element: DB2NUMPART
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 PARTITIONS

DB2TSDETL-PGSIZE table field - DB2 for OS/390 page size in KBytes ▼

Description: DB2 for OS/390 page size in KBytes
Field Name: PGSIZE
Data Element: DB2PGSIZE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PGSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGSIZE

DB2TSDETL-NTABLES table field - Number of tables defined in the tablespace ▼

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

See all SAP tables containing field NTABLES

DB2TSDETL-NACTIVE table field - Number of active pages in the tablespace ▼

Description: Number of active pages in the tablespace
Field Name: NACTIVE
Data Element: DB2NACTIVE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NACTIVE

DB2TSDETL-SEGSIZE table field - Number of pages in a segment of a segmented tablespace ▼

Description: Number of pages in a segment of a segmented tablespace
Field Name: SEGSIZE
Data Element: DB2SEGSIZE
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 SEGSIZE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table