SAP DB2TSHIS_O table - DB2/390: Storage information on R/3 tablespaces details in SAP

SAP DB2TSHIS_O table summary

Object Name: DB2TSHIS_O
Dictionary Type: Structure
Description: DB2/390: Storage information on R/3 tablespaces

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

Details

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

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

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

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

DB2TSHIS_O-EXTENTS table field - Total number of extents of a tablespace or index ▼

Description: Total number of extents of a tablespace or index
Field Name: EXTENTS
Data Element: DB2NUMEXT5
Data Type: DEC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DEC5
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENTS

DB2TSHIS_O-ALLOCSIZE table field - Total size of a tablespace (allocated storage in KB) ▼

Description: Total size of a tablespace (allocated storage in KB)
Field Name: ALLOCSIZE
Data Element: DB2TSSIZ
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALLOCSIZE

DB2TSHIS_O-FREESIZE table field - Free size of a tablespace in KB (allocated minus used stor.) ▼

Description: Free size of a tablespace in KB (allocated minus used stor.)
Field Name: FREESIZE
Data Element: DB2TSFREE
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREESIZE

DB2TSHIS_O-PCTUSED table field - Percentage of used size to allocated size of a tablespace ▼

Description: Percentage of used size to allocated size of a tablespace
Field Name: PCTUSED
Data Element: DB2TSPCTU
Data Type: DEC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DEC3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTUSED

DB2TSHIS_O-STORDATE table field - Date when the storage information has been collected ▼

Description: Date when the storage information has been collected
Field Name: STORDATE
Data Element: DB2STODATE
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 STORDATE

View list of all SAP tables(S4H/ECC)

Select data from SAP table