WebSphere brand IBM WebSphere Sensor Events, Version 6.2

Creating the database, tablespace, tables, and data

Use this topic to manually create the database, tablespace, tables, and populate the data required for WebSphere® Sensor Events. If you are using the WebSphere Sensor Events installer to install and create the database, you do not need to follow these steps.

If you choose to install WebSphere Business Events remotely, then you will need to manually create the DB2® or Oracle database. See the WebSphere Business Events Information Center for more information.

Creating the database manually

Use these instructions when a Database Administrator creates the database and tablespace manually, and then the tables and data are created during the installation of WebSphere Sensor Events.

About this task

If you are using Oracle, you should have been prompted to create the SID when you installed the product. If not, refer to the Oracle documentation to set up a SID.

Note: These instructions use the database name, IBMRFID, but you can use a different database name.
Procedure
  1. Create the WebSphere Sensor Events database for DB2 or Oracle.

    For a local or remote DB2 database:

    1. Open the DB2 Control Center.
    2. Right-click All Databases and select Create Database > Standard.
      1. Enter IBMRFID as the database name.
        Note: Linux® commands are case-sensitive.
      2. Select the option to Enable database for XML (Code set will be set to UTF-8). For more information on this option, refer to the DB2 information center.
    3. Click Finish. Do not fine tune the database when it is created.
    4. Exit the DB2 Control Center.
    5. (Optional) Catalog the remote database, IBMRFID, to the local machine.
    For an Oracle database, use the Database Configuration Assistant to create the new database called IBMRFID. Be sure to select the Unicode AL32UTF8 character set.
  2. When installing WebSphere Sensor Events, select the option to create tables and populate the data for the database.

Creating the databases using scripts

Run the scripts provided in the db_script directory on the WebSphere Sensor Events CD to create the database, tablespace, tables and populate data.

Before you begin

Before running the scripts be aware of the following restrictions and take the appropriate action:

  • You must be a database user (such as db2inst1 or oracle) to run the scripts on Linux.
  • For Oracle, the sqlplus executable must be added in the PATH on Linux.
  • The specified tablespace directory must exist.
  • You must have the authorization to access the specified tablespace directory if you are using Linux only.
  • The specified tablespace file cannot be used by another database.
Example

For DB2:

Windows
createIBMRFID_db2.bat dbName longTablespaceFile longTempTablespaceFile
Linux
createIBMRFID_db2.sh dbName longTablespaceFile longTempTablespaceFile

For Oracle:

Windows
createIBMRFID_oracle.bat dbUser dbPassword dbSpec longTablespaceFile 
Linux
createIBMRFID_oracle.sh dbUser dbPassword dbSpec longTablespaceFile 

The database, tablespace, table and data are created under dbSpec.


Library | Support | Terms of use

(c) Copyright IBM Corporation 2004, 2009. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.