Siebel Database Upgrade Guide > Postupgrade Tasks for the Siebel Database and File System >

Updating Siebel File System Attachments

Upgrades from: Siebel 6.x, 7.0.x, 7.5.x, 7.7.x, and 7.8.x.

Environments: Development, production test, production.

Platforms: Windows, UNIX, IBM z/OS.

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

The following changes have occurred to the structure of the Siebel File System since Siebel 6.x:

At 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 following topics to update Siebel File System attachments.

Updating Attachment File Names

The task in this topic applies to all upgrades. Oracle 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. 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" = 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, verify that files such as S_EMPLOYEE_12-1ABC.SAF are renamed to S_CONTACT_12-1ABC.SAF.

Updating Attachments for S_LIT

Perform the task in this topic if you are upgrading from Siebel 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.

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 (if your implementation is on iSeries, you can use the value provided for User_Name)
   • 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:\sea7xx\siebsrvr" "C:\sea7xx\dbsrvr"

   UNIX example:

   file_upg_mm.ksh SEBL sadmin sadminpw SIEBEL /usr/siebel/siebfile $SIEBEL_ROOT
/usr/siebel/sea7xx/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.