IBM 6.1.X manual Tbsbplob, Tbsbpool, Idxbpool, D B 2 F O R Z / O S V 8 F I X E S

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.
			Specifies the default buffer pool to use for 4-KB page size table
TBSBPOOL	BP4	80000	spaces that are created implicitly and for 4-KB page size table
			spaces that are created explicitly without the BUFFERPOOL
			clause.
			Specifies the default buffer pool to use for 8-KB page size table
TBSBP8K	BP8K0	35000	spaces that are created implicitly and for 8-KB page size table
			spaces that are created explicitly without the BUFFERPOOL
			clause.
			Specifies the default buffer pool to use for 16-KB page size table
TBSBP16K	BP16K0	10000	spaces that are created implicitly and for 16-KB page size table
			spaces that are created explicitly without the BUFFERPOOL
			clause.
			Specifies the default buffer pool to use for 32-KB page size table
TBSBP32K	BP32K	1000	spaces that are created implicitly and for 32-KB page size table
			spaces that are created explicitly without the BUFFERPOOL
			clause.
			DB2 uses the IDXBPOOL value if you do not specify a value for
IDXBPOOL	BP5	40000	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

4 2

W E BS P HE R E P O R T AL V 6 . 1 T U N I N G G U I D E