SAP DBSTATTDB2 table - DB2/390 Statistics for Tables details in SAP

SAP DBSTATTDB2 table summary

Object Name: DBSTATTDB2
Dictionary Type: Transparent table
Description: DB2/390 Statistics for Tables

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

Details

DBSTATTDB2-NAME table field - DB2 table name ▼

Description: DB2 table name
Field Name: NAME
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 NAME

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

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

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

DBSTATTDB2-OPTIO table field - Sample Size for Collection of Statistics ▼

Description: Sample Size for Collection of Statistics
Field Name: OPTIO
Data Element: AM_OPTIO
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: CHAR5
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTIO

DBSTATTDB2-SIGNI table field - Significance for Collection of Statistics ▼

Description: Significance for Collection of Statistics
Field Name: SIGNI
Data Element: AM_SIGNI
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: AM_SIGNI
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIGNI

DBSTATTDB2-CARDF table field - Total number of rows in the table ▼

Description: Total number of rows in the table
Field Name: CARDF
Data Element: DB2CARDF
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 CARDF

DBSTATTDB2-NPAGES table field - Number of pages on which rows of the table appear ▼

Description: Number of pages on which rows of the table appear
Field Name: NPAGES
Data Element: DB2NPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NPAGES

DBSTATTDB2-PAGESIZE table field - DB2 for OS/390 page size in KBytes ▼

Description: DB2 for OS/390 page size in KBytes
Field Name: PAGESIZE
Data Element: DB2PGSIZE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PGSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGESIZE

DBSTATTDB2-PCTROWCOMP table field - Percentage of rows compressed within total number of rows ▼

Description: Percentage of rows compressed within total number of rows
Field Name: PCTROWCOMP
Data Element: DB2PCTCOMP
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 PCTROWCOMP

View list of all SAP tables(S4H/ECC)

Select data from SAP table