Contents

• Title and Copyright Information
• Preface

1 What’s New in This Release

• What’s New in Implementing Siebel Business Applications on DB2 for z/OS, Siebel CRM 21.3 Update
• What’s New in Implementing Siebel Business Applications on DB2 for z/OS, Siebel CRM 20.1 Update
• What’s New in Implementing Siebel Business Applications on DB2 for z/OS, Siebel CRM 19.1 Update

2 Preparing to Deploy Siebel CRM on DB2 for z/OS

• Preparing to Deploy Siebel CRM on DB2 for z/OS
• About Deploying Siebel CRM on DB2 for z/OS
• Preparing to Deploy Siebel CRM on DB2 for z/OS
• About the Deployment Planning Worksheet
• About File Path and Directory Naming Conventions

3 Security Concepts for a DB2 for z/OS Environment

• 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
    • SYSADM Privileges Used for Connecting to DB2
    • DBADM/CREATEDBA Privileges Used for Connecting to DB2
  • Granting SELECT Authority to Access the DB2 Catalog
  • Granting Authorization to Views in DB2
• Required Authorizations
  • DB2 Authorizations Required
  • Siebel Database Account Authorizations

4 Preparing for Implementation on the DB2 Host

• Preparing for Implementation on the DB2 Host
• About System Connectivity Architecture
• About Connecting to the Database Using DB2 Connect
  • Configuration Options for 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
    • Testing the Database Connection in a Windows Environment
    • Testing the Database Connection in a UNIX Environment
  • 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
    • About Connection Concentration
    • Enabling Connection Concentration
    • Setting the MAXAGENTS Parameter Value
  • 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 Setting the CCSID
  • About Data Distribution Facility and Workload Manager
  • DSNZPARM Parameter Settings for Siebel CRM
    • PADIX Considerations
    • NUMLKUS Considerations
    • IDTHTOIN Considerations
• Estimating the Storage Space Required
• Allocating Space for Buffer Pools and Storage Groups
• Estimating the Number of Database Objects You Need

5 Configuring the Siebel Database Layout

• Configuring the Siebel Database Layout
• Control Files Used in the Siebel CRM 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
    • Naming Conventions for Auxiliary Objects
    • Naming Conventions for Partitioning Triggers
• 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
    • Validating Your Work
  • Working with CLOBs Using the Database Storage Configurator

6 About Siebel Table Partitioning

• 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 Choosing a Clustering Index
    • About Using Partitioning 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 the DDL for the Partitioned Table Space
  • Example of a Partition Definition
    • PartitionBase Definition
    • PartitionPart Definition
    • Example of the DDL for a Partitioned Table
• Partitioning Strategies for Special Types of Tables
  • Siebel Remote Transaction Logging Tables
    • Turning Off Transaction Logging
  • S_ESCL_REQ and S_ESCL_LOG Tables
  • EIM Tables and Partitioning
    • Example of Using a Non-U1 Partitioning Index
• Prepartitioned Siebel Tables
• Partitioning Tables and Indexes Using the Database Storage Configurator
  • Partitioning a Table
  • Changing the Number of Table Space Partitions

7 Installing the Siebel Database on the DB2 Host

• 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 on Microsoft Windows
  • Running the Database Configuration Wizard on UNIX
• Roadmap for Installing the Siebel Database
• Required Tasks before the Siebel Database Installation
• About the Database Installation Option
  • About Database Installation Modes
  • About Database Installation Mechanisms
  • Installing a New Database Language
• About Standard Installations
• Performing a Standard Installation
• Completing the Siebel Schema Installation Using Generated DDL
  • Applying Installation DDL on the DB2 Host
    • Transferring the DDL Files to the DB2 Host
    • Applying the DDL Files 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
  • About the State Log File
  • About Process Log Files
• Reviewing the Log Files for Errors
  • About Identifying Errors Returned by Applications
• Rerunning the Installation

8 Importing the Repository and Performing Postinstallation Tasks

• 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
  • Discrepancies in the dbchck Log
• Populating the Siebel File System
• Installing License Keys
• Installing Multilingual Seed Data
• Importing a New Language to Your Repository

9 Customizing a Development Environment

• 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
  • About Long Columns and Siebel Utilities
• How Siebel Tables with LONG Columns Are Stored
  • About Moving Tables With LONG columns to Larger Table Spaces
  • Determining the Table Space Size for Tables with LONG Columns
  • Moving Tables Between Table Spaces
    • Example of Moving a Table to a Table Space of a Different Size
• About Siebel Tables and CLOB Columns
  • Siebel Tables with LONG Columns That Are Created as CLOBs
  • Siebel Tables Defined with CLOB Columns
  • About Defining New Extension Columns as CLOB Data Types
  • Converting LONG VARCHAR Columns to CLOB Columns
  • Issues in Using CLOB Columns Instead of LONG VARCHAR 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
  • Spooling DDL Generated by the Apply Button
• 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
  • Generating a DDL File from a Storage Control File
• About Data Migration
• Customizing Applications Using Assignment and Workflow Rules

10 Maintaining Siebel CRM Applications on DB2 for z/OS

• Maintaining Siebel CRM Applications on DB2 for z/OS
• DB2 Statistics for Siebel CRM
  • About the RUNSTATS Utility
  • When to Use the DSTATS Utility
• 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
    • Setting the Cursor Configuration Parameter for the Siebel Web Client and Siebel Servers
    • Setting the Cursor Configuration Parameter for the Siebel Developer Web Client and Siebel Mobile Web Client
    • Using Siebel Tools to Bypass the Number of Rows Returned
• Database Connection Pooling
  • About Database Connection Pooling
  • About Connection Pooling and Cursor Close
• Dynamic SQL in the Siebel Application
  • About Spooling SQL in the Siebel Application
    • Turning on SQL Spooling for the Application Object Manager and the Database Connector
  • About Tracing SQL Generated by the Siebel Application
    • Enabling DB2 CLI Tracing
    • About Enabling ODBC Tracing
    • Enabling SQL Tracing for Siebel Database Utilities
    • About SQL Tracing on the DB2 Host
  • 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

11 Migrating a Siebel Database to Unicode Format

• Migrating a Siebel Database to Unicode Format
• About Migrating a Siebel Database to Unicode Format
  • About Unicode Storage Requirements
  • About the NOT PADDED Clause
    • Differences Between ASCII, EBCDIC and Unicode Sort Order
• 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
  • Resubmitting Cross Loader Jobs
  • Recovering from Cross Loader Column Length Errors
• Viewing the Log File

12 Migrating Data Using Siebel Enterprise Integration Manager

• 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
    • About Deciding What Data to Import
  • MS_IDENT Column for DB2 for z/OS
    • How to Presort Data During an Initial Load
  • 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
    • Unused, Nonunique Indexes
    • Unused Triggers
    • Free Space Parameters
    • Insert Performance on Base Tables
    • Transaction Logging
• Resolving Performance Degradation During the Load Process
• Resolving Errors in the EIM Process

13 Deployment Planning Worksheet

• Deployment Planning Worksheet
• Team Lead Summary
• DB2 Connect Information
• Siebel Database Installation Information