SAP DB2_KPI_QBST table - bufferpool activity data details in SAP


SAP DB2_KPI_QBST table summary

Object Name: DB2_KPI_QBST
Dictionary Type: Structure
Description: bufferpool activity data


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

Details
DB2_KPI_QBST-MEMBER table field - DB2 member name in data sharing environment

Description: DB2 member name in data sharing environment
Field Name: MEMBER
Data Element: DB2MEMN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MEMBER

DB2_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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_KPI_QBST-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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table