Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Optimizing Performance with Buffer Pools > Master Worksheet >

Altering the Buffer Pool Thresholds

Modify buffer pool thresholds to correspond with the your stored object type.

-ALTER BPOOL(BP2) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP10) VPSEQT(5) DWQT(80) VDWQT(5)

-ALTER BPOOL(BP12) VPSEQT(5) DWQT(80) VDWQT(5)

-ALTER BPOOL(BP14) VPSEQT(5) DWQT(80) VDWQT(5)

-ALTER BPOOL(BP16) VPSEQT(5) DWQT(80) VDWQT(5)

-ALTER BPOOL(BP17) VPSEQT(5) DWQT(80) VDWQT(5)

-ALTER BPOOL(BP18) VPSEQT(5) DWQT(80) VDWQT(5)

-ALTER BPOOL(BP22) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP23) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP25) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP26) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP27) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP30) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP32) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP33) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP34) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP35) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP36) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP37) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP38) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP39) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP40) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP41) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP42) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP43) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP44) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP45) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP46) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP47) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP48) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP49) VPSEQT(10) DWQT(50) VDWQT(10)

-ALTER BPOOL(BP16K0) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP16K1) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP16K4) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP16K8) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP16K9) VPSEQT(5) DWQT(80) VDWQT(80)

-ALTER BPOOL(BP32K1) VPSEQT(10) DWQT(50) VDWQT(10)


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003