WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Creating the Common database and tables after profile creation or augmentation

If you postponed creating the Common database and its tables by selecting the Delay execution of database scripts (must select if using a remote database) check box on the Database configuration panel in the Profile Management Tool, you or your database administrator must create the database and its tables manually. You can do this using scripts that the Profile Management Tool generates during profile creation or augmentation.

Before you begin

This topic assumes that you created or augmented a stand-alone server or deployment manager profile using the procedure in one of the following topics: It also assumes that in the Database configuration panel in the Profile Management Tool, you selected the Create a new local database radio button and chose to delay creation of the Common database and its tables by selecting the Delay execution of database scripts (must select if using a remote database) check box.

About this task

Because a WebSphere ESB installation requires the Common database to function, if you did not allow the Profile Management Tool to create it automatically, you or your database administrator must now create the database and its tables manually by using scripts that the Profile Management Tool generated during the profile creation or augmentation.

Procedure
  1. Go to the directory containing the configCommonDB script on i5/OS® platforms, the configCommonDB.sh script on Linux® and UNIX® platforms, or the configCommonDB.bat script on Windows® platforms. You specified its location in the Database script output directory field on the Database configuration panel in the Profile Management Tool. By default, this location is:
    • For i5/OS operating system profile_root/dbscripts/CommonDB/db_type/db_name
    • For Linux operating systemFor UNIX operating system profile_root/dbscripts/CommonDB/db_type/db_name
    • For Windows operating system profile_root\dbscripts\CommonDB\db_type\db_name
    The variable db_type represents the supported database product and db_name represents the name of the database.
  2. Use your standard database definition tools, native commands, and procedures to create the database and required tables by running this script. The script contains only basic statements for creating databases, tables, and indexes.

What to do next

After database creation completes successfully, before starting the server or deployment manager, be sure the database is running even if it is installed locally. Then start the server or deployment manager from the profile's First steps console to ensure there are no errors. You can check the SystemOut.log and SystemErr.log files for errors. These files are found in the following locations:
  • profile_root/logs/server_name, for a stand-alone profile
  • profile_root/logs/dmgr, for a deployment manager profile

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/tins_new_dbcreate.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).