Implementing Siebel Business Applications on DB2 for z/OS
What's New in This Release
Back to top
Preparing to Deploy Siebel Business Applications on DB2 for z/OS
About Deploying Siebel Business Applications on DB2 for z/OS
Preparing for a Siebel Application Deployment on DB2 for z/OS
About the Deployment Planning Worksheet
About File Path and Directory Naming Conventions
Back to top
Security Concepts for a DB2 for z/OS Environment
About Siebel Application Data Security
Operating System Security
User Password Change and Expiration
About Changing z/OS Passwords from Client Computers
DB2 z/OS Authorization IDs
About Using a Secondary Authorization ID
About Using an External Security Adapter on z/OS
Data Transmission Security for Siebel Clients
Roles and Permissions Used to Connect to DB2
Granting SELECT Authority to Access the DB2 Catalog
Granting Authorization to Views in DB2
Required Authorizations
Back to top
Preparing for Implementation on the DB2 Host
About System Connectivity Architecture
About Connecting to the Database Using DB2 Connect
About the Required IBM Fix Packs
Process of Setting Up DB2 Connect
Configuring DB2 Connect EE, ASE or UE to Support Siebel Web Client
Configuring DB2 Connect EE, ASE or UE to Support Siebel Developer Web Client
Configuring DB2 Connect PE to Support Siebel Developer Web Client
Performing Postinstallation Tasks for DB2 Connect
Defining a Database Alias and Testing a Connection
Binding the DB2 Connect Packages
Configuring DB2 Connect
Setting the DB2CONNECT_IN_APP_PROCESS Environment Variable
Setting the DB2CONNECT_ENABLE_EURO_CODEPAGE Environment Variable
Setting DB2 Connect EE Configuration Options
Tuning DB2 Connect by Increasing the I/O Block Size
About Setting Up the DB2 Subsystem
Advantages of Using a Separate DB2 Subsystem
About Unicode Character Conversions on z/OS
Considerations in Choosing the Database CCSID
About Data Distribution Facility and Workload Manager
DSNZPARM Parameter Settings for Siebel Business Applications
Estimating the Storage Space Required
Allocating Space for Buffer Pools and Storage Groups
Estimating the Number of Database Objects You Need
Back to top
Configuring the Siebel Database Layout
Control Files Used in the Siebel Installation
About Storage Control File Templates
About Siebel Objects
Symbolic Variables in Storage Control Files
Default Objects in Storage Control Files
Buffer Pools Used in Storage Control Files
About Using Storage Groups
Database Objects in Storage Control Files
Table Objects in Storage Control Files
Table Space Objects in Storage Control Files
Object Naming Conventions
Table Space Naming Conventions
About Modifying the Database Layout
About Modifying Storage Control Files
Using the Siebel Database Storage Configurator
Modifying a Storage Control File Using the Database Storage Configurator
Working with CLOBs Using the Database Storage Configurator
Back to top
About Siebel Table Partitioning
About Siebel Partitioning
About Partitioning Keys
Partitioning and the Storage Control Files
Considerations in Partitioning Tables
About Choosing a Partitioning Key Column
About Table-Controlled Partitioning and Using Indexes
About Table Partitioning Methods
Partitioning Based on Business Data
Partitioning for Even Data Distribution
Example of Partitioning the S_ADDR_ORG Table
Example of a Table Object Definition
Example of a Table Space Definition
Example of Definitions for Table Space Partitions
Example of a Partition Definition
Partitioning Strategies for Special Types of Tables
Siebel Remote Transaction Logging Tables
S_ESCL_REQ and S_ESCL_LOG Tables
EIM Tables and Partitioning
Prepartitioned Siebel Tables
Partitioning Tables and Indexes Using the Database Storage Configurator
Back to top
Installing the Siebel Database on the DB2 Host
About the Siebel Database and the Database Configuration Utilities
Running the Database Configuration Wizard
Running the Database Configuration Wizard Under Windows
Running the Database Configuration Wizard Under UNIX
Roadmap for Installing the Siebel Database
Required Tasks before the Siebel Database Installation
About the Database Installation Option
About Standard Installations
Performing a Standard Installation
Completing the Siebel Schema Installation Using Generated DDL
Applying Installation DDL on the DB2 Host
Setting Up the SQL Delimiter on DB2
Deploying User-Defined Functions
Process of Performing a Custom Installation
Preparing a Storage Control File
Extracting a Storage Control File from the DB2 Catalog
Validating an Extracted or Modified Storage Control File
Performing a Custom Installation
About the Siebel Log Files
Reviewing the Log Files for Errors
Rerunning the Installation
Back to top
Importing the Repository and Performing Postinstallation Tasks
Process of Completing the Siebel Database Implementation
Importing the Siebel Repository
Granting Table Privileges
Validating the Siebel Schema
Populating the Siebel File System
Installing License Keys
Installing Multilingual Seed Data
Importing a New Language to Your Repository
Back to top
Customizing a Development Environment
About Customizing Your Development Environment
About Using Siebel Tools in a DB2 for z/OS Environment
Siebel Tools Configuration File Parameters
Setting Database Options
Storage Control File Names
About Inactivating Unused Indexes
About Reducing VARCHAR Field Lengths
About Siebel LONG Columns on DB2 for z/OS
How Siebel Tables with LONG Columns Are Stored
Determining the Table Space Size for Tables with LONG Columns
Moving Tables Between Table Spaces
About Siebel Tables and CLOB Columns
About Defining New Extension Columns as CLOB Data Types
Converting LONG VARCHAR Columns to CLOB Columns
Converting Nonpartitioned Tables to Partitioned Tables
About Creating Custom Extensions to the Siebel Schema
Roadmap for Creating Custom Extensions to the Siebel Schema
Amending the Storage Control File for New Schema Objects
Applying Schema Extensions to the Local Development Database
Process of Applying Schema Extensions to the Target Database
Preparing the Target Database
Migrating Customizations from Development to the Target Database
Applying Schema Changes to the Target Database
Synchronizing Siebel Repository Definitions and the Physical Siebel Schema
Cloning a DB2 for z/OS Database
About Data Migration
Applying Schema Changes to Other Local Databases
Customizing Applications Using Assignment and Workflow Rules
Back to top
Maintaining Siebel Business Applications on DB2 for z/OS
DB2 Statistics for Siebel Business Applications
About Reorganizing Table Spaces, Partitions, and Indexes
About Cursor Close
Cursor Close Parameter Values on DB2 for z/OS
Cursor Close Ignored
Modifying the Cursor Close Alert Message
Changing Cursor Configuration Parameter Values
Database Connection Pooling
Dynamic SQL in the Siebel Application
About Spooling SQL in the Siebel Application
About Tracing SQL Generated by the Siebel Application
Long-Running Queries and the RLF Error Message
Using the odbcsql Utility to Submit SQL Statements
Enabling DB2 Dynamic Statement Caching
About Managing the Dynamic Statement Cache
About Invalidating Cached Statements
Tracing the Source of a Query
About Coordinated Universal Time and DB2 for z/OS
Back to top
Migrating a Siebel Database to Unicode Format
About Migrating a Siebel Database to Unicode Format
Roadmap for Migrating the Siebel Database to Unicode
Requirements for Migrating the Siebel Database to Unicode
Converting the Storage Control File to Unicode
Recovering from Buffer Pool Errors
Generating the Unicode Migration Files
Process of Preparing the z/OS Host Environment
Transferring Migration Upgrade Files from the Midtier to the z/OS Host
Creating and Allocating the Setup Data Sets
Defining Environment Variables for the Unicode Migration
Process of Performing the Database Unicode Migration
Building the Target Schema
Building the Unicode Migration Jobs
Submitting the Unicode Migration Jobs
Viewing the Log File
Back to top
Migrating Data Using Siebel Enterprise Integration Manager
About Setting Up EIM for DB2
Choosing an Appropriate Partitioning Scheme
EIM and Table Partitioning
Considerations in Planning Data Mapping
Optimal EIM Batch Size
Optimal Number of Parallel Streams
DB2 Database Logging Performance
RUNSTATS Utility
SQLPROFILE Log
How to Improve EIM Performance When Importing Data
Tuning the EIM Import Process
About Improving EIM Performance During Initial Loads
Resolving Performance Degradation During the Load Process
Resolving Errors in the EIM Process
Back to top
Deployment Planning Worksheet
Team Lead Summary
DB2 Connect Information
Siebel Database Installation Information
Back to top
|