Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Applications >

Upgrading File System Attachments for Siebel Financial Services Call Reports

Upgrades: Release 6.2.1 only.

Environments: Production test, production.

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

When you upgrade to Release 7.7.x, call report attachments from S_ACTIVITY_ATT are migrated to S_COMM_ATT. This data migration updated the records in the database and the pointer to the physical file, but did not update file system attachments, which use a naming convention that includes the name of the table they are associated with: TableName_RowID_Revision#.saf.

Therefore, you need to run a script to copy and rename all files named S_ACTIVITY*.SAF to S_COMM*.SAF so that they correspond to new table names.

To generate the file attachment update script

1. Navigate to the following directory:

   Windows: SIEBEL_ROOT\bin

   UNIX: $SIEBEL_ROOT/bin

2. Type the following command:

   Windows:

   odbcsql /s "ODBC_DATASOURCE" /u TABLEOWNER
   /p PASSWORD /separator / /a /c rem /e /h
   /o FILESYSTEM_LOCATION/MV_ACT_TO_COMM_ATT_NT.bat
   /l LOGFILE_LOCATION/MV_ACT_TO_COMM_ATT_NT.log SCRIPT_LOCATION/ MV_ACT_TO_COMM_ATT_NT.sql /v y

   UNIX:

   odbcsql /s "ODBC_DATASOURCE" /u TABLEOWNER
   /p PASSWORD /separator / /a /c rem /e /h
   /o FILESYSTEM_LOCATION/mv_act_to_comm_att_unix.ksh
   /l LOGFILE_LOCATION/mv_act_to_comm_att_unix.log SCRIPT_LOCATION/ mv_act_to_comm_att_unix.sql /v y

   where:

   "ODBC_DATASOURCE" = Data source of the database (entered in quotation marks)

   TABLEOWNER = Tableowner

   PASSWORD = Tableowner password

   FILESYSTEM_LOCATION = Location of the file system

   LOGFILE_LOCATION = Location of the log file

   SCRIPT_LOCATION = Location of the script

To update the file names of call report attachments

• Make the file system your current directory, then type the following command:

  Windows: MV_ACT_TO_COMM_ATT_NT.BAT

  UNIX: mv_act_to_comm_att_unix.ksh