Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390
What's New in This Release
Back to top
Preparing to Deploy Siebel on DB2 for z/OS and OS/390
Back to top
Security Concepts for z/OS and OS/390
About Siebel Application Data Security
Operating System Security
Password Change and Expiration
Changing Passwords from Remote Clients
z/OS and OS/390 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
About System Connectivity Architecture
Connecting to the Database Using DB2 Connect
Installing Required IBM Fix Packs
Setting Up DB2 Connect
Configuring DB2 Connect EE or UE to Support Siebel Web Client
Configuring DB2 Connect EE to Support Siebel Dedicated Web Client
Configuring DB2 Connect PE to Support Siebel Dedicated 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 Subsystem
About Unicode Conversion Tables
Choosing the Database CCSID
Using the Data Distribution Facility and 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 Database Server File Installation
About the Siebel Storage Control File Templates
About Siebel Objects
About Substituting Values Using Symbolic Variables
About Default Objects in Storage Control Files
About Buffer Pools Used in Storage Control File Templates
About Using Storage Groups
About Databases in Storage Control Files
About Tables in Storage Control Files
About Table Spaces in Storage Control Files
About Object Naming Conventions
About Table Space Naming Conventions
About Creating or Modifying the Database Layout
About the Siebel Database Storage Configurator
Back to top
Understanding Siebel Partitioning
About Siebel Partitioning
Partitioning Strategy for Storage Control Files
About Configuring Siebel Templates for Partitioning
About Partitioning Tables
About Methods Used for Partitioning
Scenario for Partitioning
About Changing Partitioning Keys
Strategies for Special Types of Tables
About the Siebel Remote Transaction Logging Table
Partitioning S_ESCL_REQ and S_ESCL_LOG Tables
Partitioning EIM Tables for Performance
About EIM Considerations for Table Space Partitioning
About Prepartitioned Siebel Tables
Back to top
Installing the Siebel Database Server Files at Midtier
About File Installation at Midtier
About the Siebel Database Server
Preinstallation Tasks for the Siebel Database Server
Siebel Database Server Software Installation
Installing the Database Server Software Under Windows
Installing the Database Server Software Under UNIX
Reviewing the Software Installation for DB2 UDB for z/OS and OS/390
Back to top
Siebel Schema Installation on the DB2 Host
About Installing the Siebel Schema 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
Preparing the Database Layout
Extracting a Storage Control File from the DB2 Catalog
Validating the Storage Control File
Using the Siebel Database Storage Configurator
Configuring a Siebel Storage Control File
Creating and Executing the DDL
Moving DDL Files to the S/390 or zSeries Machine
Splitting the DDL Job
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
About the Database Server Installation and Configuration
Importing and Exporting the Siebel Repository
Reviewing the Log Files for Repository Import
About Acceptable Errors on the errors.rtf File
Troubleshooting the Repository Import
Postinstallation Tasks for the Siebel Repository
Granting Table Privileges
Loading Statistics
Validating the Siebel Schema
Installing Multilingual Seed Data
Populating the Siebel File System
Back to top
Customizing a Development Environment
About Customizing Your Development Environment
Siebel Tools Considerations on DB2 UDB for z/OS and OS/390
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
LONG Columns on DB2 UDB for z/OS and OS/390 and Other DBMS Platforms
Changing LONGVARCHAR Datatype to VARCHAR Datatype
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
How to Spool DDL Generated by the Apply Button
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 z/OS and OS/390 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
About DB2 Statistics for Siebel eBusiness Applications
About Reorganizing Table Spaces, Partitions, and Indexes
About Cursor Close
About Cursor Operation in Unrestricted and Restricted Modes
Modifying the Cursor Close Alert Message
Cursor Close Ignored
About Cursor Configuration Parameter Values
Setting Database Connection Pooling
About Siebel Dynamic SQL
About Spooling SQL Within the Siebel Application
Enabling DB2 CLI Tracing
Enabling ODBC Tracing
Enabling SQL Tracing for Database Utilities
About SQL Tracing on the DB2 Host Using Tools Like DB2 Performance Monitor
About a RLF Error Message
Using odbcsql to Submit SQL Statements
About DB2 Dynamic Statement Caching
About Tracing the Source of a Query
About Coordinated Universal Time and DB2 UDB for z/OS and OS/390
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
Back to top
Deployment Planning Worksheet
Master Worksheet
Team Lead Summary
DB2 Connect Information
Siebel Database Server Installation Information
Back to top
|