WebSphere

Upgrading a DB2 for z/OS event database from a previous version

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
  1. Make a backup copy of the existing event database.
  2. Go to the profile_root/bin directory.
  3. Run the DB2 for z/OS upgrade script:
    • 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.

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.

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.z.620.doc/doc/tcei_upgrade_db_db2zos.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).