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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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