SAP DB2CCRUNSTATS table - DB2CCRUNST without keys details in SAP


SAP DB2CCRUNSTATS table summary

Object Name: DB2CCRUNSTATS
Dictionary Type: Structure
Description: DB2CCRUNST without keys


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

Details
DB2CCRUNSTATS-DATE_ANA table field - Date of the last check

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

See all SAP tables containing field DATE_ANA

DB2CCRUNSTATS-TIME_ANA table field - Time of the last check

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

See all SAP tables containing field TIME_ANA

DB2CCRUNSTATS-DBNAME table field - Database name

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

See all SAP tables containing field DBNAME

DB2CCRUNSTATS-TSNAME table field - Name of the tablespace

Description: Name of the tablespace
Field Name: TSNAME
Data Element: DB2TSNAME
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 TSNAME

DB2CCRUNSTATS-PARTI table field - Partition number

Description: Partition number
Field Name: PARTI
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 PARTI

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

DB2CCRUNSTATS-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: 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 IXNAME

DB2CCRUNSTATS-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: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJTYPE

DB2CCRUNSTATS-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: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: CHAR36
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJSTATUS

DB2CCRUNSTATS-RUNSTREC table field - RUNSTATS Recommendation: YES or NO

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

See all SAP tables containing field RUNSTREC

DB2CCRUNSTATS-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: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCTABLE

DB2CCRUNSTATS-ASSOCTS table field - Associated tablespace for indexspace

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

See all SAP tables containing field ASSOCTS

DB2CCRUNSTATS-RUNSTATSTI table field - Timestamp of last RUNSTATS

Description: Timestamp of last RUNSTATS
Field Name: RUNSTATSTI
Data Element: DB2CCSTIME
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 RUNSTATSTI

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

DB2CCRUNSTATS-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: 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 STINSDELA

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

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

DB2CCRUNSTATS-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: 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 SIINSDELA

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

DB2CCRUNSTATS-REORGTIME table field - Timestamp of last REORG

Description: Timestamp of last REORG
Field Name: REORGTIME
Data Element: DB2CCOTIME
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 REORGTIME

DB2CCRUNSTATS-LOADREPLTI table field - Timestamp of last LOAD REPLACE

Description: Timestamp of last LOAD REPLACE
Field Name: LOADREPLTI
Data Element: DB2CCLTIME
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 LOADREPLTI

DB2CCRUNSTATS-REBUILDTIM table field - Timestamp of last REBUILD INDEX

Description: Timestamp of last REBUILD INDEX
Field Name: REBUILDTIM
Data Element: DB2CCRTIME
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 REBUILDTIM

DB2CCRUNSTATS-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: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENT_NO


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table