Contents
1 What’s New in This Release
2 About This Guide
- About This Guide
- 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
3 How the Siebel Database Upgrade Works
- How the Siebel Database Upgrade Works
- About Supported Siebel Upgrade Paths
- Supported Upgrade Paths for Siebel CRM
- 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
- About the JCL Upgrade Jobs
- About the Override File
4 Planning a Siebel Database Upgrade
- 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
- Obtaining Required Security Privileges
- Planning Backup and Recovery Stages
- About Creating a Schedule for the Upgrade
- About Estimating Database Size
- Upgrading Your DB2 Software
5 Basic Database Preparations for a Siebel Upgrade
- 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
- Extract from Catalog
- Extract from Catalog and Merge with Template
- Extracting the Storage Control File
- Information Required for the Database Configuration Wizard Extract Option
- Validating the Extracted Storage Control File
- About Validation Errors
- 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
6 Preparing a Development Environment for a Siebel Upgrade
- 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
7 Preparing a Production Environment for a Siebel Upgrade
- 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
8 Performing a Siebel Database Upgrade
- Performing a Siebel Database Upgrade
- Modifying siebel.cfg Before Upgrading Siebel Database
- Creating a New ODBC Data Source Before Upgrading Siebel Database
- Roadmap for Performing a Siebel Database Upgrade
- Process of Planning a Siebel Database Upgrade
- Process of Upgrading a Siebel Development Environment
- Searching for Bulletins and Alerts on My Oracle Support
- Upgrade Third-Party Software
- Upgrade the Servers
- Upgrade the RDBMS
- Preupgrade Tasks for the Siebel Database
- Preupgrade Tasks for a Development Environment Upgrade
- Preupgrade Tasks for Application Data
- Preparing Developers for the Upgrade
- Upgrade Siebel Database Schema (upgrep)
- Prepare for Repository Merge
- Perform Repository Merge
- Upgrade Custom Database Schema (upgphys)
- Review the User Interface
- Postmerge Development Tasks
- Postupgrade Tasks for Database and File System
- Postupgrade Tasks for Applications Configuration
- Perform System Tests
- Prepare for Transition to Production Test Environment
- Process of Upgrading a Production Test Environment
- Searching for Bulletins and Alerts on My Oracle Support
- Upgrade Third-Party Software
- Upgrade the Servers
- Upgrade the RDBMS
- Preupgrade Tasks for the Siebel Database
- Preupgrade Tasks for Application Data
- Preupgrade Tasks for a Production Test Environment Upgrade
- Prepare for Production
- Upgrade the Siebel Database Schema (upgrep + upgphys)
- Postupgrade Tasks for Database and File System
- Postupgrade Tasks for Siebel Application Configuration
- Perform System Tests
- Process of Tuning the Upgrade Performance
- Process of Upgrading a Siebel Production Environment
- Searching for Bulletins and Alerts on My Oracle Support
- Upgrade Third-Party Software
- Upgrade the Servers
- Upgrade the RDBMS
- Preupgrade Tasks for the Siebel Database
- Preupgrade Tasks for Application Data
- Preupgrade Tasks for a Production Environment Upgrade
- Upgrade the Siebel Database Schema (upgrep + upgphys)
- Postupgrade Tasks for Database and File System
- Postupgrade Tasks for Applications Configuration
- Perform System Tests
- Deploy to Users
- Siebel Database Update Process
- Post Installation Database Update
- Values Required by Post Installation Database Update
- Database Configuration in Siebel Enterprise Server Installer
- Troubleshooting Database Configuration
- Postpone Running Post Installation Database Update
- Skip Post Installation Database Update
- Post Installation Database Update Report
- Post Installation Database Update Exit Codes
- Logging and Diagnostics
- Rerunning Post Installation Database Update
- How PostInstallDBSetup Fully Workspace Enables List of Values
- RepositoryUpgrade Utility
9 Running the Database Configuration Wizard
- Running the Database Configuration Wizard
- Example of a Siebel Development Environment Upgrade Flow
- 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
- Upgrading the Repository and Importing Seed Data
- Fixing Column Alignment for Custom Objects
- Inactivating Unreferenced Repository Objects
- Converting Siebel Web Templates with the SWT to OD Conversion Utility
10 Creating the Siebel Staging Database
- 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
- Removing Interface Tables and Triggers
11 Generating the Siebel Upgrade Files
- 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
- 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
- Processing the Index Schema File
- Building JCL Templates for the Target Database
12 Upgrading the Target Database
- 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
- Accessing the Target Database In-Place Upgrade Menu
- 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
13 Performing Postupgrade Tasks on the Target Database
- Performing Postupgrade Tasks on the Target Database
- Transferring the Development Environment Upgrade Output Files to the z/OS Host
- Synchronizing the Schema
- Activating New License Keys After an Upgrade
- Deleting Redundant Upgrade Files
14 Reviewing the Siebel Upgrade Log Files
- 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
15 Performing the Siebel Repository Merge
- 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
- Generating the Runtime Repository Data
16 Performing the Siebel Incremental Repository Merge
- Performing the Siebel Incremental Repository Merge
- About the Siebel Incremental Repository Merge
- Process of Performing Incremental Upgrade of Siebel Database from Siebel CRM 8.1.1.x
- Before You Begin
- Performing the Incremental Repository Merge
- Editing the Siebel Tools Configuration File After the Development Environment Merge
17 Postupgrade Tasks for Siebel Database and File System
- Postupgrade Tasks for Siebel Database and File System
- Updating File System Attachments
- Reapplying Schema Customizations to the Siebel Database
- Regenerating the Database Template File
18 Postupgrade Tasks for Siebel Business Applications
- Postupgrade Tasks for Siebel Business Applications
- Performing Postupgrade Tasks for the Siebel Application
- Upgrading Siebel Seeded Workflows
19 Tuning the Siebel Production Upgrade Scripts
- Tuning the Siebel Production Upgrade Scripts
- About Tuning the Upgrade Scripts
- Optimizing Unload and Load Job Performance
- Adding the Statistics Clause to Load Cards
20 Migration Planning Using Siebel Migration
- Migration Planning Using Siebel Migration
- About Migrating with Siebel Migration
- Roadmap for Planning a Migration with Siebel Migration
- About Migration Process Orchestration During the Siebel Migration Process
- About the Process Flow for Migration Resources
- About the Siebel Migration Log Files
- About REST API Used for Migration Discovery and Execution
21 Data Preparation for Siebel Migration
- Data Preparation for Siebel Migration
- Process of Preparing Siebel Application Data for Migration
- Process of Transforming Data with Siebel Application Deployment Manager
- Customizing Siebel Migration Execution and Resource Sequencing
- Setting Up File Prepare and Deploy
22 Data Migration Using Siebel Migration
- Data Migration Using Siebel Migration
- Before You Begin Migrating with Siebel Migration
- Process of Using Siebel Migration to Migrate Data
- Asynchronous Migration Using Siebel Migration
- Incremental Migration from Development to Production Environment Without Using Siebel Migration
- Full Runtime Repository Migration Without Using Siebel Migration
- Migrating Repository Changes from Development to Production Environment (Siebel CRM 18.8 or Later)
- Migrating Configuration Data and Incremental Changes
- Managing Cross Version Migration
- Troubleshooting Data Migration Using Siebel Migration
23 Siebel Upgrade Planning Worksheet
- Siebel Upgrade Planning Worksheet
- Team Lead Summary
- DB2 Connect Information
- Siebel Development Environment Information
- Siebel Production Environment Information
- z/OS Host System Variables Information
24 Columns Denormalized During the Upgrade to Siebel CRM
- Columns Denormalized During the Upgrade to Siebel CRM
- Denormalized Columns for Siebel Industry Applications Version 7.5.3
25 Upgrade Files for Siebel Business Applications
- 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
26 REST API References for Migration Services
- REST API References for Migration Services
- Using REST API with the Migration Schema Service
- Using REST API with the Migration Application Data Service
- Using REST API with the Migration Data Service with Transformation Service
- Using REST API with the Migration Incremental Runtime Repository Data Service
- Getting a Watermark with the Migration Incremental Runtime Repository Data Service
- Exporting with the Migration Incremental Runtime Repository Data Service
- Getting Status with the Migration Incremental Runtime Repository Data Service
- Importing with the Migration Incremental Runtime Repository Data Service
- Checking a Database with the Migration Incremental Runtime Repository Data Service
- Using REST API with the Migration Runtime Repository Data Service
- Getting Runtime Repository Information with the Migration Runtime Repository Data Service
- Getting a Watermark with the Migration Runtime Repository Data Service
- Exporting with the Migration Runtime Repository Data Service
- Getting Status with the Migration Runtime Repository Data Service
- Importing with the Migration Runtime Repository Data Service
- Checking a Database with the Migration Runtime Repository Data Service
- Using REST API with the Migration Incremental Application Workspace Data Service
- Getting Status with the Migration Incremental Application Workspace Data Service
- Getting a Watermark with the Migration Incremental Application Workspace Data Service
- Exporting with the Migration Incremental Application Workspace Data Service
- Importing with the Migration Incremental Application Workspace Data Service
- Invalidating Seed Caches with the Migration Incremental Application Workspace Data service
- Using REST API with Migration Application Workspace Data Service
- Getting a Seed Copy Watermark with the Migration Application Workspace Data Service
- Getting the Full Seed Watermark with the Migration Application Workspace Data Service
- Getting Status with the Migration Application Workspace Data Service
- Getting a Seed Copy Export with the Migration Application Workspace Data Service
- Getting a Seed Copy Import with the Migration Application Workspace Data Service
- Getting the Full Seed Export with the Migration Application Workspace Data Service
- Getting the Full Seed Import with the Migration Application Workspace Data Service
- Invalidating the Seed Caches with the Migration Application Workspace Data Service
- Using REST API with the Migration File Prepare and Deploy Service
- Exporting with the Migration File Prepare and Deploy Service
- Getting Status with the Migration File Prepare and Deploy Service
- Importing with the Migration File Prepare and Deploy Service
- Generating a Watermark with the Migration File Prepare and Deploy Service
- Reading the Watermark with the Migration File Prepare and Deploy Service
- Writing the Watermark with the Migration File Prepare and Deploy Service
- Using REST API with Siebel Migration Application