http://tagfacts.com/kuchin/db2en-ushttp://tagfacts.com/kuchindb2start

db2
list applications all
force application all
stop database manager
start database manager
terminate

db2 uncatalog db db_name

db2 get database configuration for db_name | grep -i pool
db2 update db cfg for db_name using parm_name parm_value
db2 terminate
db2 force applications all

# override bufferpool size
db2set DB2_OVERRIDE_BPF=1000

# db2 : sysctl -p

#db kernel tuning
kernel.sem=250 256000 32 1024
#shmmax for a 64-bit system
kernel.shmmax=1073741824
#shmall for 90 percent of 512MB memory
kernel.shmall=150859
kernel.msgmax=65535
kernel.msgmnb=65535



# sudo apt-get install bum
# /etc/init.d/db2 (chmod a+x)

#!/bin/sh

case "$1" in
start)
su - dasusr1 -c "db2admin start"
/opt/ibm/db2/V9.1/instance/db2istrt
su - db2inst1 -c "db2 activate database dev"
;;
stop)
kill -9 `ps -efa | grep db2wdog | grep -v grep | cut -c10-15`
;;
*)
echo $"Usage: $0 {start|stop}"
exit 1
esac

exit 0

by kuchin
Tags: linux db2]]>Tue, 25 Apr 2006 17:39:56 GMTprograms_id_365kuchin@nosuchserver.comlinuxdb2