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
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 Siebel 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 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 6.x, 7.0.x, and 7.5.2
Roadmap for Upgrading from Siebel CRM Releases 7.x and 8.0.x
Roadmap for Upgrading from Siebel CRM Releases 7.x and 8.0.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 Version 8.1 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
Back to top
Basic Database Preparations for a Siebel Upgrade
Verifying Database Configuration
Creating Storage Groups
Updating Group Names
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
Converting LONG VARCHAR Columns to CLOB Columns
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
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 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 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
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
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
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 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
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 8.1 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
Performing Intersection Table Maintenance
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 Upgrade to Siebel CRM 8.1
Denormalized Columns for Siebel Industry Applications Version 7.5.3
Back to top
Upgrade Files for Siebel Business Applications Version 8.1
Siebel CRM Version 8.1 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
|