SAP DB2STATDEC table - DB2/390: Buffer Pool Tuning: Table Categorisation details in SAP


SAP DB2STATDEC table summary

Object Name: DB2STATDEC
Dictionary Type: Structure
Description: DB2/390: Buffer Pool Tuning: Table Categorisation


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

Details
DB2STATDEC-TNAME table field - DB2 table name

Description: DB2 table name
Field Name: TNAME
Data Element: DB2TABNAME
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 TNAME

DB2STATDEC-RNAME table field - Name of the pool or cluster

Description: Name of the pool or cluster
Field Name: RNAME
Data Element: DBSTATSQLT
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RNAME

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

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

DB2STATDEC-UPDCNT table field - No. of UPDATE commands

Description: No. of UPDATE commands
Field Name: UPDCNT
Data Element: UPDCNTD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPDCNT

DB2STATDEC-DELCNT table field - No. of DELETE attempts

Description: No. of DELETE attempts
Field Name: DELCNT
Data Element: DELCNTD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELCNT

DB2STATDEC-INSCNT table field - No. of INSERT attempts

Description: No. of INSERT attempts
Field Name: INSCNT
Data Element: INSCNTD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSCNT

DB2STATDEC-FETCHES table field - DB2 for OS/390: Number of fetches

Description: DB2 for OS/390: Number of fetches
Field Name: FETCHES
Data Element: DB2FETCHES
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FETCHES

DB2STATDEC-DIR_FETCH table field - Number of FETCHes for direct read commands (SELECT SINGLE)

Description: Number of FETCHes for direct read commands (SELECT SINGLE)
Field Name: DIR_FETCH
Data Element: DIRFETCHD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIR_FETCH

DB2STATDEC-SEQ_FETCH table field - Number of FETCHes for sequential read commands

Description: Number of FETCHes for sequential read commands
Field Name: SEQ_FETCH
Data Element: SEQFETCHD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEQ_FETCH

DB2STATDEC-SEQ_ROW table field - Number of records read at sequential read operations

Description: Number of records read at sequential read operations
Field Name: SEQ_ROW
Data Element: SEQROWD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEQ_ROW

DB2STATDEC-BUF table field - Field type char, length 1

Description: Field type char, length 1
Field Name: BUF
Data Element: DB2CHAR01
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR01
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUF

DB2STATDEC-NPAGES table field - Number of pages on which rows of the table appear

Description: Number of pages on which rows of the table appear
Field Name: NPAGES
Data Element: DB2NPAGESD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NPAGES

DB2STATDEC-BPOOL table field - Name of the DB2 buffer pool currently used for the TS

Description: Name of the DB2 buffer pool currently used for the TS
Field Name: BPOOL
Data Element: DB2BPCURR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPOOL

DB2STATDEC-BPSUG table field - Suggested DB2 buffer pool

Description: Suggested DB2 buffer pool
Field Name: BPSUG
Data Element: DB2BPSUG
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPSUG

DB2STATDEC-RECLENGTH table field - Maximum length (in bytes) of any record in the table

Description: Maximum length (in bytes) of any record in the table
Field Name: RECLENGTH
Data Element: DB2RECLEN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECLENGTH

DB2STATDEC-EXECUTES table field - Sum of execution of updates, inserts, deletes and fetches

Description: Sum of execution of updates, inserts, deletes and fetches
Field Name: EXECUTES
Data Element: DB2EXECS
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECUTES

DB2STATDEC-ACCESS_FR table field - DB2 OS/390: Access frequency: max(executes , affected rows)

Description: DB2 OS/390: Access frequency: max(executes , affected rows)
Field Name: ACCESS_FR
Data Element: DB2ACCFREQ
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCESS_FR

DB2STATDEC-ACCESS_TY table field - DB2 for OS/390: Access type: random or sequential

Description: DB2 for OS/390: Access type: random or sequential
Field Name: ACCESS_TY
Data Element: DB2ACCTYPE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10L
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCESS_TY

DB2STATDEC-PERC_CHAN table field - DB2/390: changes vs. all executions in percent

Description: DB2/390: changes vs. all executions in percent
Field Name: PERC_CHAN
Data Element: DB2CHANGES
Data Type: NUMC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERC_CHAN

DB2STATDEC-SIZE table field - DB2 for OS/390: Size category of the table (small, large)

Description: DB2 for OS/390: Size category of the table (small, large)
Field Name: SIZE
Data Element: DB2SIZE
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR06L
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE

DB2STATDEC-CATEGORY table field - DB2 for OS/390: Table category

Description: DB2 for OS/390: Table category
Field Name: CATEGORY
Data Element: DB2TABCAT
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: DB2TABCAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CATEGORY

DB2STATDEC-SIZE_KB table field - DB2 for OS/390: Table size ( pages * reclength / 1024 )

Description: DB2 for OS/390: Table size ( pages * reclength / 1024 )
Field Name: SIZE_KB
Data Element: DB2TABSIZE
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DEC12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE_KB

DB2STATDEC-CARDF table field - Total number of rows in the table

Description: Total number of rows in the table
Field Name: CARDF
Data Element: DB2CARDFD
Data Type: DEC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CARDF


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table