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


SAP DB2CCOUT table summary

Object Name: DB2CCOUT
Dictionary Type: Structure
Description: Output List of Table-/Indexspace of DB2 SP DSNACCOR


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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