Open main menu

OpenVZ Virtuozzo Containers Wiki β

Changes

DB2 installation

10 bytes removed, 08:42, 6 September 2007
Tidy it up a little now
* Run exp/disk1/db2setup
* Follow the prompts:
** Setup user 'dasusr1' ** Setup user 'db2inst1' and database instance 'db2inst1'
== Post-install actions ==
If these don't work it means your environment variables are not set properly. IBM set these for me:
* CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.* DB2INSTANCE=db2inst1* PATH=/usr/local/bin:/usr/bin:/bin:/usr/games:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc
Try creating IBM's sample database:
;;
esac
exit 0
And I used this command to create the symlink to make it start at VE "boot" time:
* update-rc.d db2 start 95 2 .
== Testing your installation ==
Inside the db2 client, try:
* connect to sample* grant all privileges to user fred (?not sure?)* connect reset
38
edits