SAP DB2IXDETLP table - Detailed Information on a Partition of a DB2 Index details in SAP

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

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

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

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

Description: 100 * avg number of leaf pages between successive leaf pages
Field Name: LEAFDIST
Data Element: DB2LEAFDIS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAFDIST

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

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

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

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

Description: Number of referred to rows far from optimal position
Field Name: FAROFFPOSF
Data Element: DB2FAROFFP
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAROFFPOSF

Description: Number of referred to rows near the optimal position
Field Name: NEAROFFPOS
Data Element: DB2NEAROFF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEAROFFPOS

Description: Number of keys in the index that refer to data rows or LOBs
Field Name: CARDF
Data Element: DB2IXCARDF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CARDF

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