In order to create a
Common database manually, you need to edit and run the scripts that
come with WebSphere® ESB.
This topic tells you how to edit and run scripts associated with the Informix® database.
About this task
Before you can run scripts to create an Informix database manually,
you need to customize them for
WebSphere ESB.
WebSphere ESB comes
with following scripts:
Procedure
- Make sure that you are using a user ID with sufficient
authority to update the database schema.
- Locate the directory where the database scripts are located:


<media_root>/dbscripts/CommonDB
or <extract_directory>/dbscripts/CommonDB
<media_root>\dbscripts\CommonDB
or <extract_directory>\dbscripts\CommonDB
- Locate the createDatabase_CommonDB.sql file
and perform the following subtasks.
- Replace the DB_NAME variable with
the name of the database, for example WPRCSDB.
- Replace the DB_INSTANCE variable
with the Informix instance,
for example ol_myinstance.
- Replace the DB_LOCATION variable
with the Informix database
location, for example c:\informix.
- Locate the insertTable_CommonDB.sql file
and replace the following variables with the WebSphere ESB version
you are installing. For example, if the WebSphere ESB version
is 6.2.0.0 then:
- Replace the MajorVersion variable
with the first digit of the product version number, for example 6.
- Replace the MinorVersion variable
with the second digit of the product version number, for example 2.
- Replace the RefreshPackLevel variable
with the third digit of the product version number, for example 0.
- Replace the FixpackLevel variable
with the fourth digit of the product version number, for example 0.
- Run the configCommonDB.bat or configCommonDB.sh script.
This in turn will run the createDBTables script
to create the necessary schema and tables for the Common database.
- If there are any errors, or failure is indicated
in your database client output, fix the reported errors and try again.