Siebel Database Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Siebel 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 a Siebel Database Upgrade. When you upgrade to Release 8.0, 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
- Navigate to the following directory:
Windows: SIEBEL_ROOT \bin
UNIX: $SIEBEL_ROOT /bin
- 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
|