Bookshelf Home | Contents | Index | Search | PDF

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

Zeroing the Buffer Pools

---

The buffer pools should be set to use data spaces. Failure to use data spaces can result in over use of storage by the DBM1 address space and cause the DB2 subsystem to fail. To change to data spaces, you must first zero the buffer pool allocations:

-ALTER BPOOL(BP2) VPSIZE(0)

-ALTER BPOOL(BP10) VPSIZE(0)

-ALTER BPOOL(BP12) VPSIZE(0)

-ALTER BPOOL(BP14) VPSIZE(0)

-ALTER BPOOL(BP16) VPSIZE(0)

-ALTER BPOOL(BP17) VPSIZE(0)

-ALTER BPOOL(BP18) VPSIZE(0)

-ALTER BPOOL(BP22) VPSIZE(0)

-ALTER BPOOL(BP23) VPSIZE(0)

-ALTER BPOOL(BP25) VPSIZE(0)

-ALTER BPOOL(BP26) VPSIZE(0)

-ALTER BPOOL(BP27) VPSIZE(0)

-ALTER BPOOL(BP30) VPSIZE(0)

-ALTER BPOOL(BP32) VPSIZE(0)

-ALTER BPOOL(BP33) VPSIZE(0)

-ALTER BPOOL(BP34) VPSIZE(0)

-ALTER BPOOL(BP35) VPSIZE(0)

-ALTER BPOOL(BP36) VPSIZE(0)

-ALTER BPOOL(BP37) VPSIZE(0)

-ALTER BPOOL(BP38) VPSIZE(0)

-ALTER BPOOL(BP39) VPSIZE(0)

-ALTER BPOOL(BP40) VPSIZE(0)

-ALTER BPOOL(BP41) VPSIZE(0)

-ALTER BPOOL(BP42) VPSIZE(0)

-ALTER BPOOL(BP43) VPSIZE(0)

-ALTER BPOOL(BP44) VPSIZE(0)

-ALTER BPOOL(BP45) VPSIZE(0)

-ALTER BPOOL(BP46) VPSIZE(0)

-ALTER BPOOL(BP47) VPSIZE(0)

-ALTER BPOOL(BP48) VPSIZE(0)

-ALTER BPOOL(BP49) VPSIZE(0)

-ALTER BPOOL(BP16K0) VPSIZE(0)

-ALTER BPOOL(BP16K1) VPSIZE(0)

-ALTER BPOOL(BP16K4) VPSIZE(0)

-ALTER BPOOL(BP16K8) VPSIZE(0)

-ALTER BPOOL(BP16K9) VPSIZE(0)

-ALTER BPOOL(BP32K1) VPSIZE(0)

-ALTER BPOOL(BP7) VPSIZE(0)

-ALTER BPOOL(BP32K) VPSIZE(0)

Bookshelf Home | Contents | Index | Search | PDF