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 for your client
operating system:
Windows® systems: eventUpgradeDB2ZOS runUpgrade=[true|false] dbUser=user
[dbName=name] [dbPassword=pw]
[scriptDir=dir] storageGroup=group
bufferPool4K=4kbufpool bufferPool8k=8kbufpool
bufferPool16K=16kbufpool

Linux® and UNIX® systems:eventUpgradeDB2ZOS.sh runUpgrade=[true|false] dbUser=user
[dbName=name] [dbPassword=pw]
[scriptDir=dir] storageGroup=group
bufferPool4K=4kbufpool bufferPool8k=8kbufpool
bufferPool16K=16kbufpool
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.
Example
The following example upgrades a DB2 for z/OS event database from a Windows client system:
eventUpgradeDB2ZOS runUpgrade=true dbUser=db2inst1 dbName=event
storageGroup=sysdeflt bufferPool4K=BP9 bufferPool8K=BP8K9 bufferPool16K=BP16K9
What to do next
If you specified runUpgrade=false,
or if you ran the upgrade script on the z/OS system,
you must manually run the generated DDL scripts on the z/OS system using the SQL Processor Using File
Input (SPUFI) facility. This step completes the database upgrade.