Start of change

Configuring the Common Event Infrastructure and Common databases manually after profile creation or augmentation

When creating or augmenting a profile using the Profile wizard, if you elected to postpone configuring the Common Event Infrastructure and Common databases by producing scripts to be run manually, you or your database administrator must run the generated scripts to create and configure the event, eventcat, and WPRCSDB databases (or their equivalents if they have different names on your system). You must configure these databases before starting the server associated with the profile.

Before you begin

This procedure assumes you have completed Configuring a stand-alone server or Configuring a deployment manager using the Profile wizard to create or augment a stand-alone process server or deployment manager profile. You have closed the Profile Wizard and want to configure the databases manually.

Why and when to perform this task

Configure the databases, as follows.

Steps for this task

  1. Obtain the generated scripts produced by the profile creation or augmentation process. The scripts are located, as follows:
    • Scripts associated with the Common Event Infrastructure databases (event and eventcat by default):
      Draft comment:
      I think the following locations may be for 6.1 – not sure? Please supply the real location for 6.0.2 if these are incorrect. I have seen install_root/profiles/profile_name/logs/ceidef.ddl in other locations.
      • Icon indicating Linux platforms Icon indicating UNIX platforms On Linux and UNIX platforms: install_root/profiles/profile_name/dbscripts/CEI/database_type/database_name.
      • Icon indicating Windows platforms On Windows platforms: install_root\profiles\profile_name\dbscripts\CEI\database_type\database_name.
        Draft comment:
        What is the name of the script or scripts? How many are there (this is after profile creation)?
        See Common Event Infrastructure database specifications for more information about these scripts.
    • Scripts associated with the Common database (WPRCSDB by default):
      • Icon indicating Linux platforms Icon indicating UNIX platforms On Linux and UNIX platforms: install_root/profiles/profile_name/dbscripts/CommonDB/database_type/database_name
      • Icon indicating Windows platforms On Windows platforms: install_root\profiles\profile_name\dbscripts\CommonDB\database_type\database_name
      Draft comment:
      What are the names of the script(s)? How many?
      See Common database specifications for more information about these scripts.
  2. Use native database tools to
    Draft comment:
    "edit and run" or just "run"?
    run the scripts.
    See the following for instructions on how to edit and run these scripts or definitions:
    • For Common Event Infrastructure databases:
      Draft comment:
      Should I reference the CEI topics below in admin or Simon's CEI database configuration file?
      • Administering WebSphere Process Server > Administering the Common Event Infrastructure > Post-installation configuration > Configuring the event database > Configuring the event database (Linux, UNIX, and Windows systems) > Manually running database configuration scripts >
        Draft comment:
        Replace with hot link
        Draft comment:
        Steve Meyer: Need file names of topics that describe how to run CEI database configuration scripts for DB2 and Oracle. Is this path correct?
      • Administering WebSphere Process Server > Administering the Common Event Infrastructure > Post-installation configuration > Configuring the event database > Configuring a DB2 database on a z/OS system > Manually running z/OS database configuration scripts.
        Draft comment:
        Replace with hot link
        Draft comment:
        Steve Meyer: Need file names of topics that describe how to run database configuration scripts for z/OS. The path listed here is dead currently.
    • For the Common database: Common database specifications.

    When you have finished, return to the topic from which you accessed this one (Configuring a stand-alone server or Configuring a deployment manager).


Last updated: Wed 01 Nov 2006 07:47:12

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)

End of change