IBM 6.1.X manual Many Pages Tuning, DB2 Database Tuning

4

￿

MANY PAGES TUNING

The “Many Pages Scenario”, derived from the Base Portal Scenario, measures the effects of having larger numbers of pages visible to the users.

Since it is derived from the Base Portal Scenario, the same tuning that was used for the Base Portal Scenario applied for the Many Pages Scenario. The differences in tuning are mentioned below.

DB2 Database Tuning

We applied the following tunings to our Release database.

Table 18: DB2 Database Settings for Many Pages

Release DB

Parameter

dbheap

applheapsz

logbufsz

num_IOServers

num_IOCleaners

Setting Used

4800

4096

256

8

8

How-To Set: In the DB2 server run the following commands:

db2 “update db cfg for release using dbheap 4800” db2 “update db cfg for release using applheapsz 4096” db2 “update db cfg for release using logbufsz 256”

db2 “update db cfg for release using app_ctl_heap_sz 4096” db2 “update db cfg for release using num_IOServers 8” db2 “update db cfg for release using num_IOCleaners 8”

3 4

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