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


Creating the Common database manually before product installation

Use these instructions if you decide to create the Common database manually.

About this task

WebSphere® ESB provides default scripts that you can use to create the Common database manually. You might want to create the database manually in the following situations:
  • If your organization requires that the database be created by a user with DBA privileges, that user must create the Common database before creating or augmenting profiles.
  • If you intend to create or augment profiles during product installation, a user with DBA privileges must create the Common database before you install WebSphere ESB.
Procedure
  1. Go to the directory that contains the database creation scripts. The scripts are located both on the product media and in a directory after product installation. By default, the scripts are located in the following directories:
    • Location on the product media:
      • For i5/OS operating systemFor Linux operating systemFor UNIX operating system <media_root>/dbscripts or <extract_directory>/dbscripts
      • For Windows operating system <media_root>\dbscripts or <extract_directory>\dbscripts
    • Location after installation:
      • For i5/OS operating systemFor Linux operating systemFor UNIX operating system install_root/dbscripts
      • For Windows operating system install_root\dbscripts
  2. Open the directory containing the Common database scripts for your database product. The default location depends on the platform:
    • For i5/OS operating systemFor Linux operating systemFor UNIX operating system .../CommonDB/db_type
    • For Windows operating system ...\CommonDB\db_type
    The variable db_type represents the supported database type. Refer to Table 1 to locate your database type and directory name.
    Applicable database types and their directory names are as follows:
    Table 1. Applicable database types and their directory names
    Database type Directory name Corresponding subtopic
    DB2® for i5/OS® [native][toolbox] DB2iSeries Creating the DB2 database for i5/OS
    DB2 Universal Database™ (for all operating systems except z/OS® and i5/OS) DB2 Creating the DB2 database
    DB2 for z/OS Version 8.x DB2zOSV8 Creating the DB2 database for z/OS
    DB2 for z/OS Version 9.x DB2zOSV9
    Informix® Informix Creating the Informix database
    Oracle Oracle Creating the Oracle database
    Microsoft® SQL Server SQLServer Creating the Microsoft SQL Server database
  3. Click the Corresponding subtopic link in Table 1 to proceed with creating the common database manually.

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