Use this task to create an Informix® Dynamic Server database for
Business Process Choreographer.
Steps for this task
- Install the Informix server on the computer that hosts the database.
- Create an Informix server instance. Make sure that the Informix environment
variables are set correctly. In particular, INFORMIXSERVER must
point to the new instance and ONCONFIG must point to the
configuration file for the instance. For more details about the different
environment variables and how they need to be set up, refer to the Informix Dynamic
Server documentation. Make sure that the environment variables
relating to Global Language Support (GLS) are set to Unicode (UTF-8) support.
Unicode support is required to store all the characters that can be handled
in Java™ code.
- Copy and configure the Java Database Connectivity (JDBC) driver
on:
- All remote application servers that use the database server.
- The server that hosts the deployment manager, if you are using Network
Deployment to administer Business Process Choreographer, for example, to create
a clustered process choreographer setup.
- On the server that hosts your application server,
change to the directory where the Business Process Choreographer configuration
scripts for your database system are located:
- If your database is not hosted on the same server as your application
server:
- Copy the scripts for your operating system from the ProcessChoreographer directory on your application
server to a suitable directory on the server that is hosting your database: For Informix on Linux and UNIX copy
the following files:
clearSchema.sql
createDatabase.sql
createSchema.sql
dropSchema.sql
createDbspace.sh
dropDbSpace.sh
For Informix on Windows copy
the following files:clearSchema.sql
createDatabase.sql
createSchema.sql
dropSchema.sql
createDbspace.bat
dropDbSpace.bat
- Change to the directory where you copied the SQL scripts.
- If you want to create a non-production database using default settings
that is suitable for standalone development, evaluation, or demo purposes,
enter the command:
dbaccess - createDatabase.sql
This
command creates an Informix database BPEDB for the
user ID that you are using. Make sure that the script output contains no errors.
You can use the dropSchema.sql script to drop only the schema
or the SQL command DROP DATABASE to drop the whole database.
- If you want to create a database for a production system, you must
create your database manually:
- Create a database, for example named BPEDB.
- Create the Dbspaces for your database.
On Windows systems, read the instructions in the createDbspace.bat file.
Adjust the value parameters in the script to values appropriate for your environment.
On UNIX and Linux systems,
read the instructions in the createDbspace.sh file. Adjust
the value parameters in the script to values appropriate for your environment.
- Run the script to create the schema, by entering the command:
dbaccess databaseName createSchema.sql
where databaseName is
the name of the database, for example BPEDB.
- Check the script output for any errors. If you want to drop
the schema, use the dropSchema.sql script.
Result
The
database for Business Process Choreographer exists.
What to do next
Continue configuring in the parent topic at step 2.