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
|