Appendix A. Set up scripts 345
echo " DB cfg for $db is now as follows: "
echo
db2 get db cfg for $db
A.1.6 Creation of buffer pools
-- create_bp.sh
#!/bin/ksh
if [ $# != 2 ]
then
echo "Usage: $0 <instance> <dbname> "
exit 2
fi
INSTANCE=$1
db=$2
db2 terminate > /dev/null 2>&1
export LD_LIBRARY_PATH=
export export CLASSPATH=
. /home/$INSTANCE/sqllib/db2profile
export LIBPATH=/home/$INSTANCE/sqllib/lib:/usr/lib:/lib
db2 connect to $db
db2 CREATE BUFFERPOOL "BUFF4K" SIZE 14000 PAGESIZE 4096 NOT EXTENDED STORAGE
db2 CREATE BUFFERPOOL "BUFF16K" SIZE 14000 PAGESIZE 16384 NOT EXTENDED STORAGE
db2 CREATE BUFFERPOOL "BUFF32K" SIZE 21750 PAGESIZE 32768 NOT EXTENDED STORAGE
db2 terminate > /dev/null 2>&1
db2 deactivate db $db
db2 activate db $db
A.1.7 Creation of temporary table spaces
-- create_temptbs.ddl
CREATE TEMPORARY TABLESPACE TEMP4KA IN DATABASE PARTITION GROUP IBMTEMPGROUP
PAGESIZE 4096 MANAGED BY SYSTEM
USING ('/db2/fs1/vol78rba/ucsdb2/tbspaces/temp4ka1',
'/db2/fs2/vol78rba/ucsdb2/tbspaces/temp4ka2',

Get Siebel 7.8 with IBM DB2 UDB V8.2 Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.