Upgrade Guide › WebSphere Version › Upgrade on a Single WebSphere Node › Migration of a Node › Upgrade the Workflow Database

Upgrade the Workflow Database

This procedure applies only if you are upgrading from CA Identity Manager r12.

Update the workflow database to work with WorkPoint 3.4.2, so you can continue to use the workflow processes that you developed in WorkPoint 3.3.

To upgrade to WorkPoint 3.4.2

1. Locate the WorkPoint scripts in the Workpoint\database under the Administrative Tools folder. The scripts are in the following default locations:
   • Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\Workpoint\database
   • UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools/Workpoint/database
2. Run the following scripts:

   wp331_to_wp34_cnv_step1.sql

   This script creates the new tables for Workpoint 3.4 and adds the new columns to the end of old tables. It also inserts rows into the WP_*_TYPE tables as needed.

   wp331_to_wp34_cnv_step2.sql

   This script creates the stored procedures required to convert the data.

   wp331_to_wp34_cnv_step3.sql

   This script converts the text data to the new columns. It also populates the new WP_BULK_DATA table from the old WP_BULK_STORAGE table.

   wp34_20060927_add.sql

   This script creates the new tables for Workpoint 3.4.20060927. It also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

   Run the wp34_20070625_add.sql

   This script creates the new tables for Workpoint 3.4.2.20070625. This also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

   wp342_20071218_add.sql

   This script to create the new tables for Workpoint 3.4.2.20071218. It also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

3. Save all changes to the database.