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


Creating the Microsoft SQL Server database

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 Microsoft® SQL Server database.

About this task

Before you can run scripts to create a Microsoft SQL Server database manually, you need to customize them for WebSphere ESB. WebSphere ESB comes with following scripts:
Table 1. Microsoft SQL Server scripts for WebSphere ESB
createDatabase_CommonDB.sql
createTable_AppScheduler.sql
createTable_mediation.sql
createTable_RelationshipMetadataTable.sql
createTable_customization.sql
dropTable_AppScheduler.sql
createTable_CommonDB.sql
createTable_lockmanager.sql
createTable_Recovery.sql
createTable_EsbLoggerMediation.sql
insertTable_CommonDB.sql
configCommonDB.sh
configCommonDB.bat
Procedure
  1. Make sure that you are using a user ID with sufficient authority to update the database schema.
  2. Locate the directory where the database scripts are located:
    • For i5/OS operating systemFor Linux operating systemFor UNIX operating system <media_root>/dbscripts/CommonDB or <extract_directory>/dbscripts/CommonDB
    • For Windows operating system <media_root>\dbscripts\CommonDB or <extract_directory>\dbscripts\CommonDB
  3. Locate the configCommonDB.bat or configCommonDB.sh file and perform the following subtasks:
    1. Replace the DB_NAME variable with the database name, for example MASTER.
    2. Replace the DB_USER variable with the database user name, for example sqluser.
    3. Replace the DB_HOSTNAME variable with the SQL host name, for example me.usca.ibm.com.
  4. 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:
    1. Replace the MajorVersion variable with the first digit of the product version number, for example 6.
    2. Replace the MinorVersion variable with the second digit of the product version number, for example 2.
    3. Replace the RefreshPackLevel variable with the third digit of the product version number, for example 0.
    4. Replace the FixpackLevel variable with the fourth digit of the product version number, for example 0.
  5. Run the Microsoft SQL Server scripts, which are listed in Table 1. For information on how to run a .sql script with your database, refer to the documentation for your database product.
  6. If there are any errors, or failure is indicated in your database client output, fix the reported errors and try again.

Results

The Microsoft SQL Server database is created.

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