Appendix A. Set up scripts 341
then
echo "Usage: $0 <instance> "
exit 2
fi
INSTANCE=$1
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
db2set DB2_HASH_JOIN=NO
db2set DB2_MMAP_WRITE=OFF
db2set DB2_MMAP_READ=OFF
db2set DB2_CORRELATED_PREDICATES=YES
db2set DB2_PIPELINED_PLANS=ON
db2set DB2_INTERESTING_KEYS=ON
db2set DB2_PARALLEL_IO=*
db2set DB2_STRIPED_CONTAINERS=ON
db2set DB2MEMMAXFREE=1000000
db2set DB2MEMDISCLAIM=YES
db2set DB2_NO_PKG_LOCK=OFF
db2set DB2ENVLIST=EXTSHM
db2set DB2COMM=TCPIP
db2set DB2CODEPAGE=1208
db2set DB2AUTOSTART=TRUE
echo
echo "Registry values are now as follows"
echo
db2set -all
A.1.3 Database manager configuration parameter ...