SAP DB2_RECOM_RUNSTATS table - Structure for RUNSTATS Recommendation Viewer details in SAP

SAP DB2_RECOM_RUNSTATS table summary

Object Name: DB2_RECOM_RUNSTATS
Dictionary Type: Structure
Description: Structure for RUNSTATS Recommendation Viewer

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

Details

DB2_RECOM_RUNSTATS-EXCLUDED table field - c1 flag ▼

Description: c1 flag
Field Name: EXCLUDED
Data Element: DB2FLAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCLUDED

DB2_RECOM_RUNSTATS-DATE_ANA table field - Date of the last check ▼

Description: Date of the last check
Field Name: DATE_ANA
Data Element: DB2BCKDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_ANA

DB2_RECOM_RUNSTATS-TIME_ANA table field - Time of the last check ▼

Description: Time of the last check
Field Name: TIME_ANA
Data Element: DB2BCKTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_ANA

DB2_RECOM_RUNSTATS-DBNAME table field - Database name ▼

Description: Database name
Field Name: DBNAME
Data Element: DB2DBNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

DB2_RECOM_RUNSTATS-TSNAME table field - Name of the tablespace ▼

Description: Name of the tablespace
Field Name: TSNAME
Data Element: DB2TSNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSNAME

DB2_RECOM_RUNSTATS-PARTI table field - Partition number ▼

Description: Partition number
Field Name: PARTI
Data Element: DB2PARTNRS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTI

DB2_RECOM_RUNSTATS-CREATOR table field - DB2 creator name ▼

Description: DB2 creator name
Field Name: CREATOR
Data Element: DB2CREATOR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATOR

DB2_RECOM_RUNSTATS-IXNAME table field - Name of a DB2 for OS/390 index ▼

Description: Name of a DB2 for OS/390 index
Field Name: IXNAME
Data Element: DB2IDXNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IXNAME

DB2_RECOM_RUNSTATS-OBJTYPE table field - DB2 object type: TS for tablespace, IX for indexspace ▼

Description: DB2 object type: TS for tablespace, IX for indexspace
Field Name: OBJTYPE
Data Element: DB2CCOBJT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJTYPE

DB2_RECOM_RUNSTATS-OBJSTATUS table field - DB2 object status: NULL, restricted states or orphaned ▼

Description: DB2 object status: NULL, restricted states or orphaned
Field Name: OBJSTATUS
Data Element: DB2CCOBJS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJSTATUS

DB2_RECOM_RUNSTATS-RUNSTREC table field - RUNSTATS Recommendation: YES or NO ▼

Description: RUNSTATS Recommendation: YES or NO
Field Name: RUNSTREC
Data Element: DB2CCSREC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNSTREC

DB2_RECOM_RUNSTATS-EXCTABLE table field - Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) ▼

Description: Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
Field Name: EXCTABLE
Data Element: DB2CCEXCL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCTABLE

DB2_RECOM_RUNSTATS-ASSOCTS table field - Associated tablespace for indexspace ▼

Description: Associated tablespace for indexspace
Field Name: ASSOCTS
Data Element: DB2CCASSTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ASSOCTS

DB2_RECOM_RUNSTATS-RUNSTATSTI table field - Timestamp of last RUNSTATS ▼

Description: Timestamp of last RUNSTATS
Field Name: RUNSTATSTI
Data Element: DB2CCSTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNSTATSTI

DB2_RECOM_RUNSTATS-STINSDELP table field - RUNSTATS TS/IX: Changed rows in percent ▼

Description: RUNSTATS TS/IX: Changed rows in percent
Field Name: STINSDELP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STINSDELP

DB2_RECOM_RUNSTATS-STINSDELA table field - RUN.:Changed rows (insert, delete or update) absolute number ▼

Description: RUN.:Changed rows (insert, delete or update) absolute number
Field Name: STINSDELA
Data Element: DB2CCCHGA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STINSDELA

DB2_RECOM_RUNSTATS-STMASSDEL table field - RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) ▼

Description: RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
Field Name: STMASSDEL
Data Element: DB2CCSMASS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMASSDEL

DB2_RECOM_RUNSTATS-SIINSDELP table field - RUNSTATS TS/IX: Changed rows in percent ▼

Description: RUNSTATS TS/IX: Changed rows in percent
Field Name: SIINSDELP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIINSDELP

DB2_RECOM_RUNSTATS-SIINSDELA table field - RUN.:Changed rows (insert, delete or update) absolute number ▼

Description: RUN.:Changed rows (insert, delete or update) absolute number
Field Name: SIINSDELA
Data Element: DB2CCCHGA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIINSDELA

DB2_RECOM_RUNSTATS-SIMASSDEL table field - RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) ▼

Description: RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
Field Name: SIMASSDEL
Data Element: DB2CCSMASS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIMASSDEL

DB2_RECOM_RUNSTATS-REORGTIME table field - Timestamp of last REORG ▼

Description: Timestamp of last REORG
Field Name: REORGTIME
Data Element: DB2CCOTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REORGTIME

DB2_RECOM_RUNSTATS-LOADREPLTI table field - Timestamp of last LOAD REPLACE ▼

Description: Timestamp of last LOAD REPLACE
Field Name: LOADREPLTI
Data Element: DB2CCLTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADREPLTI

DB2_RECOM_RUNSTATS-REBUILDTIM table field - Timestamp of last REBUILD INDEX ▼

Description: Timestamp of last REBUILD INDEX
Field Name: REBUILDTIM
Data Element: DB2CCRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REBUILDTIM

DB2_RECOM_RUNSTATS-EXTENT_NO table field - Number of physical extents in TS, IS or partition ▼

Description: Number of physical extents in TS, IS or partition
Field Name: EXTENT_NO
Data Element: DB2CCEXTNO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENT_NO