SAP DB2QDBPT1 table - DB2 for z/OS buffer pool settings details in SAP


SAP DB2QDBPT1 table summary

Object Name: DB2QDBPT1
Dictionary Type: Structure
Description: DB2 for z/OS buffer pool settings


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

Details
DB2QDBPT1-MEMBNM table field - DB2 member name in data sharing environment

Description: DB2 member name in data sharing environment
Field Name: MEMBNM
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 MEMBNM

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

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

DB2QDBPT1-QDBPHPSZ table field - The size of the hiperpool

Description: The size of the hiperpool
Field Name: QDBPHPSZ
Data Element: DB2DBPHPSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPHPSZ

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

DB2QDBPT1-QDBPHPSH table field - The sequential steal threshold for the hiperpool

Description: The sequential steal threshold for the hiperpool
Field Name: QDBPHPSH
Data Element: DB2DBPHPSH
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPHPSH

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

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

DB2QDBPT1-QDBPCAST table field - CASTOUT attribute

Description: CASTOUT attribute
Field Name: QDBPCAST
Data Element: DB2DBPCAST
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CHAR6
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QDBPCAST

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

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

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

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

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

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

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

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

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

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