Implementing Siebel Business Applications on DB2 UDB for z/OS
What's New in This Release
Back to top
Preparing to Deploy Siebel on DB2 for z/OS
Process of Preparing for a Siebel Application Deployment on DB2 for z/OS
Back to top
Security Concepts for z/OS
About Siebel Application Data Security
Operating System Security
Password Change and Expiration
Changing Passwords from Remote Clients
z/OS Security
Using a Secondary Authorization ID
About Using an External Security Adapter
Data Transmission Security for Siebel Clients
Roles and Permissions Used to Connect to DB2
Granting SELECT Authority to Access the DB2 Catalog
Required Authorizations
Back to top
Preparing for Implementation on the DB2 Host
System Connectivity Architecture
Connecting to the Database Using DB2 Connect
Installing Required IBM Fix Packs
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
Additional Postinstallation Steps for DB2 Connect
Defining a Database Alias and Testing a Connection
Binding the DB2 Connect Packages
Configuring DB2 Connect for DB2 Connect Enterprise Edition Only
Setting Up the DB2 Subsystem
Advantages of Using a Separate DB2 Subsystem
About Unicode Conversion Tables
Considerations in Choosing the Database CCSID
The Data Distribution Facility and Workload Manager
DDSNZPARM Parameter Settings for Siebel Applications
Required DSNZPARM Parameter Settings
Recommended DSNZPARM Parameter Settings
Estimating the Storage Space Required
Allocating Space for Buffer Pools and Storage Groups
Planning the Distribution of Database Objects
Estimating the Number of Database Objects You Need
Back to top
Configuring the Database Layout
About the Siebel Database Server Installation
Siebel Storage Control File Templates
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 Creating or Modifying the Database Layout
Modifying the Storage Control File
Back to top
Understanding Siebel Partitioning
About Siebel Partitioning
About Partitioning Indexes and Keys
Partitioning and the Storage Control Files
Considerations in Partitioning Tables
Methods Used for Partitioning
Example of Partitioning: the S_ADDR_ORG Table
Example of a Table Object Definition
Example of a Tablespace Definition
Example of a Tsparts Definition
Example of an Index Definition
Performance Overhead of Using a Trigger
About Changing Partitioning Keys
Partitioning Strategies for Special Types of Tables
The Siebel Remote Transaction Logging Table
The S_ESCL_REQ and S_ESCL_LOG Tables
EIM Tables and Partitioning
Prepartitioned Siebel Tables
Back to top
Installing the Siebel Database Server Files at Midtier
About the Siebel Database Server
Process of Installing the Database Server
Preinstallation Tasks for the Siebel Database Server
Installing the Database Server Software Under Windows
Installing the Database Server Software Under UNIX
Reviewing the Software Installation for DB2 for z/OS
Back to top
Installing the Siebel Schema on the DB2 Host
Process of Installing the Siebel Schema
About Installing the Siebel Schema
Performing a Standard Installation
Performing a Standard Installation Under Windows
Performing a Standard Installation Under UNIX
Applying DDL on the DB2 Host
Setting Up the SQL Delimiter on DB2
Validating Siebel Schema Creation
Deploying User-Defined Functions
Preparing for a Custom Installation
Extracting a Storage Control File from the DB2 Catalog
Validating the Extracted Storage Control File
Modifying Storage Control Files Using the Database Storage Configurator
Partitioning Tables and Indexes Using the Database Storage Configurator
Working with CLOBs Using the Database Storage Configurator
Process of Performing a Custom Installation
Performing a Custom Installation Under Windows
About Reviewing the Log Files for Windows
Acceptable Errors and the errors.rtf File
Performing a Custom Installation Under UNIX
About Reviewing the Log Files for UNIX
Rerunning the Installation
Back to top
Siebel Repository Import and Postinstallation Tasks
Process of Completing the Database Server Installation
Importing the Siebel Repository
About Reviewing the Log Files for Repository Import
Postinstallation Tasks for the Siebel Repository
Granting Table Privileges
Loading Statistics
Validating the Siebel Schema
Installing Multilingual Seed Data
Importing a New Language to Your Repository
Populating the Siebel File System
Back to top
Customizing a Development Environment
About Customizing Your Development Environment
Siebel Tools Considerations on DB2 for z/OS
Siebel Tools Configuration File Parameters
Setting Database Options
Storage Control File Names
About Inactivating Unused Indexes
Truncation of Unique Index Columns
About Reducing VARCHAR Field Lengths
How Siebel Systems Implements LONG Columns on DB2 for z/OS
About Using Character Large Objects (CLOBs)
Changing LONGVARCHAR Data Type to VARCHAR Data Type
Converting Nonpartitioned Tables to Partitioned Tables
Custom Extensions to the Siebel Schema
Process of Extending the Siebel Schema
Storage Control File Object Definitions for New Schema Objects
Applying Schema Extensions to the Development Database
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 Schema Definitions with the Existing Siebel Schema
Process of Cloning a DB2 for z/OS Database
Generating a DDL File from a Storage Control File
Data Migration
Applying Schema Changes to Other Local Databases
Application Customization Using Assignment and Workflow Rules
Back to top
Maintenance Considerations 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
Advantages of Spooling SQL in the Siebel Application
About Tracing SQL Generated by the Siebel Application
Enabling DB2 CLI Tracing
How to Enable ODBC Tracing
Enabling SQL Tracing for Database Utilities
About SQL Tracing on the DB2 Host
About the RLF Error Message
Using odbcsql to Submit SQL Statements
Enabling DB2 Dynamic Statement Caching
About Managing the Dynamic Statement Cache
How to Invalidate Cached Statements
Tracing the Source of a Query
About Coordinated Universal Time and DB2 for z/OS
Back to top
Migrating Data Using Siebel EIM
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
The RUNSTATS Utility
The SQLPROFILE Log
How to Improve EIM Performance When Importing
Tuning the EIM Import Process
How to Improve EIM Performance During Initial Loads
Considerations for EIM Tables
Back to top
Deployment Planning Worksheet
Team Lead Summary
DB2 Connect Information
Siebel Database Server Installation Information
Back to top
|