What's New in Siebel Database Upgrade Guide for DB2 UDB for z/OS, Version 8.0, Rev. B

No new features have been added to this guide for this release. This guide has been updated to reflect only product name changes.

What's New in Siebel Database Upgrade Guide for DB2 UDB for z/OS, Version 8.0, Rev. A

Table 1 lists changes described in this version of the documentation to support this release of the software.

Table 1. New Product Features in Siebel Database Upgrade Guide for DB2 UDB for z/OS, Version 8.0, Rev. A
Topic
Description

About Siebel Additive Schema Upgrade Changes

Amended topic. To ensure index creation during the additive upgrade process does not impact Siebel application usage, change the index definition to DEFINE YES, DEFER YES; this ensures the index is not populated while it is being created, so the associated table is not locked.

Process of Upgrading a Siebel Development Environment

Process of Upgrading a Production Test Environment

Process of Upgrading a Siebel Production Environment

Amended topics. The sequence in which the REORG and RUNSTATs utilities must be run during the development, production test, and production upgrade processes has been changed.

Upgrade Custom Database Schema (upgphys)

Amended topic. It is recommended that you issue an SQL DROP command to remove the Enterprise Integration Manager (EIM) tables from the database before synchronizing the Siebel logical and physical schemas.

About Applying the DSNTIAUL Patch

Amended topic. Added a section describing the DSNTIAUL patch, @@TIAUL USERMOD.

Customizing the JCL UNIT Parameter Value

New topic describing how to amend the UNIT=SYSDA parameter for the JCL generated for the Siebel upgrade.

Renaming the Production Environment Repository

Amended topic. To prevent a naming conflict, rename your existing production repository just before you take your production database offline to run the in-place target database upgrade.

Deleting Redundant Upgrade Files

Amended topic. This topic now includes information on deleting stored procedures after the upgrade is completed.

Additional Changes

References to Siebel SupportWeb have been removed from the guide.

  • The Siebel Bookshelf is available on Oracle Technology Network (http://www.oracle.com/technetwork/indexes/documentation/index.html) and Oracle Software Delivery Cloud. It might also be installed locally on your intranet or on a network location.
  • Siebel System Requirements and Supported Platforms is located on Oracle Technology Network.
  • Other Siebel CRM documentation (Release Notes, Maintenance Release Guides, Technical Notes, Alerts, Troubleshooting Steps, FAQs, Error Messages) is located on My Oracle Support.

What's New in Siebel Database Upgrade Guide for DB2 UDB for z/OS, Version 8.0

The title of this guide has changed from Upgrade Guide for DB2 UDB for z/OS to Siebel Database Upgrade Guide for DB2 UDB for z/OS. The subject matter of the book and the scope of the book have not changed.

A number of topics and chapters were removed from this guide because they duplicated information that is contained in the Siebel Database Upgrade Guide. These topics have been replaced with references to the relevant chapters of the Siebel Database Upgrade Guide, where appropriate.

Table 2 lists changes described in this version of the documentation to support release 8.0 of the software.

Table 2. New Product Features in Siebel Database Upgrade Guide for DB2 UDB for z/OS, Version 8.0
Topic
Description
  • Application Upgrade Planning
  • Tables Modified or Seeded During Upgrade
  • Siebel Marketing Upgrade Reference

These chapters were deleted because the information they contain is in the core Siebel Database Upgrade Guide.

Topics that duplicated information in the Siebel Database Upgrade Guide were deleted from these chapters.

 

 

How the Siebel Database Upgrade Works.

Changed a number of topics to reflect changes in the z/OS upgrade process.

How to Perform a Siebel Database Upgrade.

Changed steps in the roadmap to reflect the new z/OS upgrade process.

About Using the DSNTIAUL Utility

New topic. Describes the DSNTIAUL patch supplied with Siebel 8.0.

About Estimating Database Size

Revised this topic to include the number of tables and the space required for a sample Siebel 8.0 SIA database.

About Multilingual Deployments

This topic was amended. In Siebel 8.0, the upgrade process upgrades both the primary (base) language and all deployed languages for upgrades from Siebel 7.x. If you are upgrading from Release 6.2.1, however, only the primary language is upgraded; all other deployed languages must be upgraded manually.

Preparing the Storage Layout of the Schema

Revised this topic to reflect the Database Configuration Wizard screen changes.

Reviewing EIM Table Partitioning and Data Distribution

New topic. This topic was formerly in Implementing Siebel Business Applications on DB2 for z/OS.

Converting LONG VARCHAR Columns to CLOB Columns

New topic. If you are upgrading to Siebel 8.0 from releases earlier than 7.8.x, the SCRIPT column of the S_SERVICE_SCRPT table must be converted from a LONG VARCHAR to a CLOB data type or the repository merge process fails.

Running the Database Configuration Wizard to Perform Upgrade Tasks.

Revised a number of topics to describe the new upgrade options that run from the Database Configuration Wizard.

Moved topics that did not relate to running the Database Configuration Wizard to other chapters.

Creating the Siebel Staging Database.

New chapter. This chapter describes how to generate the staging database files and how to apply them on the z/OS host. Upgrades to previous releases of Siebel Business Applications did not use a staging database because in-place upgrades were not supported.

Generating the Siebel Upgrade Files.

New chapter. This chapter describes how to generate the upgrade files for the in-place upgrade by running the Upgrade Wizard against the staging database.

Upgrading the Target Database.

New chapter. This chapter describes how to perform the in-place upgrade of the target database.

Performing Post-Upgrade Tasks On the Target Database.

New chapter. This chapter describes tasks you must perform after performing the in-place target database upgrade. Some of these tasks were previously described in the Upgrading a Database from the Mainframe chapter, which was deleted.

Upgrading a Development Environment Database from the Midtier

This chapter was deleted. Midtier upgrades are no longer supported.

Upgrading a Database from the Mainframe

This chapter was deleted. Some of the information was incorporated into new chapters in this guide.

Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.