Upgrade Guide for DB2 UDB for z/OS > Preparing Application Data for Upgrade >

Preparing Calendar Data for Upgrade

Upgrades: Release 6.2.1 only.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform the Upgrade.

A preupgrade script may be run to prevent duplicate Siebel Sync appointments in Release 7.8 calendar.

This script is a required step for upgrades from Siebel Consumer Goods 6.0.x. It is an optional step for all other 6.2.1 upgrades.

If you run the preupgrade script:

• Users do not see duplicate Siebel Sync appointments after upgrade.
• Planned Start value is modified for any record where Release 6.2.1 Planned Start=CREATION and Start Time=IS NOT NULL.

If you do not run the preupgrade script:

• Users see duplicate Siebel Sync appointments after upgrade. This is particularly problematic for repeating appointments.
• Planned start is not overwritten.

To prevent duplicate Siebel Sync appointments, run the following script on the Siebel database before doing the upgrade:

update S_EVT_ACT
set TODO_PLAN_START_DT = null
where APPT_START_DT is not null
and APPT_START_TM is not null
and TODO_PLAN_START_DT = CREATED

This script updates Siebel Sync imported records TODO_PLAN_START_DT to null. This script cannot be run after the upgrade.