SAP DBSTAIHDB2 table - DB2/390 Statistics for Indexes details in SAP


SAP DBSTAIHDB2 table summary

Object Name: DBSTAIHDB2
Dictionary Type: Transparent table
Description: DB2/390 Statistics for Indexes


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

Details
DBSTAIHDB2-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

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

DBSTAIHDB2-TIMESTAMP table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: TIMESTAMP
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 TIMESTAMP

DBSTAIHDB2-TBNAME table field - DB2 table name

Description: DB2 table name
Field Name: TBNAME
Data Element: DB2TABNAME
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 TBNAME

DBSTAIHDB2-VWTYP table field - Type of Usage of Table Entry

Description: Type of Usage of Table Entry
Field Name: VWTYP
Data Element: AM_VWTYP
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: AM_VWTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VWTYP

DBSTAIHDB2-CLURATIO table field - DB2 for OS/390 cluster ratio

Description: DB2 for OS/390 cluster ratio
Field Name: CLURATIO
Data Element: DB2CLURAT
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INT1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLURATIO

DBSTAIHDB2-FIRSTKCARD table field - Number of distinct values in key (first column or full key)

Description: Number of distinct values in key (first column or full key)
Field Name: FIRSTKCARD
Data Element: DB2KEYCARD
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTKCARD

DBSTAIHDB2-FULLKCARD table field - Number of distinct values in key (first column or full key)

Description: Number of distinct values in key (first column or full key)
Field Name: FULLKCARD
Data Element: DB2KEYCARD
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLKCARD

DBSTAIHDB2-NLEAF table field - Number of active leaf pages in the index

Description: Number of active leaf pages in the index
Field Name: NLEAF
Data Element: DB2NLEAF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NLEAF

DBSTAIHDB2-NLEVELS table field - DB2 for OS/390 number of levels in the index tree

Description: DB2 for OS/390 number of levels in the index tree
Field Name: NLEVELS
Data Element: DB2NLEVELS
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 NLEVELS

DBSTAIHDB2-NEAROFFPOS table field - Number of referred to rows near/far from optimal position

Description: Number of referred to rows near/far from optimal position
Field Name: NEAROFFPOS
Data Element: DB2OFFPOSF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEAROFFPOS

DBSTAIHDB2-FAROFFPOS table field - Number of referred to rows near/far from optimal position

Description: Number of referred to rows near/far from optimal position
Field Name: FAROFFPOS
Data Element: DB2OFFPOSF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAROFFPOS

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

DBSTAIHDB2-DSSIZE table field - DB2 for OS/390 size of a dataset in KBytes

Description: DB2 for OS/390 size of a dataset in KBytes
Field Name: DSSIZE
Data Element: DB2SIZEK
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DB2SIZEK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSIZE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table