Use this task to create a DB2® UDB database for Business Process Choreographer.
cd install_root\ProcessChoreographerOn UNIX® and Linux® systems, enter:
cd install_root/ProcessChoreographer
clearSchemaDb2.ddl createDatabaseDb2.ddl createTablespaceDb2.ddl createSchemaDb2.ddl dropSchemaDb2.ddl dropTablespaceDb2.ddl
/usr/opt/db2_08_01/adm/db2licm -l
/opt/IBM/db2/V8.1/adm/db2licm -l
db2 -tf createDatabaseDb2.ddlOtherwise 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 createTablespaceDb2.ddlMake sure that the script output contains no errors. If errors occur, you can drop the table space using the dropTablespaceDb2.ddl script.
db2 -tf createSchemaDb2.ddlMake sure that the script output contains no errors. If you want to drop the schema, use the dropSchemaDb2.ddl 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
Last updated: Thu Apr 27 15:20:08 2006
(c) Copyright IBM Corporation 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)