Use this task to create an Informix® Dynamic Server database for
Business Process Choreographer.
Steps for this task
- Install the Informix server on the machine 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 deployment manager machine, if you are using Network Deployment to
administer Business Process Choreographer, for example, to create a clustered
process choreographer setup.
- On your application server machine, change to the directory where the
configuration scripts for Business Process Choreographer are located:
- If your database server is not on the same machine as your application
server:
- Copy the scripts for your operating system from the ProcessChoreographer directory on your application
server to a suitable directory on your database server machine: For Informix on Linux and UNIX copy
the following files:
clearSchemaInformix9.sql
createDatabaseInformix9.sql
createSchemaInformix9.sql
dropSchemaInformix9.sql
createDbspaceInformix9.sh
dropDbSpaceInformix9.sh
For Informix on Windows copy
the following files:clearSchemaInformix9.sql
createDatabaseInformix9.sql
createSchemaInformix9.sql
dropSchemaInformix9.sql
createDbspaceInformix9.bat
dropDbSpaceInformix9.bat
- Change to the directory where you copied the SQL scripts.
- 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 createDbspaceInformix9.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 createDbspaceInformix9.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 createSchemaInformix9.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 dropSchemaInformix9.sql script.
- 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 - createDatabaseInformix9.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 dropSchemaInformix9.sql script to drop only
the schema or the SQL command DROP DATABASE to drop the whole
database.
Result
The Informix Dynamic
Server database for Business Process Choreographer exists.
What to do next
Continue configuring
in the parent topic at
step
2.