SAP DB2BPTUNE table - DB2/390: Buffer Pool Tuning Settings details in SAP


SAP DB2BPTUNE table summary

Object Name: DB2BPTUNE
Dictionary Type: Transparent table
Description: DB2/390: Buffer Pool Tuning Settings


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

Details
DB2BPTUNE-CREATOR table field - Creator of BP tuning settings ( = SAP for default settings )

Description: Creator of BP tuning settings ( = SAP for default settings )
Field Name: CREATOR
Data Element: DB2BPCUST
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATOR

DB2BPTUNE-CREATEDATE table field - System Date

Description: System Date
Field Name: CREATEDATE
Data Element: SYDATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYDATS
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATEDATE

DB2BPTUNE-CREATETIME table field - System Time

Description: System Time
Field Name: CREATETIME
Data Element: SYUZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: SYTIME
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATETIME

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

DB2BPTUNE-CATEGORY table field - DB2 for OS/390: Table category

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

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

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

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

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

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

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

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

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

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

DB2BPTUNE-QDBPRES1 table field - Field type char, length 1, reserved

Description: Field type char, length 1, reserved
Field Name: QDBPRES1
Data Element: DB2RES01
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 QDBPRES1

DB2BPTUNE-TABCATDES table field - Table category description

Description: Table category description
Field Name: TABCATDES
Data Element: DB2TCATDES
Data Type: CHAR
length (Dec): 44(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR44
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABCATDES

DB2BPTUNE-VPTYPE table field - Location of buffer pool: primary (DBM1) or data space

Description: Location of buffer pool: primary (DBM1) or data space
Field Name: VPTYPE
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 VPTYPE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table