Siebel Database Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Siebel Applications >
Configuring Products and Quotes
Upgrades: Release 6.2.1 only. Environments: Production test, production. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. You may need to adjust or configure some customizable products and quotes after upgrade. Customizable Products
After upgrading to Release 8.0, the administrator must verify that customizable products work as needed. In order to do so, the administrator must validate and release customizable products for use. This action is performed in the Product Administration screen. If the administrator does not release customizable products after the upgrade, customizable products are not active. Packaged products do not require additional modifications in the postupgrade process. Quote Items
After upgrade, run the following script to correct an issue where quote items had trailing spaces added accidentally. Running this script is mandatory. update S_QUOTE_ITEM
setROW_ID = rtrim(ROW_ID)
, ROOT_QUOTE_ITEM_ID = rtrim(ROOT_QUOTE_ITEM_ID)
, PAR_SQ_ITEM_ID = rtrim(PAR_SQ_ITEM_ID)
, PORT_VALID_PROD_ID = rtrim(PORT_VALID_PROD_ID)
, PROD_PORT_ID = rtrim(PROD_PORT_ID)
, INTEGRATION_ID = rtrim(INTEGRATION_ID)
;
commit
;
File System Attachments for Quotes
During the upgrade, quote attachments from S_QUOTE_ATT are migrated to S_ORDER_ATT . This updated the records in the database and the pointer to the physical file, but did not update file system attachments, which use a naming convention that includes the name of the table they are associated with: TableName_RowID_Revision #.saf . You must run a script to copy and rename certain files named S_QUOTE*.SAF to S_ORDER*.SAF so that they correspond to new table names. To update the file names of quote attachments
- Navigate to the following directory:
Windows: SIEBEL_ROOT \bin
UNIX: $SIEBEL_ROOT /bin
- Type the following command:
Windows:
odbcsql /s "ODBC_DATASOURCE" /u TABLEOWNER /p PASSWORD /separator / /a /c rem /e /h /o FILESYSTEM_LOCATION/MV_QUOTE_TO_ORDER_ATT_NT.bat /l LOGFILE_LOCATION/MV_QUOTE_TO_ORDER_ATT_NT.log SCRIPT_LOCATION/ MV_QUOTE_TO_ORDER_ATT _NT _NT.sql /v y
UNIX:
odbcsql /s "ODBC_DATASOURCE" /u TABLEOWNER /p PASSWORD /separator / /a /c rem /e /h /o FILESYSTEM_LOCATION/mv_quote_to_order_att_unix.ksh /l LOGFILE_LOCATION/mv_quote_to_order_att_unix.log SCRIPT_LOCATION/ mv_quote_to_order_att_unix.sql /v y
where:
"ODBC_DATASOURCE" = Data source of the database (entered in quotation marks).
TABLEOWNER = Tableowner.
PASSWORD = Tableowner password.
FILESYSTEM_LOCATION = Location of the file system.
LOGFILE_LOCATION = Location of the log file.
SCRIPT_LOCATION = Location of the script.
|
|
|
|
/s |
"ODBC_DATASOURCE"
|
Data source of the database (entered in quotation marks) |
Y |
/u |
TABLEOWNER
|
User name to log into database |
Y |
/p |
PASSWORD
|
Password to log into database |
Y |
/a |
Not applicable |
Turn on ODBC auto-commit for session |
N |
/c |
rem
|
Remark. Specify the string that begins at comment (at the beginning of the line) |
Y |
/e |
Not applicable |
Turn off statement printing in spool file |
N |
/h |
Not applicable |
Turn off column headers for queries |
N |
/o |
FILESYSTEM_LOCATION
|
Directory where the file system resides |
Y |
/l |
LOGFILE_LOCATION
|
Write errors and status to log file specified here |
Y |
|
SCRIPT_LOCATION
|
Location of the script |
Y |
/v |
Not applicable |
Turn on statement printing at execute |
N |
- Change your directory to the file system, then type the following command:
Windows: MV_QUOTE_TO_ORDER_ATT _NT .BAT
UNIX: mv_quote_to_order_att_unix.ksh
|