WebSphere

Upgrading the event database from Cloudscape to Derby

If you have an existing Cloudscape event database, you must upgrade it to use the Derby database.

About this task

To upgrade a Cloudscape event database to Derby:
Procedure
  1. Go to the profile_root/bin directory.
  2. Run the Derby migration script for your operating system:
    • Windows® systems:
      eventMigrateDerby db_dir [generateDDLOnly]
    • Linux® and UNIX® systems:
      eventMigrateDerby.sh db_dir [generateDDLOnly]
    The parameters are as follows:
    db_dir
    Specifies the path to the directory containing the existing Cloudscape event database. This parameter is required.
    generateDDLOnly
    Specifies whether you want to generate the DDL script for upgrading the database without running it. Specify this parameter if you want to manually upgrade the database at a later time. This parameter is optional; the default behavior is to generate and run the DDL script.

Results

The Derby migration script creates a backup copy of the existing Cloudscape event database in the db_dir.bak directory and then creates two DDL scripts in the database directory:
  • event_newDDL.sql
  • eventcatalog_newDDL.sql

If you did not specify the generateDDLOnly parameter, the migration script automatically runs these DDL scripts to complete the upgrade to Derby.

Example

The following example upgrades an existing Cloudscape event database in the c:\databases\cloudscapeEventDB directory on a Windows system:
eventMigrateDerby c:\databases\cloudscapeEventDB

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