Siebel Database Upgrade Guide for DB2 UDB for z/OS


What's New in This Release


Back to top


About Siebel Database Upgrade Topics

How To Use This Guide

How the Upgrade Topics are Organized

About the Applicability of Siebel Database Upgrade Topics

About Terms Used in Siebel Database Upgrade Topics

About File Paths and Commands in Upgrade Topics


Back to top


How the Siebel Database Upgrade Works

About Supported Upgrade Paths

About Using Oracle's Application Expert Services

About Unicode Support

About Siebel Upgrade Environments

About the z/OS Upgrade

About the Staging Database

About Siebel Additive Schema Upgrade Changes

About the Siebel Database Upgrade Process

About the Database Configuration Wizard

About the Siebel Upgrade Wizard and Driver Files

Job Flow of a Production Database Upgrade

Key Members in a Mainframe-Centric Upgrade

About the JCL Upgrade Jobs

About the Override File

About the Siebel Database Configuration Utilities


Back to top


How to Perform a Siebel Database Upgrade

Roadmap for Performing a Siebel Database Upgrade

Roadmap for Upgrading from Siebel Financial Services 6.2.1 and Siebel 7.x

Roadmap for Upgrading to Siebel 8.0 Without a Development Environment

Process of Planning a Siebel Database Upgrade

Process of Upgrading a Siebel Development Environment

Process of Upgrading a Production Test Environment

Process of Tuning the Upgrade Performance

Process of Upgrading a Siebel Production Environment


Back to top


Planning A Siebel Database Upgrade

Planning Resources for Upgrading to 8.0 on z/OS

Planning Changes to the Physical Layout of the Schema

Testing Before a Production Upgrade

Considering Code Page Support

About Executing Jobs Using Siebel-Scheduled Mode or Vendor-Scheduled Mode

Staging and Target Database Planning

Obtaining Required Software and Hardware

Obtaining Required IBM Utilities

About Using the DSNTIAUL Utility

About Applying the DSNTIAUL Patch

About DSNTIAUL CCSID Conversion Errors

Obtaining Required Security Privileges

Planning Backup and Recovery Stages

About Creating a Schedule for the Upgrade

About Estimating Database Size

Upgrading Your DB2 Software

About Multilingual Deployments

About Database Clustered Indexes


Back to top


Basic Database Preparations for a Siebel Upgrade

Verifying Database Configuration

Creating Storage Groups

Preparing the Storage Layout of the Schema

Modifying the Storage Control File

About Extracting the Storage Control File

Extracting the Storage Control File

Validating the Extracted Storage Control File

Reviewing the Storage Control File

Reviewing EIM Table Partitioning and Data Distribution

Backing Up the Database

Granting a Siebel User Upgrade Authorization


Back to top


Preparing Siebel Application Data for Upgrade

Identifying and Resolving Duplicate Row IDs

Preparing Siebel eChannel Data for Upgrade

Preparing Forecasting Data for Upgrade

Preparing Products and Quotes for Upgrade

Preparing Financial Services Application Tables for Upgrade

Preparing Siebel Configurator Data for Upgrade

Setting the Value of the TYPE_CD Column

Converting LONG VARCHAR Columns to CLOB Columns


Back to top


Preparing a Development Environment for a Siebel Upgrade

Requirements for a Development Upgrade

About Moving Tables

Checking In Development Repository Projects

Preparing EIM Tables for Upgrade

Preparing for Intersection Table Maintenance and Deduplication

Determining Which Template File Was Used During an Extract or Merge


Back to top


Preparing a Production Environment for a Siebel Upgrade

Requirements for a Production Upgrade

About Moving the Customized Repository and Schema Definition Files

Renaming the Production Environment Repository

Preparing for a No-Development-Environment Siebel Upgrade


Back to top


Running the Database Configuration Wizard to Perform Upgrade Tasks

Information Required By the Database Configuration Wizard

Information Required by the Database Configuration Wizard

About Running the Database Configuration Wizard Under Windows

About Running the Database Configuration Wizard Under UNIX

Starting the Siebel Upgrade Wizard

Restarting the Siebel Upgrade Wizard After Pauses

Stopping the Siebel Upgrade Wizard

Upgrading the Repository and Importing Seed Data


Back to top


Creating the Siebel Staging Database

Process of Creating the Staging Database

Required Tasks before Creating the Staging Database

Creating the Staging Database Schema DDL Files

Transferring the Staging DDL to the z/OS Host

Preparing the z/OS Host Upgrade Environment and Creating the Staging Database

Requirements for Upgrade Procedures on the z/OS Host

Customizing the JCL UNIT Parameter Value

Creating and Allocating the z/OS Setup Data Sets

Preparing the Upgrade Environment and Building the Staging Database

Removing Interface Tables and Triggers


Back to top


Generating the Siebel Upgrade Files

About Generating the Upgrade Files

Process of Generating the Upgrade Files

Prerequisite Tasks for Generating the Upgrade Files

Preparing the Additive Schema and JCL Files on the z/OS Host

Transferring the Additive Schema, PRET, and Data Migration Files to the z/OS Host

Preparing the z/OS Data Sets

Specifying the Scheduling Mode

Preparing the Additive Schema SQL and JCL Templates

Applying the Additive Schema Changes to the Production Staging Database

Preparing for Table Creation (PRET) on the Staging Database

Preparing and Executing the Non-Additive Schema and JCL Files on the z/OS Host

Transferring the Non-Additive Schema, Temp table, and Load and Unload files to the z/OS Host

Preparing the Non-Additive Schema SQL and JCL Templates and Executing the DDL

Applying the Non-Additive Schema Changes

Creating the Data Migration Indexes

Processing the Index Schema File

Transferring the SCINDX.SQL File to the z/OS Host

Restructuring the Index DDL

Building JCL Templates for the Target Database


Back to top


Upgrading the Target Database

Process of Upgrading the Target Database

Creating and Loading Siebel Log Tables

Applying Additive Upgrade Changes to the Target Database

Performing the In-Place Target Database Upgrade

Preparing the Target Database for the Upgrade

Running the PRET Jobs For the Target Database

Applying Non-Additive Schema Upgrade Changes to the Target Database

Creating and Deploying Stored Procedures on the Target Database

Migrating Data On the Target Database

Creating 8.0 Schema Indexes

Migrating the Gen Primary 8.0 SQL to Update Data in Target Tables

Generating RUNSTATS Jobs

Restarting Upgrade Jobs That Fail


Back to top


Performing the Siebel Repository Merge

About Backing Up the New Customer Repository or Database Schema

About Reorganizing Tables Before the Repository Merge

Running the Repository Preparation Wizard on a Release 6.2.1 Repository

Performing a Siebel Repository Merge

Regenerating the Siebel Repository Definition Files

Creating a New SRF File


Back to top


Migrating Siebel 6.2.1 Customizations

About Migrating to the Siebel Web Client

About Migrating 6.2.1 Scripts

About Migrating 6.2.1 Client-Side Interfaces

Identifying What Will Be Migrated

Exposing Hidden Properties of Applets and Views

Running the Siebel Web Client Migration Wizard

Reviewing Applet and View Migration

Running the Web Layout Wizard

Migrating Scripts Attached to Controls

Migrating Scripts Attached to Applets

Migrating Business Component, Business Service, and Application Scripts

Migrating Outbound COM Interfaces

Migrating Inbound COM Interfaces

Regenerating the Postmerge Utilities Log

Reviewing Customized Business Components


Back to top


Performing Post-Upgrade Tasks On the Target Database

Transferring the Development Environment Upgrade Output Files to the z/OS Host

Synchronizing the Schema

Migrating Custom Business Component Configurations

Performing Intersection Table Maintenance

Installing New License Keys After Upgrade

Deleting Redundant Upgrade Files


Back to top


Reviewing the Siebel Upgrade Log Files

About the Siebel Upgrade Log Files

Reviewing Siebel Upgrade Log Files for Errors

Manually Archiving Upgrade Log Files

Viewing the Siebel Job Log Status

Running SQL in Siebel Logs


Back to top


Postupgrade Tasks for a Siebel Development Environment

Reapplying Schema Customizations to the Siebel Database

Deleting Duplicate EIM Mappings

Regenerating the Database Template File


Back to top


Postupgrade Tasks for Siebel Database and File System

Updating the File System Directory

Updating File System Attachments


Back to top


Postupgrade Tasks for Siebel Applications

Setting Visibility Modes for Access Control

Removing Call Center Duplicate Logins After Upgrade

Upgrading File System Attachments for Siebel Financial Services Call Reports

Upgrading File System for Household Notes and Attachments

Configuring Products and Quotes

Upgrading Siebel Seeded Workflows

Upgrading Inbound Workflows


Back to top


Tuning the Siebel Production Upgrade Scripts

About Tuning the Upgrade Scripts

Optimizing Unload and Load Job Performance

Adding the Statistics Clause to Load Cards


Back to top


Siebel Upgrade Planning Worksheet

Team Lead Summary

DB2 Connect Information

Siebel Development Environment Information

Siebel Production Environment Information

z/OS Host System Variables Information


Back to top


Columns Denormalized During Upgrade to Siebel Release 8.0

Denormalized Columns for 6.2.1 Siebel Financial Services Applications

Denormalized Columns for 6.2.1 Siebel Business Applications

Denormalized Columns for 6.3 Siebel Industry Solutions

Denormalized Columns for 7.0.4 Siebel Business Applications

Denormalized Columns for 7.0.4 Siebel Financial Services Applications

Denormalized Columns for 7.0.4 Siebel Industry Solutions

Denormalized Columns for 7.5.2 Siebel Industry Applications


Back to top


Siebel Upgrade Files

Siebel 8.0 z/OS Upgrade Files

Tables Amended During PRET Unload Processing

PRET Members Generated By Pretedit.txt

Tables Amended During PRET Processing

Back to top

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