Siebel 7.8 with IBM DB2 UDB V8.2 Handbook

Siebel 7.8 with IBM DB2 UDB V8.2 Handbook

by Whei-Jen Chen, Priti Desai, Ujwala Devi, Sreeman Kancherla, Venkatram Menakuru, Raghu Ramaswamy, Scott Saunders, Arjun Sirohi
Released November 2005
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

This IBM Redbooks publication delivers details about DB2 UDB V8.2 on Siebel 7.8. It outlines the partnership between Siebel Systems and IBM and the benefits of using DB2 UDB to support the Siebel Enterprise. The most commonly used components of the Siebel Enterprise and the DB2 UDB architecture are described.

We provide the planning considerations for running DB2 UDB in Siebel environment. The step-by-step installation and configuration details are followed. We then describe information on methods to populate and maintain data in Siebel tables including data archival techniques and information on ensuring data integrity and data quality.

The database administration, monitoring, and tuning tools provided by DB2 UDB and operating systems are discussed and the tool usage provided. The book also provides in-depth discussion on high availability and disaster recovery options and setup procedure for a Siebel/DB2 UDB environment.

Finally, the book provides information about the components of Siebel Analytics and where these components fit in the overall scheme with Siebel Enterprise.

Table of contents

  1. Figures
  2. Notices
    1. Trademarks
  3. Preface
    1. The team that wrote this redbook
    2. Acknowledgement
    3. Become a published author
    4. Comments welcome
  4. Chapter 1: Introduction
    1. Partnership between IBM and Siebel Systems
      1. Ongoing activities
      2. Recent developments
    2. Benefits of DB2 UDB V8.2 with the Siebel Enterprise
      1. DB2 UDB V8.2 enhancements
  5. Chapter 2: Architecture
    1. Architecture layout of Siebel Enterprise
      1. Siebel Clients
      2. Siebel Web Server Extension
      3. Siebel Enterprise Server
      4. Siebel Server
      5. Siebel Gateway Name Server
      6. Siebel File System
      7. Siebel Database
      8. Siebel Object architecture
    2. DB2 UDB architecture
      1. Architecture overview
      2. Process concepts
      3. Memory concepts
      4. Storage concepts
  6. Chapter 3: Planning considerations
    1. Siebel release matrix for DB2 UDB
      1. IBM DB2 Universal Database™ V8.2 ESE
      2. Operating systems and hardware for DB2 UDB
      3. Siebel Developer Web Client
    2. Siebel sizing considerations
      1. Information requirements
      2. Sizing deliverables
      3. Related reviews
    3. Hardware and storage requirements
      1. Siebel hardware and storage requirements
      2. Considerations for hardware planning
      3. DB2 UDB
    4. Database layout and recommendations
      1. Decision time
      2. Table grouping by Siebel components used
    5. Using Siebel with DB2 UDB 32-bit versus 64-bit
    6. Users and groups
    7. Checklist (1/2)
    8. Checklist (2/2)
  7. Chapter 4: Installation and configuration
    1. Installation flow chart
    2. Lab environment
    3. Installing DB2 UDB and Siebel on AIX
      1. Installation and configuration of DB2 UDB server and client on AIX
      2. Creation of the Siebel installation image
      3. Install and configure the Siebel Application in console mode (1/4)
      4. Install and configure the Siebel Application in console mode (2/4)
      5. Install and configure the Siebel Application in console mode (3/4)
      6. Install and configure the Siebel Application in console mode (4/4)
    4. Installing Siebel on Windows
      1. Installation and configuration of DB2 UDB server on Windows
      2. Creating the Siebel install image
      3. Installation and configuration of Siebel Application on Windows (1/2)
      4. Installation and configuration of Siebel Application on Windows (2/2)
    5. Installation and configuration of DB2 UDB server on Linux
    6. Siebel Developer Web Client
    7. Installation troubleshooting
      1. Environment Verification Tool
      2. Error messages
  8. Chapter 5: Data in a Siebel Enterprise
    1. Governing model for Siebel data
    2. Data loading methods
      1. Enterprise Integration Manager
      2. Enterprise Application Integration
      3. Siebel programming interfaces
      4. Siebel Web Client
    3. Data quality maintenance
      1. Identifying data quality problems
      2. Maintaining data quality
    4. Data archiving
  9. Chapter 6: Database administration
    1. Backup
      1. Logging concepts
      2. Types of backup
      3. Backup command and authorities required
      4. Performing backup on Siebel File System
      5. Backup image file format
      6. DB2 UDB processes related to database backup/restore
      7. Database history file
      8. Backup examples
      9. VLDB backups
    2. Recovery overview
      1. Restore command and authorities required
      2. Rollforward command and authorities required
      3. Recover database command
      4. Database recovery examples
    3. RUNSTATS
    4. DB2 UDB table reorganization
      1. DB2 UDB data reorganization in a Siebel environment
    5. Query control
      1. DB2 Query Patroller
      2. Siebel Query Cancel function
      3. Home-grown query cancel scripts
  10. Chapter 7: Database server monitoring
    1. Tools for monitoring
      1. Snapshot monitor
      2. Event monitor
      3. Explain utilities
      4. DB2 UDB diagnostic log
      5. Health Center/Memory Visualizer/DB2MTRK
      6. Design Advisor
      7. DB2 UDB problem determination utility
    2. DB2 Performance Expert
    3. Tivoli Monitoring
    4. OS monitoring
      1. Monitoring tools on the UNIX platform
      2. Monitoring tools on the Windows platform
  11. Chapter 8: Performance tuning
    1. Performance tuning introduction
    2. Initial DB2 UDB configuration parameter settings
      1. Database manager configuration
      2. Database configuration
      3. DB2 registry variables
    3. Siebel configuration
      1. Siebel configurations for database
    4. Operating system configuration considerations
    5. Tuning the DB2 UDB environment
      1. DB2 UDB registry and environment variables
      2. DB2 UDB database manager parameters
      3. DB2 UDB database parameters
    6. Lock wait/deadlock/lock escalation
      1. Locking issues
      2. Tools used to monitor locking issues
      3. Identifying the lock issues
      4. New feature of DB2 UDB V8.2 in the locking context
    7. Buffer pool
    8. Table space
  12. Chapter 9: High availability and disaster recovery
    1. Components of a Siebel Enterprise
    2. Database server
      1. HA options for DB2 UDB server
      2. Information on the lab environment
      3. Installation and configuration of HACMP on AIX for DB2 UDB (1/5)
      4. Installation and configuration of HACMP on AIX for DB2 UDB (2/5)
      5. Installation and configuration of HACMP on AIX for DB2 UDB (3/5)
      6. Installation and configuration of HACMP on AIX for DB2 UDB (4/5)
      7. Installation and configuration of HACMP on AIX for DB2 UDB (5/5)
      8. Setting up idle standby for DB2 UDB server (1/2)
      9. Setting up idle standby for DB2 UDB server (2/2)
      10. Setting up active standby for DB2 UDB server
      11. DB2 UDB clustering on Windows (1/4)
      12. DB2 UDB clustering on Windows (2/4)
      13. DB2 UDB clustering on Windows (3/4)
      14. DB2 UDB clustering on Windows (4/4)
    3. Siebel Applications failover
      1. HACMP for Siebel Applications
      2. Windows clustering for Siebel Applications
    4. Disaster recovery
      1. Recovery for the Siebel environment
      2. DB2 UDB recovery options
    5. DB2 HADR
  13. Chapter 10: Siebel Analytics
    1. Architecture overview
      1. DAC and Change-Capture process on OLTP database
    2. Creation and maintenance of Siebel Analytics tables in the OLTP database (1/2)
    3. Creation and maintenance of Siebel Analytics tables in the OLTP database (2/2)
    4. Data extraction from OLTP database for Siebel Analytics
  14. Appendix A: Set up scripts
    1. Database scripts for AIX
      1. Directory creation
      2. Setting DB2 UDB registry variables
      3. Database manager configuration parameters
      4. Database creation
      5. Database configuration parameters
      6. Creation of buffer pools
      7. Creation of temporary table spaces
      8. Creation of Siebel table spaces
    2. Database scripts for Windows
      1. Setting DB UDB registry variables
      2. Database manager configuration parameters
      3. Database creation
      4. Database configuration parameters
      5. Creation of buffer pools
      6. Creation of temporary table spaces
      7. Creation of Siebel table spaces
    3. HACMP scripts
      1. start_db2_siebel
      2. db2.reboot
      3. start_gateway
      4. start_siebel
      5. stop_db2_siebel
      6. stop_gateway
      7. stop_siebel
    4. Siebel files
      1. lbconfig.txt
      2. eapps.cfg
  15. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  16. Index (1/3)
  17. Index (2/3)
  18. Index (3/3)
  19. Back cover

Product information

  • Title: Siebel 7.8 with IBM DB2 UDB V8.2 Handbook
  • Author(s): Whei-Jen Chen, Priti Desai, Ujwala Devi, Sreeman Kancherla, Venkatram Menakuru, Raghu Ramaswamy, Scott Saunders, Arjun Sirohi
  • Release date: November 2005
  • Publisher(s): IBM Redbooks
  • ISBN: None