WebSphere

Upgrading a DB2 event database from a previous version

If you have an existing DB2® event database from Version 5.1 of Common Event Infrastructure on a Linux®, UNIX®, or Windows® system, you must upgrade it to the current version.

About this task

To upgrade a DB2 event database on a Linux or UNIX system:
Procedure
  1. Make a backup copy of the existing event database.
  2. Go to the profile_root/bin directory.
  3. Run the DB2 upgrade script for your operating system:
    • For Windows operating system Windows systems:
      eventUpgradeDB2 runUpgrade=[true|false] dbUser=user
        [dbName=name] [dbPassword=pw]
        [dbNode=node] [scriptDir=dir]
    • For Linux operating systemFor UNIX operating system Linux and UNIX systems:
      eventUpgradeDB2.sh runUpgrade=[true|false] dbUser=user
        [dbName=name] [dbPassword=pw]
        [dbNode=node] [scriptDir=dir]
    The typical required parameters are as follows:
    runUpgrade
    Indicates whether you want the upgrade script to automatically run the generated DDL scripts to complete the database upgrade. This parameter is required. Specify false if you want to manually perform the database upgrade at a later time or on a different system.
    dbUser
    Specifies the DB2 user ID to use. This parameter is required.
    dbName
    Specifies the DB2 database name. The default name for the event database is event. This parameter is required if you specified runUpgrade=true.
    dbPassword
    Specifies the password for the specified DB2 user ID. This parameter is optional; if you do not specify a password, DB2 prompts you to type it.
    dbNode
    Specifies the database node name. This parameter is required if you are running the upgrade script from a DB2 client system.
    scriptDir
    Specifies the directory you want to contain the generated DDL scripts. This parameter is optional; if you do not specify a directory, the scripts are stored in the .\eventDBUpgrade\db2 directory.

    To see a complete list of parameters and usage information, run the eventUpgradeDB2 script with no parameters.

Results

The upgrade script generates the required DDL scripts for upgrading the event database. If you specified runUpgrade=true, the DDL scripts are automatically run, completing the upgrade.

Example

The following example upgrades an existing DB2 database on a Windows system:
eventUpgradeDB2 runUpgrade=true dbUser=db2inst1 dbName=event

What to do next

If you specified runUpgrade=false, you must manually run the DDL scripts on the database system to complete the database upgrade.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_upgrade_db_db2.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).