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


SAP DB2CCDAILY table summary

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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