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

You may need to adjust or configure some customizable products and quotes after upgrade.

Customizable Products

After upgrading to Release 7.7.x, 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

1. Navigate to the following directory:

   Windows: SIEBEL_ROOT\bin

   UNIX: $SIEBEL_ROOT/bin

2. 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.

   Flag	Parameter	Description	Required
   /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

3. 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