Filter
Top Products
42
WEBSPHERE PORTAL V6.1 TUNING GUIDE
to BP0. In DB2 9 for z/OS, ZPARM’s can be set to specifiy default bufferpools. In our
environment we used the following values.
Table 24: DB2 z/OS Default Bufferpool Settings
Default Bufferpool Settings
ZPARM Value Used BP Size
Description
TBSBPLOB
BP16K0
10000
Specifies the default buffer pool to use for LOB table spaces that
are created implicitly and for LOB table spaces that are created
explicitly without the BUFFERPOOL clause.
TBSBPOOL
BP4
80000
Specifies the default buffer pool to use for 4-KB page size table
spaces that are created implicitly and for 4-KB page size table
spaces that are created explicitly without the BUFFERPOOL
clause.
TBSBP8K
BP8K0
35000
Specifies the default buffer pool to use for 8-KB page size table
spaces that are created implicitly and for 8-KB page size table
spaces that are created explicitly without the BUFFERPOOL
clause.
TBSBP16K
BP16K0
10000
Specifies the default buffer pool to use for 16-KB page size table
spaces that are created implicitly and for 16-KB page size table
spaces that are created explicitly without the BUFFERPOOL
clause.
TBSBP32K
BP32K
1000
Specifies the default buffer pool to use for 32-KB page size table
spaces that are created implicitly and for 32-KB page size table
spaces that are created explicitly without the BUFFERPOOL
clause.
IDXBPOOL BP5 40000
DB2 uses the IDXBPOOL value if you do not specify a value for
INDEXBP on the CREATE DATABASE statement. DB2 does not
use this value for a CREATE INDEX statement without the
BUFFERPOOL option. In that case, DB2 uses the default index
buffer pool for the database.
DB2 FOR Z/O S V8 FIXES
The following fixes are required for running WCM on WPS 610x on DB2 for z/OS v8.
• PK62728 - DB2 improves the performance of selected queries (UK36555)
• PK67292 - DB2 was fixed to transform the subquery into a join (UK37970)
• PK68259 - Addresses CORRELATED SUBQUERY TO JOIN TRANSFORMATION
ENHANCEMENT FOR MULTI-TABLE JOINS IN ANY QUERY BLOCK (UK37971)
ADDIT ION AL RESOUR CES FOR DB2 Z/OS
•
WCM/JCR database table usage information for WebSphere Portal v6
http://www-01.ibm.com/support/docview.wss?uid=swg21255445
•
Performance Improvement Possible For Remote TCP Access to z/OS
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/FLASH10621
•
DB2 9 for z/OS Performance Topics
http://www.redbooks.ibm.com/redbooks/pdfs/sg247473.pdf