Creating an Informix Dynamic Server database for Business Process Choreographer

Use this task to create an Informix® Dynamic Server database for Business Process Choreographer.

Steps for this task

  1. Install the Informix server on the computer that hosts the database.
  2. 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.
  3. 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.
  4. 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:
    • On Windows® systems, enter:
      cd install_root\dbscripts\ProcessChoreographer\Informix
    • On UNIX® and Linux® systems, enter:
      cd install_root/dbscripts/ProcessChoreographer/Informix
  5. If your database is not hosted on the same server as your application server:
    1. 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
    2. Change to the directory where you copied the SQL scripts.
  6. 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.
  7. If you want to create a database for a production system, you must create your database manually:
    1. Create a database, for example named BPEDB.
    2. 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.

    3. 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.
    4. 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.

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)