IBM WEBSPHERE 6.1.X - Manual (Page 47)

4 2
W E B S P H E R E P O R T A L V 6 . 1 T U N I N G G U I D E
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.
D B 2 F O R Z / O S V 8 F I X E S
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)
A D D I T I O N A L R E S O U R C E S F O R D B 2 Z / O S
•
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