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.