SAP DB2DB02IXSIZE table - Tx DB02: List of indexspace datasets details in SAP


SAP DB2DB02IXSIZE table summary

Object Name: DB2DB02IXSIZE
Dictionary Type: Transparent table
Description: Tx DB02: List of indexspace datasets


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

Details
DB2DB02IXSIZE-IXCREATOR table field - DB2 creator name

Description: DB2 creator name
Field Name: IXCREATOR
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 IXCREATOR

DB2DB02IXSIZE-IXNAME table field - Name of a DB2 for OS/390 index

Description: Name of a DB2 for OS/390 index
Field Name: IXNAME
Data Element: DB2IDXNAME
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

DB2DB02IXSIZE-PART_EXTENSION table field - Extension or Partition (non-partitioned TS) number

Description: Extension or Partition (non-partitioned TS) number
Field Name: PART_EXTENSION
Data Element: DB2PARTEXT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PART_EXTENSION

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

DB2DB02IXSIZE-STORTIME table field - Time when the storage information has been collected

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

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

DB2DB02IXSIZE-IXSPACE table field - Name of the indexspace that contains the index

Description: Name of the indexspace that contains the index
Field Name: IXSPACE
Data Element: DB2IXSPACE
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 IXSPACE

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

DB2DB02IXSIZE-DSNAME table field - Dataset name

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

DB2DB02IXSIZE-EXTENTS table field - Number of extents

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

See all SAP tables containing field EXTENTS

DB2DB02IXSIZE-DASD_USAGE table field - Actual DASD usage (in KB) of dataset

Description: Actual DASD usage (in KB) of dataset
Field Name: DASD_USAGE
Data Element: DB2DASD_USAGE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DASD_USAGE

DB2DB02IXSIZE-ALLOCSIZE table field - Allocated storage of a partition of an index in KB

Description: Allocated storage of a partition of an index in KB
Field Name: ALLOCSIZE
Data Element: DB2IXSIZP
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

DB2DB02IXSIZE-FREESIZE table field - Free size of an index partition in KB

Description: Free size of an index partition in KB
Field Name: FREESIZE
Data Element: DB2IXFREEP
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

DB2DB02IXSIZE-PCTUSED table field - Percentage of used to alloc. size of a partition of an IX

Description: Percentage of used to alloc. size of a partition of an IX
Field Name: PCTUSED
Data Element: DB2IXPCTUP
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

DB2DB02IXSIZE-PQTY table field - Primary space allocation

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

DB2DB02IXSIZE-SQTY table field - Secondary space allocation

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

DB2DB02IXSIZE-QTYUNIT table field - Unit in which primary and secondary allocation are given

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table