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.
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
- 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.
- 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