Siebel Database Upgrade Guide for DB2 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
Naming Conventions Used in This Guide
About File Paths and Commands in Upgrade Topics
Back to top
How the Siebel Database Upgrade Works
About Supported Siebel Upgrade Paths
Supported Upgrade Paths for Siebel Innovation Pack 2015, Patchset 5 or Later
Types of Siebel Database Upgrades
About Using Oracle's Advanced Customer 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 Siebel Database Configuration Utilities and Database Configuration Wizard
About the Siebel Upgrade Wizard and Driver Files
Job Flow of a Production Database Upgrade
Key Members in the DSNHLQ.SIEBEL.EXEC
About the JCL Upgrade Jobs
About the Override File
Back to top
How to Perform a Siebel Database Upgrade
Roadmap for Performing a Siebel Database Upgrade
Roadmap for Upgrading from Siebel 7.8.2, 8.0.x or 8.1.1.x
Roadmap for Upgrading from Siebel 7.x, 8.0.x or 8.1.1.x 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 Siebel CRM on z/OS
Planning Changes to the Physical Layout of the Schema
Testing Before a Production Upgrade
Considering Code Page Support
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
Back to top
Basic Database Preparations for a Siebel Upgrade
Verifying Database Configuration
Creating Storage Groups
Updating Table Space Group Names
Process of Preparing the Storage Layout of the Schema
Methods of Modifying the Storage Control File
Options for Extracting the Storage Control File
Extracting the Storage Control File
Validating the Extracted Storage Control File
Reviewing the Extracted Storage Control File
Reviewing EIM Table Partitioning
Converting LONG VARCHAR Columns to CLOB Columns
Rebuilding Target Tables Containing LONG VARCHAR Columns
Backing Up the Database
Granting a Siebel User Upgrade Authorization
Back to top
Preparing a Development Environment for a Siebel Upgrade
Requirements for Upgrading the Development Environment
About Moving Tables
Checking In Development Repository Projects
Determining Which Template File Was Used During an Extract or Merge
Back to top
Preparing a Production Environment for a Siebel Upgrade
Requirements for Upgrading the Production Environment
About Moving the Customized Repository and Schema Definition Files
Preparing for a Siebel Upgrade Without a Development Environment
Back to top
Running the Database Configuration Wizard to Perform Upgrade Tasks
Information Required by the Database Configuration Wizard
About Running the Database Configuration Wizard on 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 Upgrade Environment and Creating the Staging Database
Authorization Requirements for Performing Upgrade Procedures on the z/OS Host
Customizing the JCL UNIT Parameter Value
Creating the z/OS Setup Data Sets
Preparing the Upgrade Environment and Building the Staging Database
Verifying JCL Upgrade Jobs
Removing Interface Tables and Triggers
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
Performing a Siebel Repository Merge
Regenerating the Siebel Repository Definition Files
Creating a New Siebel Repository File
Back to top
Performing the Siebel Incremental Repository Merge
About the Siebel Incremental Repository Merge
Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x
Before You Begin
Performing the Incremental Repository Merge
Executing the Incremental Repository Merge Under UNIX
Editing the Siebel Tools Configuration File After the Development Environment Merge
Back to top
Generating the Siebel Upgrade Files
About Generating the Upgrade Files
Process of Generating the Upgrade Files
Required 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
Preparing the Additive Schema SQL and JCL Templates
Applying the Additive Schema Changes to the Production Staging Database
Preparing for Table Creation on the Staging Database
Preparing and Executing the Nonadditive Schema and JCL Files on the z/OS Host
Transferring the Nonadditive Schema, Temp Table, and Load and Unload Files to the z/OS Host
Preparing the Nonadditive Schema SQL and JCL Templates and Executing the DDL
Applying the Nonadditive 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
Dropping Partitioned EIM Tables
Creating and Loading Siebel Log Tables
Applying Additive Upgrade Changes to the Target Database
Renaming the Production Environment Repository
Performing the In-Place Target Database Upgrade
Preparing the Target Database for the Upgrade
Running the PRET Jobs for the Target Database
Applying Nonadditive Schema Upgrade Changes to the Target Database
Creating and Deploying Stored Procedures on the Target Database
Migrating Data on the Target Database
Creating Schema Indexes
Running the Gen_Primary SQL to Update Data in Target Database Tables
Generating RUNSTATS Jobs
Restarting Upgrade Jobs That Fail
Back to top
Performing Postupgrade Tasks on the Target Database
Transferring the Development Environment Upgrade Output Files to the z/OS Host
Synchronizing the Schema
Installing New License Keys After an 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 Siebel Database and File System
Updating File System Attachments
Reapplying Schema Customizations to the Siebel Database
Regenerating the Database Template File
Back to top
Postupgrade Tasks for Siebel Business Applications
Performing Postupgrade Tasks for the Siebel Application
Upgrading Siebel Seeded 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 the Upgrade to Siebel CRM
Denormalized Columns for Siebel Industry Applications Version 7.5.3
Back to top
Upgrade Files for Siebel Business Applications
Siebel CRM z/OS Upgrade Files
Tables Amended During PRET Unload Processing
PRET Members Generated By Pretedit.txt
Target Tables Amended During PRET Processing
Back to top
|