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 configuration scripts for Business Process Choreographer are located:
    • On Windows® systems, enter:
      cd install_root\ProcessChoreographer
      On UNIX® and Linux® systems, enter:
      cd install_root/ProcessChoreographer
  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:
      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
    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 - 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.
  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 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.

    3. 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.
    4. Check the script output for any errors. If you want to drop the schema, use the dropSchemaInformix9.sql script.

Result

The Informix Dynamic Server database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

Terms of use |

Last updated: Thu Apr 27 14:54:57 2006

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