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


Creating tables on an existing Common database after profile creation or augmentation

If you postponed creating required tables for your existing Common database 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 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 Use an existing database radio button and chose to delay creation of the 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 and its tables to function, if you did not allow the Profile Management Tool to create the tables automatically, you or your database administrator must now create the 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 table creation script createDBTables on i5/OS® platforms, createDBTables.sh on Linux® and UNIX® platforms, or createDBTables.bat 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 required tables by running this script. The script contains only basic statements for creating databases, tables, and indexes.

What to do next

After the tables are created 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:

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_tablesdb.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).