Initial database setup

Edit online

The initial database setup specifies details about log files and buffer pools.

Use this script for the initial setup of the database used in the 64-bit and 31-bit WebSphere® study with J2EE workloads.
db2 update db cfg for <dbname> using logfilsiz 65535
db2 update db cfg for <dbname> using logprimary 40
db2 update db cfg for <dbname> using newlogpath /db2log
db2 connect to <dbname>
db2 -v alter bufferpool ibmdefaultbp size 975000 automatic
db2 connect reset
db2stop;db2start
db2 connect to <dbname>
db2 connect reset