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
- Make a backup copy of the existing event database.
- Go to the profile_root/bin directory.
- Run the DB2 upgrade
script for your operating system:
Windows systems: eventUpgradeDB2 runUpgrade=[true|false] dbUser=user
[dbName=name] [dbPassword=pw]
[dbNode=node] [scriptDir=dir]

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.