SAP DB2CCOUT table - Output List of Table-/Indexspace of DB2 SP DSNACCOR details in SAP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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