Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for 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 the Upgrade.

Since Siebel 7.5, file names 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.

Perform the tasks in the sections below to update Siebel File System attachments.

Updating Attachment File Names

NOTE:  The task in this section applies to all upgrades.

Siebel 7.8 provides a utility to update attachment file names in the Siebel File System. Table 40 lists the input table names to use when you run the utility. The utility updates all files containing the table names 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. Enter the following command:

   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 = name of the new table to which the original data was migrated.
   • "FILE_SYSTEM" = name of the directory where the Siebel File System attachments reside (entered inside quotation marks).

     Windows example:

   chng_file_sys.bat S_EMPLOYEE_ATT S_CONTACT_ATT
"C:\siebfile\att"

   UNIX example:

   chng_file_sys.ksh -s S_EMPLOYEE_ATT -t S_CONTACT_ATT
-f "/usr/siebel/siebfile/att"

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

For example, since S_EMPLOYEE_ATT is migrated to S_CONTACT_ATT, you need to rename a file such as S_EMPLOYEE_12-1ABC.SAF to S_CONTACT_12-1ABC.SAF.

Updating Attachments for S_LIT

NOTE:  Perform the task in this section if you are upgrading from Siebel release 6.x and 7.0.x.

At Siebel 7.5, the records in S_LIT are migrated to S_CB_ASSET_VER. You must update the related file names of attachments from S_LIT*.SAF to S_CB_ASSET_VER*.SAF, so that the files correspond to the new table name.

To update attachments for S_LIT

1. Navigate to the following directory:

   Windows: SIEBEL_ROOT\bin

   UNIX: $SIEBEL_ROOT/bin

2. Enter the following command:

   Windows: file_upg_mm.bat ODBC_SOURCE USER_NAME PASSWORD TABLE_OWNER "FILE_SYSTEM_LOCATION" "SIEBEL_ROOT" "DBSRVR_ROOT"

   UNIX: file_upg_mm.ksh ODBC_SOURCE USER_NAME PASSWORD TABLE_OWNER FILE_SYSTEM_LOCATION $SIEBEL_ROOT DBSRVR_ROOT

   where:

   • ODBC_SOURCE = the ODBC source of the database
   • USER_NAME = the database user name
   • PASSWORD = the password for the database user name
   • TABLE_OWNER = the database tableowner
   • FILE_SYSTEM_LOCATION = the directory where the file system resides
   • SIEBEL_ROOT = the directory where the Siebel Server is installed
   • DBSRVR_ROOT = the directory where Siebel Database Server files are installed

     Windows example:

   file_upg_mm.bat SEBL sadmin sadminpw SIEBEL "C:\siebfile" "C:\sea78\siebsrvr" "C:\sea78\dbsrvr"

   UNIX example:

   file_upg_mm.ksh SEBL sadmin sadminpw SIEBEL /usr/siebel/siebfile $SIEBEL_ROOT
/usr/siebel/dbsrvr

   Note that the UNIX syntax does not use quotes around FILE_SYSTEM_LOCATION, and DBSRVR_ROOT.

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