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


SAP DB2IXDETLP table summary

Object Name: DB2IXDETLP
Dictionary Type: Structure
Description: Detailed Information on a Partition of a DB2 Index


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

Details
DB2IXDETLP-NAME table field - Name of a DB2 for OS/390 index

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

DB2IXDETLP-CREATOR table field - DB2 creator 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

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

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

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

DB2IXDETLP-LEAFDIST table field - 100 * avg number of leaf pages between successive leaf pages

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

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

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

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

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

DB2IXDETLP-FAROFFPOSF table field - Number of referred to rows far from optimal position

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

DB2IXDETLP-NEAROFFPOS table field - Number of referred to rows near the optimal position

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

DB2IXDETLP-CARDF table field - Number of keys in the index that refer to data rows or LOBs

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

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table