Siebel 7.8 with IBM DB2 UDB V8.2 handbook / Whei-Jen Chen ... [et al.].

Format:

Book

Author/Creator:

Chen, Whei-Jen.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

Management information systems.

Physical Description:

1 online resource (406 p.)

Edition:

1st ed.

Place of Publication:

San Jose, CA : IBM, c2005.

Language Note:

English

Contents:

Front cover

Contents

Figures

Notices

Trademarks

Preface

The team that wrote this redbook

Acknowledgement

Become a published author

Comments welcome

Chapter 1. Introduction

1.1 Partnership between IBM and Siebel Systems

1.1.1 Ongoing activities

1.1.2 Recent developments

1.2 Benefits of DB2 UDB V8.2 with the Siebel Enterprise

1.2.1 DB2 UDB V8.2 enhancements

Chapter 2. Architecture

2.1 Architecture layout of Siebel Enterprise

2.1.1 Siebel Clients

2.1.2 Siebel Web Server Extension

2.1.3 Siebel Enterprise Server

2.1.4 Siebel Server

2.1.5 Siebel Gateway Name Server

2.1.6 Siebel File System

2.1.7 Siebel Database

2.1.8 Siebel Object architecture

2.2 DB2 UDB architecture

2.2.1 Architecture overview

2.2.2 Process concepts

2.2.3 Memory concepts

2.2.4 Storage concepts

Chapter 3. Planning considerations

3.1 Siebel release matrix for DB2 UDB

3.1.1 IBM DB2 Universal Database™ V8.2 ESE

3.1.2 Operating systems and hardware for DB2 UDB

3.1.3 Siebel Developer Web Client

3.2 Siebel sizing considerations

3.2.1 Information requirements

3.2.2 Sizing deliverables

3.2.3 Related reviews

3.3 Hardware and storage requirements

3.3.1 Siebel hardware and storage requirements

3.3.2 Considerations for hardware planning

3.3.3 DB2 UDB

3.4 Database layout and recommendations

3.4.1 Decision time

3.4.2 Table grouping by Siebel components used

3.5 Using Siebel with DB2 UDB 32-bit versus 64-bit

3.6 Users and groups

3.7 Checklist

Chapter 4. Installation and configuration

4.1 Installation flow chart

4.2 Lab environment

4.3 Installing DB2 UDB and Siebel on AIX

4.3.1 Installation and configuration of DB2 UDB server and client on AIX

4.3.2 Creation of the Siebel installation image.

4.3.3 Install and configure the Siebel Application in console mode

4.4 Installing Siebel on Windows

4.4.1 Installation and configuration of DB2 UDB server on Windows

4.4.2 Creating the Siebel install image

4.4.3 Installation and configuration of Siebel Application on Windows

4.5 Installation and configuration of DB2 UDB server on Linux

4.6 Siebel Developer Web Client

4.7 Installation troubleshooting

4.7.1 Environment Verification Tool

4.7.2 Error messages

Chapter 5. Data in a Siebel Enterprise

5.1 Governing model for Siebel data

5.2 Data loading methods

5.2.1 Enterprise Integration Manager

5.2.2 Enterprise Application Integration

5.2.3 Siebel programming interfaces

5.2.4 Siebel Web Client

5.3 Data quality maintenance

5.3.1 Identifying data quality problems

5.3.2 Maintaining data quality

5.4 Data archiving

Chapter 6. Database administration

6.1 Backup

6.1.1 Logging concepts

6.1.2 Types of backup

6.1.3 Backup command and authorities required

6.1.4 Performing backup on Siebel File System

6.1.5 Backup image file format

6.1.6 DB2 UDB processes related to database backup/restore

6.1.7 Database history file

6.1.8 Backup examples

6.1.9 VLDB backups

6.2 Recovery overview

6.2.1 Restore command and authorities required

6.2.2 Rollforward command and authorities required

6.2.3 Recover database command

6.2.4 Database recovery examples

6.3 RUNSTATS

6.4 DB2 UDB table reorganization

6.4.1 DB2 UDB data reorganization in a Siebel environment

6.5 Query control

6.5.1 DB2 Query Patroller

6.5.2 Siebel Query Cancel function

6.5.3 Home-grown query cancel scripts

Chapter 7. Database server monitoring

7.1 Tools for monitoring

7.1.1 Snapshot monitor

7.1.2 Event monitor

7.1.3 Explain utilities

7.1.4 DB2 UDB diagnostic log.

7.1.5 Health Center/Memory Visualizer/DB2MTRK

7.1.6 Design Advisor

7.1.7 DB2 UDB problem determination utility

7.2 DB2 Performance Expert

7.3 Tivoli Monitoring

7.4 OS monitoring

7.4.1 Monitoring tools on the UNIX platform

7.4.2 Monitoring tools on the Windows platform

Chapter 8. Performance tuning

8.1 Performance tuning introduction

8.2 Initial DB2 UDB configuration parameter settings

8.2.1 Database manager configuration

8.2.2 Database configuration

8.2.3 DB2 registry variables

8.3 Siebel configuration

8.3.1 Siebel configurations for database

8.4 Operating system configuration considerations

8.5 Tuning the DB2 UDB environment

8.5.1 DB2 UDB registry and environment variables

8.5.2 DB2 UDB database manager parameters

8.5.3 DB2 UDB database parameters

8.6 Lock wait/deadlock/lock escalation

8.6.1 Locking issues

8.6.2 Tools used to monitor locking issues

8.6.3 Identifying the lock issues

8.6.4 New feature of DB2 UDB V8.2 in the locking context

8.7 Buffer pool

8.8 Table space

Chapter 9. High availability and disaster recovery

9.1 Components of a Siebel Enterprise

9.2 Database server

9.2.1 HA options for DB2 UDB server

9.2.2 Information on the lab environment

9.2.3 Installation and configuration of HACMP on AIX for DB2 UDB

9.2.4 Setting up idle standby for DB2 UDB server

9.2.5 Setting up active standby for DB2 UDB server

9.2.6 DB2 UDB clustering on Windows

9.3 Siebel Applications failover

9.3.1 HACMP for Siebel Applications

9.3.2 Windows clustering for Siebel Applications

9.4 Disaster recovery

9.4.1 Recovery for the Siebel environment

9.4.2 DB2 UDB recovery options

9.5 DB2 HADR

Chapter 10. Siebel Analytics

10.1 Architecture overview

10.1.1 DAC and Change-Capture process on OLTP database.

10.2 Creation and maintenance of Siebel Analytics tables in the OLTP database

10.3 Data extraction from OLTP database for Siebel Analytics

Appendix A. Set up scripts

A.1 Database scripts for AIX

A.1.1 Directory creation

A.1.2 Setting DB2 UDB registry variables

A.1.3 Database manager configuration parameters

A.1.4 Database creation

A.1.5 Database configuration parameters

A.1.6 Creation of buffer pools

A.1.7 Creation of temporary table spaces

A.1.8 Creation of Siebel table spaces

A.2 Database scripts for Windows

A.2.1 Setting DB UDB registry variables

A.2.2 Database manager configuration parameters

A.2.3 Database creation

A.2.4 Database configuration parameters

A.2.5 Creation of buffer pools

A.2.6 Creation of temporary table spaces

A.2.7 Creation of Siebel table spaces

A.3 HACMP scripts

A.3.1 start_db2_siebel

A.3.2 db2.reboot

A.3.3 start_gateway

A.3.4 start_siebel

A.3.5 stop_db2_siebel

A.3.6 stop_gateway

A.3.7 stop_siebel

A.4 Siebel files

A.4.1 lbconfig.txt

A.4.2 eapps.cfg

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

Bibliographic Level Mode of Issuance: Monograph

OCLC:

228139587