SAP DB2QBST table - Buffer Manager Statistics Block details in SAP


SAP DB2QBST table summary

Object Name: DB2QBST
Dictionary Type: Structure
Description: Buffer Manager Statistics Block


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

Details
DB2QBST-QBSTPID table field - Field type numc, length 10, integer

Description: Field type numc, length 10, integer
Field Name: QBSTPID
Data Element: DB2NUMC10
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPID

DB2QBST-QBSTGET table field - Number of get page requests (conditional and unconditional)

Description: Number of get page requests (conditional and unconditional)
Field Name: QBSTGET
Data Element: DB2BSTGET
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTGET

DB2QBST-QBSTRIO table field - Number of synchronous read I/O operations

Description: Number of synchronous read I/O operations
Field Name: QBSTRIO
Data Element: DB2BSTRIO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTRIO

DB2QBST-QBSTDWV table field - Number of times vertical deferred write threshold is reached

Description: Number of times vertical deferred write threshold is reached
Field Name: QBSTDWV
Data Element: DB2BSTDWV
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDWV

DB2QBST-QBSTXFL table field - Number of times the virtual buffer pool was full

Description: Number of times the virtual buffer pool was full
Field Name: QBSTXFL
Data Element: DB2BSTXFL
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTXFL

DB2QBST-QBSTXFV table field - Total number of virtual buffer pool or hiperpool failures

Description: Total number of virtual buffer pool or hiperpool failures
Field Name: QBSTXFV
Data Element: DB2BSTXFV
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTXFV

DB2QBST-QBSTSWS table field - Update intents against pages in the buffer pool

Description: Update intents against pages in the buffer pool
Field Name: QBSTSWS
Data Element: DB2BSTSWS
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSWS

DB2QBST-QBSTPWS table field - Number of pages written

Description: Number of pages written
Field Name: QBSTPWS
Data Element: DB2BSTPWS
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPWS

DB2QBST-QBSTWIO table field - Number of asynchronous writes

Description: Number of asynchronous writes
Field Name: QBSTWIO
Data Element: DB2BSTWIO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWIO

DB2QBST-QBSTCBA table field - Number of currently active (non-stealable) buffers

Description: Number of currently active (non-stealable) buffers
Field Name: QBSTCBA
Data Element: DB2BSTCBA
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTCBA

DB2QBST-QBSTRPI table field - Number of page inserts required for read I/O

Description: Number of page inserts required for read I/O
Field Name: QBSTRPI
Data Element: DB2BSTRPI
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTRPI

DB2QBST-QBSTWPI table field - Number of page inserts required for write I/O

Description: Number of page inserts required for write I/O
Field Name: QBSTWPI
Data Element: DB2BSTWPI
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWPI

DB2QBST-QBSTDSO table field - Number of datasets successfully opened physically

Description: Number of datasets successfully opened physically
Field Name: QBSTDSO
Data Element: DB2BSTDSO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDSO

DB2QBST-QBSTIMW table field - Number of immediate writes

Description: Number of immediate writes
Field Name: QBSTIMW
Data Element: DB2BSTIMW
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTIMW

DB2QBST-QBSTSEQ table field - Number of sequential prefetch requests

Description: Number of sequential prefetch requests
Field Name: QBSTSEQ
Data Element: DB2BSTSEQ
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSEQ

DB2QBST-QBSTSPP table field - Number of pages read because of normal sequential prefetch

Description: Number of pages read because of normal sequential prefetch
Field Name: QBSTSPP
Data Element: DB2BSTSPP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSPP

DB2QBST-QBSTSPD table field - Sequential prefetch disabled - no buffers available

Description: Sequential prefetch disabled - no buffers available
Field Name: QBSTSPD
Data Element: DB2BSTSPD
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSPD

DB2QBST-QBSTREE table field - Sequential prefetch disabled - unavailable read engine

Description: Sequential prefetch disabled - unavailable read engine
Field Name: QBSTREE
Data Element: DB2BSTREE
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTREE

DB2QBST-QBSTWEE table field - A write engine is unavailable for asynchronous write I/O

Description: A write engine is unavailable for asynchronous write I/O
Field Name: QBSTWEE
Data Element: DB2BSTWEE
Data Type: DEC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC10V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWEE

DB2QBST-QBSTDWT table field - Number of times the deferred write threshold was reached

Description: Number of times the deferred write threshold was reached
Field Name: QBSTDWT
Data Element: DB2BSTDWT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDWT

DB2QBST-QBSTDMC table field - Number of times the data manager threshold was reached

Description: Number of times the data manager threshold was reached
Field Name: QBSTDMC
Data Element: DB2BSTDMC
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDMC

DB2QBST-QBSTMIG table field - Number of times migrated datasets were encountered

Description: Number of times migrated datasets were encountered
Field Name: QBSTMIG
Data Element: DB2BSTMIG
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTMIG

DB2QBST-QBSTRTO table field - Number of recall timeouts

Description: Number of recall timeouts
Field Name: QBSTRTO
Data Element: DB2BSTRTO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTRTO

DB2QBST-QBSTPIO table field - Number of sequential prefetch reads

Description: Number of sequential prefetch reads
Field Name: QBSTPIO
Data Element: DB2BSTPIO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPIO

DB2QBST-QBSTWKPD table field - Number of work prefetches not scheduled due to zero prefetch

Description: Number of work prefetches not scheduled due to zero prefetch
Field Name: QBSTWKPD
Data Element: DB2BSTWKPD
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWKPD

DB2QBST-QBSTMAX table field - Number of times a work file could not be opened

Description: Number of times a work file could not be opened
Field Name: QBSTMAX
Data Element: DB2BSTMAX
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTMAX

DB2QBST-QBSTWFM table field - Maximum number of work files concurrently used

Description: Maximum number of work files concurrently used
Field Name: QBSTWFM
Data Element: DB2BSTWFM
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWFM

DB2QBST-QBSTWDRP table field - Number of pages for which destructive read was requested

Description: Number of pages for which destructive read was requested
Field Name: QBSTWDRP
Data Element: DB2BSTWDRP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWDRP

DB2QBST-QBSTWBVQ table field - Number of Pages Removed from the DWQ for Destructive Read

Description: Number of Pages Removed from the DWQ for Destructive Read
Field Name: QBSTWBVQ
Data Element: DB2BSTWBVQ
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWBVQ

DB2QBST-QBSTWFR table field - Number of merge passes requested for DB2 sort activities

Description: Number of merge passes requested for DB2 sort activities
Field Name: QBSTWFR
Data Element: DB2BSTWFR
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWFR

DB2QBST-QBSTWFT table field - Number of merge passes requested for DB2 sort activities

Description: Number of merge passes requested for DB2 sort activities
Field Name: QBSTWFT
Data Element: DB2BSTWFT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWFT

DB2QBST-QBSTWFD table field - Work file requests were rejected due to buffer pool shortage

Description: Work file requests were rejected due to buffer pool shortage
Field Name: QBSTWFD
Data Element: DB2BSTWFD
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWFD

DB2QBST-QBSTWFF table field - Number of times a merge pass could not be performed

Description: Number of times a merge pass could not be performed
Field Name: QBSTWFF
Data Element: DB2BSTWFF
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTWFF

DB2QBST-QBSTLPF table field - Number of list prefetch requests

Description: Number of list prefetch requests
Field Name: QBSTLPF
Data Element: DB2BSTLPF
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTLPF

DB2QBST-QBSTDPF table field - Number of dynamic prefetch requests

Description: Number of dynamic prefetch requests
Field Name: QBSTDPF
Data Element: DB2BSTDPF
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDPF

DB2QBST-QBSTVPA table field - Number of successful virtual buffer pool expans./contract.

Description: Number of successful virtual buffer pool expans./contract.
Field Name: QBSTVPA
Data Element: DB2BSTVPA
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTVPA

DB2QBST-QBSTVPL table field - Number of buffers allocated for virtual buffer pool

Description: Number of buffers allocated for virtual buffer pool
Field Name: QBSTVPL
Data Element: DB2BSTVPL
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTVPL

DB2QBST-QBSTDPP table field - Number of pages read via dynamic prefetch read I/O

Description: Number of pages read via dynamic prefetch read I/O
Field Name: QBSTDPP
Data Element: DB2BSTDPP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDPP

DB2QBST-QBSTLPP table field - Number of pages read via list prefetch

Description: Number of pages read via list prefetch
Field Name: QBSTLPP
Data Element: DB2BSTLPP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTLPP

DB2QBST-QBSTDIO table field - Number of dynamic prefetch reads

Description: Number of dynamic prefetch reads
Field Name: QBSTDIO
Data Element: DB2BSTDIO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTDIO

DB2QBST-QBSTLIO table field - Number of list prefetch reads

Description: Number of list prefetch reads
Field Name: QBSTLIO
Data Element: DB2BSTLIO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTLIO

DB2QBST-QBSTSGT table field - Number of get page requests issued by sequential access req.

Description: Number of get page requests issued by sequential access req.
Field Name: QBSTSGT
Data Element: DB2BSTSGT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSGT

DB2QBST-QBSTSIO table field - Synchronous read requests issued by sequential access req.

Description: Synchronous read requests issued by sequential access req.
Field Name: QBSTSIO
Data Element: DB2BSTSIO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSIO

DB2QBST-QBSTNGT table field - # of unsuccessful GETPAGE due conditional GETPAGE request

Description: # of unsuccessful GETPAGE due conditional GETPAGE request
Field Name: QBSTNGT
Data Element: DB2BSTNGT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTNGT

DB2QBST-QBSTXIS table field - Highest number of concurrent prefetch I/O streams

Description: Highest number of concurrent prefetch I/O streams
Field Name: QBSTXIS
Data Element: DB2BSTXIS
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTXIS

DB2QBST-QBSTJIS table field - Total number of denied concurrent prefetch I/O streams

Description: Total number of denied concurrent prefetch I/O streams
Field Name: QBSTJIS
Data Element: DB2BSTJIS
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTJIS

DB2QBST-QBSTPQO table field - Total no. of requests for parallel query support

Description: Total no. of requests for parallel query support
Field Name: QBSTPQO
Data Element: DB2BSTPQO
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPQO

DB2QBST-QBSTPQF table field - The parallel query went into reduced or degenerated mode

Description: The parallel query went into reduced or degenerated mode
Field Name: QBSTPQF
Data Element: DB2BSTPQF
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPQF

DB2QBST-QBSTPL1 table field - Prefetch quantity is reduced from normal to 50%

Description: Prefetch quantity is reduced from normal to 50%
Field Name: QBSTPL1
Data Element: DB2BSTPL1
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPL1

DB2QBST-QBSTPL2 table field - Number of occurrences of prefetch quantity reduced 1/4

Description: Number of occurrences of prefetch quantity reduced 1/4
Field Name: QBSTPL2
Data Element: DB2BSTPL2
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTPL2

DB2QBST-QBSTHITR table field - Buffer hit ratio

Description: Buffer hit ratio
Field Name: QBSTHITR
Data Element: DB2BSTHITR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTHITR

DB2QBST-QBSTBPNM table field - DB2 buffer pool name

Description: DB2 buffer pool name
Field Name: QBSTBPNM
Data Element: DB2BSTBPNM
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 QBSTBPNM

DB2QBST-MARK table field - Single-Character Flag

Description: Single-Character Flag
Field Name: MARK
Data Element: CHAR1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MARK

DB2QBST-RANDHITR table field - Random hit ratio

Description: Random hit ratio
Field Name: RANDHITR
Data Element: DB2RNDHITR
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DB2DECPCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RANDHITR

DB2QBST-READRATE table field - Read rate per second

Description: Read rate per second
Field Name: READRATE
Data Element: DB2READRAT
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READRATE

DB2QBST-UPPPWRIT table field - Buffer update per pages written

Description: Buffer update per pages written
Field Name: UPPPWRIT
Data Element: DB2UPPPWRI
Data Type: DEC
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPPPWRIT

DB2QBST-PWPWIO table field - Pages written per write I/O

Description: Pages written per write I/O
Field Name: PWPWIO
Data Element: DB2PWPWIO
Data Type: DEC
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PWPWIO

DB2QBST-WRITERATE table field - Write rate = ( Synchronous + async. writes ) / interval

Description: Write rate = ( Synchronous + async. writes ) / interval
Field Name: WRITERATE
Data Element: DB2WRITRAT
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WRITERATE

DB2QBST-BPTYPE table field - Type of virtual buffer pool

Description: Type of virtual buffer pool
Field Name: BPTYPE
Data Element: DB2DBPVPTY
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 BPTYPE

DB2QBST-CURRINUSE table field - Percentage of buffers currently in use

Description: Percentage of buffers currently in use
Field Name: CURRINUSE
Data Element: DB2BINUSE
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DB2DECPCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRINUSE

DB2QBST-VPSHORT table field - Number of Virtual Pool Shortages

Description: Number of Virtual Pool Shortages
Field Name: VPSHORT
Data Element: DB2VPSHORT
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VPSHORT

DB2QBST-PREFDIS table field - Number of Times Sequential Prefetch Was Disabled

Description: Number of Times Sequential Prefetch Was Disabled
Field Name: PREFDIS
Data Element: DB2PREFDIS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREFDIS

DB2QBST-PAGEIN table field - Number of page-ins

Description: Number of page-ins
Field Name: PAGEIN
Data Element: DB2PAGEIN
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEIN

DB2QBST-GETPRAND table field - Number of Random Access Getpage Requests

Description: Number of Random Access Getpage Requests
Field Name: GETPRAND
Data Element: DB2GETPRND
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GETPRAND

DB2QBST-GETPRATE table field - Number of Getpage Requests per Second

Description: Number of Getpage Requests per Second
Field Name: GETPRATE
Data Element: DB2GETPRAT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GETPRATE

DB2QBST-SYNRRAND table field - Number of Random Access Synchronous Reads

Description: Number of Random Access Synchronous Reads
Field Name: SYNRRAND
Data Element: DB2SYNRRND
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYNRRAND

DB2QBST-PG_SEQPREF table field - Number of Pages Read per Sequential Prefetch Read

Description: Number of Pages Read per Sequential Prefetch Read
Field Name: PG_SEQPREF
Data Element: DB2PGPSEQP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PG_SEQPREF

DB2QBST-PG_LISPREF table field - Number of Pages Read per List Prefetch Read

Description: Number of Pages Read per List Prefetch Read
Field Name: PG_LISPREF
Data Element: DB2PGPLISP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PG_LISPREF

DB2QBST-PG_DYNPREF table field - Number of Pages Read per Dynamic Prefetch Read

Description: Number of Pages Read per Dynamic Prefetch Read
Field Name: PG_DYNPREF
Data Element: DB2PGPDYNP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PG_DYNPREF

DB2QBST-BUPDRATE table field - Buffer Update Rate

Description: Buffer Update Rate
Field Name: BUPDRATE
Data Element: DB2BUPDRAT
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUPDRATE

DB2QBST-WF_MERGE table field - Average Work Files per Merge Pass

Description: Average Work Files per Merge Pass
Field Name: WF_MERGE
Data Element: DB2WFPMRGP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WF_MERGE

DB2QBST-WFN_DEGMP table field - Average Work Files Not Given per Degraded Merge Pass

Description: Average Work Files Not Given per Degraded Merge Pass
Field Name: WFN_DEGMP
Data Element: DB2WFNPDMP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WFN_DEGMP

DB2QBST-QBSTLPL table field - Number of times one or more pages were added to LPL

Description: Number of times one or more pages were added to LPL
Field Name: QBSTLPL
Data Element: DB2BSTLPL
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTLPL

DB2QBST-SIOPERSGT table field - Sync. seq. reads / seq. getpages

Description: Sync. seq. reads / seq. getpages
Field Name: SIOPERSGT
Data Element: DB2SIOSGT
Data Type: DEC
length (Dec): 19(6)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIOPERSGT

DB2QBST-SWRTRATE table field - Sync writes / ( sync writes + async writes)

Description: Sync writes / ( sync writes + async writes)
Field Name: SWRTRATE
Data Element: DB2SWRTRATE
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DB2DECPCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SWRTRATE

DB2QBST-QBSTSMIN table field - dec 19 with sign

Description: dec 19 with sign
Field Name: QBSTSMIN
Data Element: DB2DEC19V
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSMIN

DB2QBST-QBSTSMAX table field - dec 19 with sign

Description: dec 19 with sign
Field Name: QBSTSMAX
Data Element: DB2DEC19V
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTSMAX

DB2QBST-QBSTHST table field - dec 19 with sign

Description: dec 19 with sign
Field Name: QBSTHST
Data Element: DB2DEC19V
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTHST

DB2QBST-QBSTRHS table field - dec 19 with sign

Description: dec 19 with sign
Field Name: QBSTRHS
Data Element: DB2DEC19V
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTRHS

DB2QBST-QBSTNSG table field - dec 19 with sign

Description: dec 19 with sign
Field Name: QBSTNSG
Data Element: DB2DEC19V
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBSTNSG


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table