SAP DB2TSSIZE table - DB2/390: Storage Information on R/3 Tablespaces details in SAP

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

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

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

Description: Dataset name
Field Name: DSNAME
Data Element: DB2DSNAME
Data Type: CHAR
length (Dec): 44(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR44
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSNAME

Description: Total number of extents of a tablespace or index
Field Name: EXTENTS
Data Element: DB2NUMEXTS
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 EXTENTS

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

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

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

Description: Maximum number of extents of a partition of the TS or IX
Field Name: MAXEXTENTS
Data Element: DB2MAXEXTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXEXTENTS

Description: Primary space allocation
Field Name: PQTY
Data Element: DB2PQTY
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PQTY

Description: Secondary space allocation
Field Name: SQTY
Data Element: DB2SQTY
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQTY

Description: Unit in which primary and secondary allocation are given
Field Name: QTYUNIT
Data Element: DB2QTYUNIT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2QTYUNIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QTYUNIT

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

Description: Time when the storage information has been collected
Field Name: STORTIME
Data Element: DB2STOTIME
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 STORTIME