Siebel Database Upgrade Guide for DB2 for z/OS > Postupgrade Tasks for Siebel Database and File System >

Updating File System Attachments

Upgrades: All upgrades.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Since Siebel CRM 7.5, filenames of attachments include the attachment table name. If an upgrade migrates the records in an attachment table to a new attachment table, you must run a utility to update the file system attachment names.

Oracle provides a utility to update attachment filenames in the Siebel File System. Table 14 lists the input table name to use when you run the utility. The utility updates all files containing the table name you specify.

For example, if you specify the tables S_OLDTABLE_ATT and S_NEWTABLE_ATT, the utility updates the files system attachments by copying all attachment files containing the string S_OLDTABLE_ATT to attachment files containing the string S_NEWTABLE_ATT.

To update file system attachments

1. Navigate to the following directory:

   Windows: SIEBEL_ROOT\bin

   UNIX: $SIEBEL_ROOT/bin

2. Run the following utility:

   Windows: chng_file_sys.bat OLD_TABLE NEW_TABLE "FILE_SYSTEM"

   UNIX: chng_file_sys.ksh -s OLD_TABLE -t NEW_TABLE -f "FILE_SYSTEM"

   where:

   • OLD_TABLE. The name of the attachment table in the release you are upgrading from. This table is obsolete in the new release.
   • NEW_TABLE . Attachment records in OLD_TABLE were migrated to NEW_TABLE in the new release. The utility copies file system attachments containing the string OLD_TABLE to attachments containing the string NEW_TABLE.
   • "FILE_SYSTEM" . The name of the directory where the Siebel File System attachments reside (entered inside quotation marks)

     Windows example:

   chng_file_sys.bat S_INSCLM_BL_ATT S_INVOICE_ATT
"C:\siebfile\att"

   UNIX example:

   chng_file_sys.ksh -s S_INSCLM_BL_ATT -t S_INVOICE_ATT
-f "/usr/siebel/siebfile/att"

3. Review renamed files carefully to verify that they can be accessed by Siebel Business Applications.

For example, since S_INSCLM_BL_ATT is migrated to S_INVOICE_ATT, verify that files such as S_INSCLM_BL_12-1ABC.SAF are renamed to S_INVOICE_12-1ABC.SAF.