Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX > Postupgrade Tasks > Postupgrade Tasks for All Environments >
Updating File System Attachments
During the Siebel database upgrade, data from the inactive table
S_EMPLOYEE
was migrated toS_CONTACT, S_USER, S_EMP_PER
and data fromS_ORG_INT
was migrated toS_ORG_EXT
. Attachments inS_ORG_INT_ATT
were migrated toS_ACCNT_ATT
and attachments inS_EMPLOYEE_ATT
were migrated toS_CONTACT_ATT
.NOTE: If your upgrade to Release 7.5 was from Release 7.x, files from
S_WEB_CNTNT
were migrated toS_CB_ASSET_VER
.Data migration affects the physical file structure of the Siebel File System. Therefore, you need to run a utility to rename file attachments which correspond to inactive tables for Release 7.x so that they will be accessible by Siebel eBusiness Applications. For example, this utility will copy and rename all files named
S_EMPLOYEE_ATT*.SAF
toS_CONTACT_ATT*.SAF
and all files namedS_ORG_INT_ATT*.SAF
toS_ACCNT_ATT*.SAF
so that they correspond to new table names.
- Enter the following command from
$SIEBEL_ROOT
/siebsrvr/bin
:
chng_file_sys.ksh -s
SOURCE_TABLE
-t
TARGET_TABLE
-f
"FILE_SYSTEM"
SOURCE_TABLE
= name of the original, inactive, tableTARGET_TABLE
= name of the new table to which the original data was migrated"FILE_SYSTEM"
= name of the directory where the file system resides (entered inside quotation marks)
chng_file_sys.ksh -s S_EMPLOYEE_ATT -t S_CONTACT_ATT
-f"D:/DBSRVR_ROOT/files"
Review the renamed files carefully to verify that they can be accessed by Siebel eBusiness Applications.
CAUTION: Make sure that attachment files for obsolete tables are renamed or copied to alternate locations.
For example, sinceS_EMPLOYEE_ATT
is migrated toS_CONTACT_ATT
, you need to rename a file such asS_EMPLOYEE_12-1ABC.SAF
toS_CONTACT_12-1ABC.SAF
.If you upgraded from Release 7.0.3 or 7.0.4, data in 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
- Enter the following command from
$SIEBEL_ROOT
/siebsrvr/bin
:file_upg_mm.ksh
ODBC_SOURCE USER_NAME
PASSWORD
TABLE_OWNER
FILE_SYSTEM_LOCATION
SIEBEL_ROOT_DIRECTORY
SIEBEL_DBSRVR_ROOT_DIRECTORY
ODBC_SOURCE
= the ODBC source of the databaseUSER_NAME
= the database user namePASSWORD
= the password for the database user nameTABLE_OWNER
= the database table owner (if your implementation is on iSeries, you can use the value provided forUser_Name
)FILE_SYSTEM_LOCATION
= the directory where the file system residesSIEBEL_ROOT_DIRECTORY
= the directory where Siebel Server is installedSIEBEL_DBSRVR_ROOT_DIRECTORY
= the directory where Siebel Database Server is installedfile_upg_mm.ksh SEBL sadmin sadminpw SIEBEL D:/
DBSRVR_ROOT
/files D:/SIEBSRVR_ROOT
D:/DBSRVR_ROOT
Review the renamed files carefully to verify that they can be accessed by Siebel eBusiness Applications.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX Published: 20 October 2003 |