Combined book

Upgrade Guide for DB2 UDB for z/OS and OS/390

This guide is now a stand-alone guide containing all of the procedures necessary to perform z/OS and OS/390 upgrades. You no longer need to use the Upgrade Guide as a companion to this guide.

How to Perform the Upgrade

New chapter. This chapter contains checklists for performing z/OS and OS/390 upgrades.

Upgrading a Database from the Mainframe

New chapter. There are now two ways to upgrade a development environment database: from the midtier or from the mainframe. Review this chapter for information on upgrading a development environment database from the mainframe.

Upgrade Planning for Address Migration

New topic. The way addresses are stored has been changed at Release 7.7. Review this topic to determine how to handle table customizations.

Preparing Products for Upgrade

New topic. To migrate products in workspaces, you must release them. Class products must have the orderable flag unchecked.

Preparing Address Data for Upgrade

New topic. You must check for duplicate row-IDs within and between S_ADDR_PER and S_ADDR_ORG before performing the upgrep of the Siebel Database.

Migrating Repository Objects to the Standard UI

New topic. If you selected the Incorporate Custom Layout (ICL) option for the previous Release 7.x upgrade, you must return your user interface to the standard look and feel before performing the repository merge.

About the Incorporate Custom Layout (ICL) Upgrade Option

Revised topic. Added guidelines for deciding when to use Incorporate Custom Layout (ICL).

Migrating Address Data from Custom Extension Columns

Revised topic. The changes required to the ddl.ctl and preschem_sia.sql files to migrate address data in custom extension columns has been heavily updated. Review this topic carefully before migrating address data from custom extension columns.

Running the Postmerge Utilities

New topic. You must start the postmerge utilities manually. You can run them multiple times.

Setting Label Alignment for Text Fields

New topic. If you select the ICL option for the upgrade and choose Label on Top, you must edit main.css to obtain correct label alignment.

Verifying Class and Session Times in Siebel Training

New topic. You must verify class and session start times in Siebel Training after upgrade.

Reviewing Address Records After Upgrade

New topic. You must review address records after upgrade to eliminate duplicate and obsolete records.

Upgrading Attribute Pricing

New topic. You must run a business service method to upgrade attribute pricing.

Verifying the Upgrade to Aggregate Discounts in Pricer

New topic. You must verify bundle factors have been correctly updated to the new aggregate discounts feature.

Important Schema Changes at Release 7.7

New topic. Lists important schema changes in Release 7.7.

Upgrading ERM Customized Microsite and Group News Pages

Revised topic. Corrected error in procedure.

Running the Postmerge Utilities

All topics rewritten to improve clarity. Tools procedures added where necessary.

Three new topics added covering Issue 7, 8, and 9 sections of postmerge utilities log.

Migrating Data to the Bankruptcy Status Field

New topic. BK_STATUS_CD is added to S_BANKRUPTCY. This column stores bankruptcy status for use by Siebel Financial Services applications. If you have implemented a bankruptcy status field, you must migrate the data to BK_STATUS_CD.

New Database Schema Structure in Release 7.7

• Enhanced description of the schema structure that is a new feature of Release 7.7.

Deploying Stored Procedures and User-Defined Functions

• Corrected sequence in which SQL files are executed.
• Split execution of output files into two stages.

Deploying Stored Procedures and User-Defined Functions

• Added prerequisite: schema must be upgraded prior to performing procedure.
• Added missing steps to two jobs in the procedure.

Incorporate Custom Layout (ICL)

Incorporate Custom Layout is not supported at Siebel 7.7. Removed all references to this feature in the book.

New book

Upgrade Guide for DB2 UDB for z/OS and OS/390

Combined the Upgrade Guide for Microsoft Windows, DB2 UDB for OS/390 and z/OS and Upgrade Guide for UNIX, DB2 UDB for OS/390 and z/OS into one book.

This guide is no longer a stand-alone guide. This guide is a companion to the Upgrade Guide.

• Refer to Upgrade Guide for tasks to Migrate Client Customizations to the Siebel 7 Web Client (for upgrades from Release 6.x).
• Refer to Upgrade Guide for tasks to reconfigure the user interface for Release 7.7.

Enhanced development upgrade infrastructure

See Upgrading a Database from the Midtier

The Release 7.7 development upgrade for Siebel eBusiness applications on DB2 features infrastructure enhancements for a midtier upgrade process using the Siebel Database Server Configuration Utility.

Enhanced production upgrade infrastructure

See Upgrading a Database from the Mainframe

The Release 7.7 production upgrade for Siebel eBusiness applications on DB2 features a streamlined process run from the midtier against the mainframe, and enhanced panel-driven upgrade process on the mainframe.