SAP DB2CCHOUR table - List of TS/IXS needing utility treatment (DSNACCOR Hourly) details in SAP


SAP DB2CCHOUR table summary

Object Name: DB2CCHOUR
Dictionary Type: Transparent table
Description: List of TS/IXS needing utility treatment (DSNACCOR Hourly)


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

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

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

DB2CCHOUR-DBNAM table field - Database name

Description: Database name
Field Name: DBNAM
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 DBNAM

DB2CCHOUR-TSNAM table field - Name of the tablespace

Description: Name of the tablespace
Field Name: TSNAM
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 TSNAM

DB2CCHOUR-TSPART table field - Partition number

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

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

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

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

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

DB2CCHOUR-PARTI table field - Data set number or partition number

Description: Data set number or partition number
Field Name: PARTI
Data Element: DB2CCPART
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PART
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTI

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

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

DB2CCHOUR-COPYREC table field - COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)

Description: COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)
Field Name: COPYREC
Data Element: DB2CCCPYR
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 COPYREC

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

DB2CCHOUR-EXTENTS table field - Extentlimit was exceeded: YES or NO

Description: Extentlimit was exceeded: YES or NO
Field Name: EXTENTS
Data Element: DB2CCEXTL
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 EXTENTS

DB2CCHOUR-REORGREC table field - REORG Recommendation: YES or NO

Description: REORG Recommendation: YES or NO
Field Name: REORGREC
Data Element: DB2CCOREC
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 REORGREC

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

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

DB2CCHOUR-COPYTIME table field - Timestamp of last full image COPY

Description: Timestamp of last full image COPY
Field Name: COPYTIME
Data Element: DB2CCCTIME
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 COPYTIME

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

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

DB2CCHOUR-FCUPDPGS table field - Full/Inc. Copy: Updated pages in percent of preformatted pag

Description: Full/Inc. Copy: Updated pages in percent of preformatted pag
Field Name: FCUPDPGS
Data Element: DB2CCUPDPG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FCUPDPGS

DB2CCHOUR-FCCHGPCT table field - Full/Inc. Copy: Changed rows in percent

Description: Full/Inc. Copy: Changed rows in percent
Field Name: FCCHGPCT
Data Element: DB2CCCCHGS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FCCHGPCT

DB2CCHOUR-FCDAYSCOPY table field - Full Copy: Number of days since last COPY

Description: Full Copy: Number of days since last COPY
Field Name: FCDAYSCOPY
Data Element: DB2CCCDAYS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FCDAYSCOPY

DB2CCHOUR-FCINDEXSIZ table field - Full Copy: Minimum size of index in pages (NACTIVE)

Description: Full Copy: Minimum size of index in pages (NACTIVE)
Field Name: FCINDEXSIZ
Data Element: DB2CCISIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FCINDEXSIZ

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

DB2CCHOUR-RTINSDELUP table field - REORG TS/IX: Changed rows in percent

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

See all SAP tables containing field RTINSDELUP

DB2CCHOUR-RTUNCLUST table field - REORG TS: Unclustered inserts in percent

Description: REORG TS: Unclustered inserts in percent
Field Name: RTUNCLUST
Data Element: DB2CCUNCLU
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTUNCLUST

DB2CCHOUR-RTLOBPCT table field - REORG TS: Disorganized LOBs in percent

Description: REORG TS: Disorganized LOBs in percent
Field Name: RTLOBPCT
Data Element: DB2CCLOB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTLOBPCT

DB2CCHOUR-RTMASSDEL table field - REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)

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

See all SAP tables containing field RTMASSDEL

DB2CCHOUR-RTINDREF table field - REORG TS: Indirect references (overflow records) in percent

Description: REORG TS: Indirect references (overflow records) in percent
Field Name: RTINDREF
Data Element: DB2CCIND
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTINDREF

DB2CCHOUR-RIINSDEL table field - REORG TS/IX: Changed rows in percent

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

See all SAP tables containing field RIINSDEL

DB2CCHOUR-RIAPPINS table field - REORG Index: Appended rows (with greater key) in percent

Description: REORG Index: Appended rows (with greater key) in percent
Field Name: RIAPPINS
Data Element: DB2CCAPP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RIAPPINS

DB2CCHOUR-RIPSEUDODE table field - REORG Index: Pseudo deletes in percent

Description: REORG Index: Pseudo deletes in percent
Field Name: RIPSEUDODE
Data Element: DB2CCPSEUD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RIPSEUDODE

DB2CCHOUR-RIMASSDEL table field - REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)

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

See all SAP tables containing field RIMASSDEL

DB2CCHOUR-RILEAFLIM table field - REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent

Description: REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent
Field Name: RILEAFLIM
Data Element: DB2CCLEAF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RILEAFLIM

DB2CCHOUR-RINUMLEVEL table field - REORG Index: Change to number of index tree levels absolute

Description: REORG Index: Change to number of index tree levels absolute
Field Name: RINUMLEVEL
Data Element: DB2CCLEVEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RINUMLEVEL

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

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

Description: RUNSTATS TS/IX: Changed rows in percent
Field Name: STINSDELP
Data Element: DB2CCSCHGS
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

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

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

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

Description: RUNSTATS TS/IX: Changed rows in percent
Field Name: SIINSDELP
Data Element: DB2CCSCHGS
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

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

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

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

DB2CCHOUR-RTINSDELUPABS table field - REO.:Changed rows (insert, delete or update) absolute number

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

See all SAP tables containing field RTINSDELUPABS

DB2CCHOUR-RTACTIVEPAGES table field - REORG TS/IX: Number of active pages

Description: REORG TS/IX: Number of active pages
Field Name: RTACTIVEPAGES
Data Element: DB2CCRROWS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTACTIVEPAGES


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table