Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS


How This Guide Is Organized

Additional Resources

Revision History

Back to top


Siebel Application Data Security

DB2 Operating System Security

Password Change and Expiration

Changing Passwords from Remote Clients

OS/390 and z/OS Security

Using a Group ID

Using an External Security Adapter

Data Transmission Security

Roles and Permissions

Required Authorizations

Back to top

Preparing for Implementation on the DB2 Host

System Connectivity Architecture

Connecting to the Database Using DB2 Connect

Configuration Options for DB2 Connect

Setting Up DB2 Connect

Setting Database Connection Pooling

Verifying Network Connectivity Under Windows

Verifying Network Connectivity Under UNIX

Using Odbcsql to Verify Database Connectivity

Installing Required Fix Packs

Setting Up the Subsystem

Choosing the Database CCSID

Customizing DDF and Setting Up Workload Manager

DSNZPARM Parameters for Setting Up the Subsystem

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 Storage Control File Templates

About Siebel Objects

Symbolic Variables

Default Objects

Buffer Pools

Storage Groups



Table Spaces

Object Naming Conventions

About Creating or Modifying the Database Layout

About the Siebel Database Storage Configurator

Calculating Space

Creating Alter Statements to Adjust Size

Back to top

Understanding Siebel Partitioning

About Siebel Partitioning

Partitioning Strategy

About Configuring Siebel Templates for Partitioning

What to Partition

Partitioning Methods

Scenario for Partitioning

Changing Partitioning Keys

Strategies for Special Types of Tables

Siebel Remote Transaction Logging Table

Assignment Manager and Workflow Tables

EIM Tables

EIM Considerations for Table Partitioning

Prepartitioned Siebel Tables

Back to top

Siebel Database Server File Installation at Midtier

About the Siebel Database Server

Preinstallation Tasks

Siebel Database Server Software Installation

Installing the Database Server Software Under Windows

Installing the Database Server Software Under UNIX

Reviewing the Software Installation

Windows Installation Directory

UNIX Installation Directory

Back to top

Siebel Schema Installation on the DB2 Host

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

Validating Siebel Schema Creation

Preparing the Database Layout

Extracting a Storage Control File from the DB2 Catalog

Validating the Storage Control File

Using the Siebel Database Storage Configurator

Creating and Executing the DDL

Moving DDL Files to the S/390 or zSeries Machine

Splitting the DDL

Executing Alter Statements

Performing a Custom Installation

Performing a Custom Installation Under Windows

Reviewing the Log Files for Windows

Performing a Custom Installation Under UNIX

Reviewing the Log Files for UNIX

Rerunning the Installation

Back to top

Siebel Repository Import, Export, and Postinstallation Tasks

Importing and Exporting the Siebel Repository

Reviewing the Log Files for Repository Import

Troubleshooting the Repository Import

Postinstallation Tasks

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

Siebel Tools Considerations

Setting Siebel Tools Configuration File Parameters

Setting Database Options

Specifying Table Grouping File Names

Inactivating Unused Indexes

Reducing Field Lengths of Unique Indexes to Avoid Truncation

Reducing VARCHAR Field Lengths

Using Character Large Objects (CLOBs)

Converting Nonpartitioned Tables to Partitioned Tables

Creating Custom Extensions to the Siebel Schema

About Schema Extension Tasks

Creating Storage Control File Objects for New Schema Objects

Applying Schema Extensions to the Development Database

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

Cloning an OS/390 or z/OS Database

Migrating Rules and Other Data

Applying Schema Changes to Other Local Databases

Customizing Applications Using Assignment and Workflow Rules

Back to top

Maintenance Considerations for zSeries

Reorganizing Table Spaces, Partitions, and Indexes

Updating Statistics

About Cursor Close

Back to top

Migrating Data Using Siebel EIM

Setting Up EIM for DB2

Choosing an Appropriate Partitioning Scheme

Considering the Effect of EIM on Table Partitioning

Planning Data Mapping

Choosing an Optimal EIM Batch Size

Choosing an Optimal Number of Parallel Streams

Optimizing DB2 Database Logging

Using the RUNSTATS Utility

Reviewing the SQLPROFILE Log

Improving EIM Performance During the Import Process

Using the Default Column to Improve Throughput

Tuning Your EIM Import Process

Initial Load Considerations

Considerations for EIM Tables

Updating the S_LST_OF_VAL Table

Resolving Performance Degradation During the Load Process

Resolving Errors in the EIM Process

Back to top

Deployment Planning Worksheet

Master Worksheet

Team Lead Summary

DB2 Connect Information

Siebel Database Server Installation Information

Back to top

Optimizing Performance with Buffer Pools

Zeroing the Buffer Pools

Changing the Buffer Pools to Data Spaces

Setting the Buffer Pool Sizes

Altering the Buffer Pool Thresholds

Altering the Objects

Stopping and Restarting the Databases

Back to top

 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003