This topic describes how to create a DB2 UDB database for process choreographer.
Steps for this task
clearSchemaDb2.ddl createDatabaseDb2.ddl createTablespaceDb2.ddl createSchemaDb2.ddl dropSchemaDb2.ddl dropTablespaceDb2.ddl
db2set DB2_RR_TO_RS=YESthen restart the DB2 instance to activate the change.
db2 -tf createDatabaseDb2.ddlOtherwise you must create it manually using the other scripts. For a production environment consider using dedicated table space containers and adjusting the DB2 parameters.
On Windows systems, enter:
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 occurred, 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
Results
The DB2 UDB database for process choreographer exists.