SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

DB2BPTUNE Table in SAP | DB2/390: Buffer Pool Tuning Settings Table & Fields List

DB2BPTUNE is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2BPTUNE in SAP.

  • Table description : DB2/390: Buffer Pool Tuning Settings
  • Module : BC-DB-DB2
  • Parent Module : BC
  • Package : STU2
  • Software Component : SAP_BASIS
DB2BPTUNE table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP DB2BPTUNE Table Fields structure

FieldNoteData ElementDomain
CREATORCreator of BP tuning settings ( = SAP for default settings )DB2BPCUSTDB2CHAR12
CREATEDATESystem DateSYDATUMSYDATS
CREATETIMESystem TimeSYUZEITSYTIME
QDBPNMName of buffer poolDB2DBPNMCHAR8
CATEGORYDB2 for OS/390: Table categoryDB2TABCATDB2TABCAT
QDBPVPSZThe size of the virtual buffer poolDB2DBPVPSZ  
QDBPHPSZThe size of the hiperpoolDB2DBPHPSZ  
QDBPVPSHThe sequential steal threshold for the virtual buffer poolDB2DBPVPSHDB2INT4
QDBPHPSHThe sequential steal threshold for the hiperpoolDB2DBPHPSH  
QDBPDWQTThe deferred write threshold for the virtual buffer poolDB2DBPDWQTDB2INT4
QDBPVDQTThe vertical deferred write threshold for the virtual BPDB2DBPVDQT  
QDBPCASTCASTOUT attributeDB2DBPCASTCHAR6
QDBPPSQTParallel I/O sequential steal threshold for virtual BPDB2DBPPSQTDB2INT4
QDBPXSQTAssisting parallel sequential thresholdDB2DBPXSQTDB2INT4
QDBPRES1Field type char, length 1, reservedDB2RES01DB2CHAR01
TABCATDESTable category descriptionDB2TCATDESDB2CHAR44
VPTYPE   

DB2BPTUNE related tables

TableNote
DB2BPTUNEDB2/390: Buffer Pool Tuning Settings
STU3COTABCDefinition of DB2 OS/390 and OS/390 Commands(Customer Table)
STU3COTABSDefinition of DB2 for OS/390 and OS/390 Commands (SAP Table)
DB2UTPARMDB2/390: Parameters for DB2 Utilities
DB2MONDB2/390 Monitor Table
DB2PROCStored procedures for DB2/390
DB2TSSIZE_TDB2/390: Storage Information on R/3 Tablespaces
DBCHECKDB2Configuration of DB2/390 System Check Parameters
DBMSGDB2DB2/390 System Check Messages
DBSTAIHDB2DB2/390 Statistics for Indexes
DBSTATHDB2DB2/390 Statistics for Tables (History)
DBSTATIDB2DB2/390 Statistics for Indexes
DBSTATTDB2DB2/390 Statistics for Tables
DBSYCHKDB2DB2/390: Global Information for Database System Check
DD02DB2DB2/390: Table Parameters
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com