Use this task to create a DB2® database for Business Process Choreographer.
cd install_root\dbscripts\ProcessChoreographer\DB2
cd install_root/dbscripts/ProcessChoreographer/DB2
clearSchema.sql createDatabase.sql createTablespace.sql createSchema.sql dropSchema.sql dropTablespace.sql
clearSchema_Observer.sql createDatabase_Observer.sql createSchema_Observer.sql createTablespace_Observer.sql dropSchema_Observer.sql dropTablespace_Observer.sql
/usr/opt/db2_08_01/adm/db2licm -l
/opt/IBM/db2/V8.1/adm/db2licm -l
db2 -tf createDatabase.sqlOtherwise you must create the database manually. For a production environment consider using dedicated table space containers and adjusting the DB2 parameters.
db2 connect to BPEDB db2 bind %DB2PATH%\bnd\@db2cli.lst blocking all grant publicOn UNIX and Linux systems, enter:
db2 connect to BPEDB db2 bind $DB2DIR/bnd/@db2cli.lst blocking all grant public
db2 connect to databaseName
db2 -tf createTablespace.sqlMake sure that the script output contains no errors. If errors occur, you can drop the table space using the dropTablespace.sql script.
db2 -tf createSchema.sqlMake sure that the script output contains no errors. If you want to drop the schema, use the dropSchema.sql script.
db2 catalog database databaseName as databaseAlias at node nodeNameFor more information about cataloging a database refer to the DB2 documentation.
db2 connect to databaseName user userID db2 connect reset
db2 connect to databaseName
db2 call sqlj.install_jar('file:/pathURL','BPCODBUTIL')where pathURL is a fully qualified URL to the jar file. For example:
db2 call sqlj.install_jar('file:/c:/tmp/bpcodbutil.jar','BPCODBUTIL')
db2 call sqlj.install_jar('file:/tmp/bpcodbutil.jar','BPCODBUTIL')
db2 call sqlj.remove_jar('BPCODBUTIL')
db2 -tf createTablespace_Observer.sql
db2 -tf createSchema_Observer.sql
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)