SAP DB2_VIEW_BP_DET table - view data for BP Activity Details details in SAP


SAP DB2_VIEW_BP_DET table summary

Object Name: DB2_VIEW_BP_DET
Dictionary Type: Structure
Description: view data for BP Activity Details


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

Details
DB2_VIEW_BP_DET-QBST table field -

Description:
Field Name: QBST
Data Element: DB2QBST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBST

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DB2_VIEW_BP_DET-QDBP table field -

Description:
Field Name: QDBP
Data Element: DB2QDBP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBP

DB2_VIEW_BP_DET-QDBPNM table field - Name of buffer pool

Description: Name of buffer pool
Field Name: QDBPNM
Data Element: DB2DBPNM
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 QDBPNM

DB2_VIEW_BP_DET-QDBPVPSZ table field - The size of the virtual buffer pool

Description: The size of the virtual buffer pool
Field Name: QDBPVPSZ
Data Element: DB2DBPVPSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPVPSZ

DB2_VIEW_BP_DET-QDBPVPSH table field - The sequential steal threshold for the virtual buffer pool

Description: The sequential steal threshold for the virtual buffer pool
Field Name: QDBPVPSH
Data Element: DB2DBPVPSH
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 QDBPVPSH

DB2_VIEW_BP_DET-QDBPDWQT table field - The deferred write threshold for the virtual buffer pool

Description: The deferred write threshold for the virtual buffer pool
Field Name: QDBPDWQT
Data Element: DB2DBPDWQT
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 QDBPDWQT

DB2_VIEW_BP_DET-QDBPVDQT table field - The vertical deferred write threshold for the virtual BP

Description: The vertical deferred write threshold for the virtual BP
Field Name: QDBPVDQT
Data Element: DB2DBPVDQT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPVDQT

DB2_VIEW_BP_DET-QDBPPSQT table field - Parallel I/O sequential steal threshold for virtual BP

Description: Parallel I/O sequential steal threshold for virtual BP
Field Name: QDBPPSQT
Data Element: DB2DBPPSQT
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 QDBPPSQT

DB2_VIEW_BP_DET-QDBPXSQT table field - Assisting parallel sequential threshold

Description: Assisting parallel sequential threshold
Field Name: QDBPXSQT
Data Element: DB2DBPXSQT
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 QDBPXSQT

DB2_VIEW_BP_DET-QDBPVPTY table field - Type of virtual buffer pool

Description: Type of virtual buffer pool
Field Name: QDBPVPTY
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 QDBPVPTY

DB2_VIEW_BP_DET-QDBPVDQB table field - Pool vertical write threshold in number of buffers

Description: Pool vertical write threshold in number of buffers
Field Name: QDBPVDQB
Data Element: DB2DBPVDQB
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2INT2V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPVDQB

DB2_VIEW_BP_DET-QDBPPGST table field - Page stealing algorithm to be used for the virtual BP

Description: Page stealing algorithm to be used for the virtual BP
Field Name: QDBPPGST
Data Element: DB2DBPPGST
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR04
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPPGST

DB2_VIEW_BP_DET-QDBPPFIX table field - PGFIX attribute (BP long-term fixed in real storage)

Description: PGFIX attribute (BP long-term fixed in real storage)
Field Name: QDBPPFIX
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPPFIX

DB2_VIEW_BP_DET-QDBPFRAM table field - DB2 11 - FRAMESIZE

Description: DB2 11 - FRAMESIZE
Field Name: QDBPFRAM
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPFRAM

DB2_VIEW_BP_DET-QDBPVPMI table field - Field Type DEC, Length 10

Description: Field Type DEC, Length 10
Field Name: QDBPVPMI
Data Element: DB2DEC10
Data Type: DEC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DEC_10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPVPMI

DB2_VIEW_BP_DET-QDBPVPMA table field - Field Type DEC, Length 10

Description: Field Type DEC, Length 10
Field Name: QDBPVPMA
Data Element: DB2DEC10
Data Type: DEC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DEC_10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPVPMA

DB2_VIEW_BP_DET-QDBPASIZ table field - AUTOSIZE attribute

Description: AUTOSIZE attribute
Field Name: QDBPASIZ
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPASIZ


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table