SAP DB2TSDETLP table - Detailed Information on a Partition of a DB2 Tablespace details in SAP


SAP DB2TSDETLP table summary

Object Name: DB2TSDETLP
Dictionary Type: Structure
Description: Detailed Information on a Partition of a DB2 Tablespace


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

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

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

DB2TSDETLP-PART table field - Partition number

Description: Partition number
Field Name: PART
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 PART

DB2TSDETLP-IXNAME table field - Name of the partitioned index

Description: Name of the partitioned index
Field Name: IXNAME
Data Element: DB2PIXNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IXNAME

DB2TSDETLP-IXCREATOR table field - Authorization ID of the creator of the partitioned index

Description: Authorization ID of the creator of the partitioned index
Field Name: IXCREATOR
Data Element: DB2CREATPI
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CREATOR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IXCREATOR

DB2TSDETLP-STORNAME table field - Name of the storage group used for space allocation

Description: Name of the storage group used for space allocation
Field Name: STORNAME
Data Element: DB2STOGRP
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 STORNAME

DB2TSDETLP-VCATNAME table field - Name of the integrated catalog facility catalog

Description: Name of the integrated catalog facility catalog
Field Name: VCATNAME
Data Element: DB2VCAT
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 VCATNAME

DB2TSDETLP-CARD table field - Number of rows in the tablespace or partition

Description: Number of rows in the tablespace or partition
Field Name: CARD
Data Element: DB2CARD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CARD

DB2TSDETLP-FARINDREF table field - Number of rows relocated far from their original page

Description: Number of rows relocated far from their original page
Field Name: FARINDREF
Data Element: DB2FARINDR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FARINDREF

DB2TSDETLP-NEARINDREF table field - Number of rows relocated near their original page

Description: Number of rows relocated near their original page
Field Name: NEARINDREF
Data Element: DB2NEARIND
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEARINDREF

DB2TSDETLP-PERCACTIVE table field - Percentage of space occupied by rows of active tables

Description: Percentage of space occupied by rows of active tables
Field Name: PERCACTIVE
Data Element: DB2PERCACT
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 PERCACTIVE

DB2TSDETLP-FREEPAGE table field - Number of pages loaded before a page is left as free space

Description: Number of pages loaded before a page is left as free space
Field Name: FREEPAGE
Data Element: DB2FREEPG
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 FREEPAGE

DB2TSDETLP-PCTFREE table field - Percentage of each page left as free space

Description: Percentage of each page left as free space
Field Name: PCTFREE
Data Element: DB2PCTFRES
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 PCTFREE

DB2TSDETLP-COMPRESS table field - Indicates whether the COMPRESS attribute is YES

Description: Indicates whether the COMPRESS attribute is YES
Field Name: COMPRESS
Data Element: DB2CMPRESS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPRESS

DB2TSDETLP-PAGESAVE table field - Percentage of pages saved in the TS because of compression

Description: Percentage of pages saved in the TS because of compression
Field Name: PAGESAVE
Data Element: DB2PGSAVE
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 PAGESAVE

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

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

DB2TSDETLP-GBPCACHE table field - Group buffer pool cache option

Description: Group buffer pool cache option
Field Name: GBPCACHE
Data Element: DB2GBPCACH
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2GBPCACH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GBPCACHE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table