If you have an existing DB2® event
database from Version 5.1 of Common Event Infrastructure on a z/OS® system, you must upgrade it to the current
version.
About this task
To upgrade a DB2 event
database on a z/OS system:
Procedure
- Make a backup copy of the existing event database.
- Go to the profile_root/bin directory.
- Run the DB2 for z/OS upgrade
script:
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 upgrade
the database at a later time or on a different system.
z/OS systems: This parameter is ignored on
a native z/OS system. Automatically
running the generated DDL scripts is supported only on a client 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.
- 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\db2zos directory.
- storageGroup
- Specifies the name of the storage group. This parameter is required.
- bufferPool4K
- Specifies the name of the 4K buffer pool. This parameter is required.
- bufferPool8K
- Specifies the name of the 8K buffer pool. This parameter is required.
- bufferPool16K
- Specifies the name of the 16K buffer pool. This parameter is required.
To see a complete list of parameters and
usage information, run the eventUpgradeDB2ZOS script with no
parameters.
Results
The upgrade script generates the required DDL scripts for
upgrading the event database. If you specified
runUpgrade=true on
a client system, the DDL scripts are automatically run, completing
the upgrade.
What to do next
You must now manually
run the generated DDL scripts using the SQL Processor Using File Input
(SPUFI) facility. This step completes the database upgrade.