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


SAP DBSTATIDB2 table summary

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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