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
About Deploying Siebel Business Applications on DB2 for z/OS
Process of 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 z/OS
About Siebel Application Data Security
Operating System Security
Password Change and Expiration
About Changing Passwords from Client Machines
z/OS Security
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
Installing 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 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 Conversion Tables
Considerations in Choosing the Database CCSID
About the Data Distribution Facility and Workload Manager
DSNZPARM Parameter Settings for Siebel 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 Database Layout
About the Siebel Schema 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
About 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
Understanding Siebel 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 Methods Used for Partitioning
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 a Tsparts Definition
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
About 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 for the Siebel Database Installation
About the Database Installation Option
About Performing a Standard Installation
Performing a Standard Installation
Completing the Siebel Schema Installation Using Generated DDL
Applying DDL on the DB2 Host
Setting Up the SQL Delimiter on DB2
Deploying User-Defined Functions
Process of Performing a Custom Installation
Preparing the Storage Control File
Extracting a Storage Control File from the DB2 Catalog
Validating the Extracted 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 Siebel 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
Siebel Tools Considerations on DB2 for z/OS
Siebel Tools Configuration File Parameters
Setting Database Options
Storage Control File Names
About Inactivating Unused Indexes
About Reducing VARCHAR Field Lengths
How Siebel Implements LONG Columns on DB2 for z/OS
About Converting LONG VARCHARs to CLOBs
Changing LONG VARCHAR Data Types to VARCHAR Data Types
Converting Nonpartitioned Tables to Partitioned Tables
About Creating 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 the Repository and the Physical Schema
Process of Cloning a DB2 for z/OS Database
Generating a DDL File from a Storage Control File
About 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
About Spooling SQL in the Siebel Application
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 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
About Migrating a Siebel Database to Unicode Format
Obtaining the Unicode Migration Files
About Migrating to a Siebel Unicode Database
About Unicode Storage Requirements
Differences Between ASCII, EBCDIC and Unicode Sort Order
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
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 Installation Information
Back to top
|