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

Updating Siebel File System Attachments

Upgrades from: Siebel 7.0.x.

Environments: Development, production test, production.

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

During the upgrade from Siebel 7.0.x, files from S_WEB_CNTNT were migrated to S_CB_ASSET_VER. In addition, at Siebel 7.5.x, the naming convention for file system attachments changed. Schema table names are included in the attachment file names.

You must run a utility to rename file system attachments that correspond to inactive tables for Siebel 7.x so that they are accessible by Siebel Business Applications.

Upgrading the Siebel File System

Perform the following procedure to upgrade the Siebel File System.

To upgrade the file system attachments

1. Navigate to the following directory:

   Windows: SIEBEL_ROOT\bin

   UNIX: $SIEBEL_ROOT/bin

2. For each obsolete table, enter the following command:

   Windows: chng_file_sys.bat SOURCE_TABLE TARGET_TABLE "FILE_SYSTEM"

   UNIX: chng_file_sys.ksh -s SOURCE_TABLE -t TARGET_TABLE -f "FILE_SYSTEM"

   where:

   • SOURCE_TABLE = name of the original, inactive, table
   • TARGET_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"

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

Make sure that attachment files for obsolete tables are renamed or copied to alternate locations. 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.

Migrating Files

Run the following procedure if you are upgrading from Siebel 7.0.x.

The table S_LIT was migrated to S_CB_ASSET_VER; therefore, you need to migrate files associated with migrated records. Perform the following steps to copy the files named S_LIT*.SAF and rename them to S_CB_ASSET_VER*.SAF, so that the files correspond to the new table name.

To migrate S_LIT files to S_CB_ASSET_VER

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.