WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


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

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: 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.zseries.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).