Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Overview of Siebel 7 with DB2 for z/OS database -- 1.1 Siebel 7 system architecture overview -- 1.2 Siebel 7 database implementation overview -- 1.3 Siebel 7 database administration overview -- 1.4 DB2 for z/OS V7 functions that benefit Siebel 7 -- 1.4.1 Correlated subquery for UPDATE joins -- 1.4.2 Self-referencing subselect with UPDATE/DELETE -- 1.4.3 Online system parameters -- 1.4.4 Scrollable cursors -- 1.4.5 MEMBER ID for sysplex scalability -- 1.4.6 Realtime statistics -- 1.4.7 FETCH FIRST n ROWS -- 1.4.8 Asynchronous preformatting -- 1.4.9 Catalog row-level locking -- 1.4.10 REORG enhancements -- 1.4.11 Statistics HISTORY -- 1.4.12 New monitoring indicators -- 1.5 DB2 Connect EE V7 database connectivity -- 1.5.1 DB2 database connection types -- 1.5.2 DB2 Connect EE setup overview -- 1.6 Siebel 7 database connection pooling -- Chapter 2. Installing the Siebel 7 system environment -- 2.1 System configuration -- 2.1.1 Siebel 7 client tier -- 2.1.2 Siebel 7 mid-tier -- 2.1.3 Siebel 7 database tier -- 2.2 z/OS security setup -- 2.2.1 RACF - userids and groups -- 2.2.2 DB2 UDB for z/OS and OS/390 authorization -- 2.3 DB2 for OS/390 and z/OS setup -- 2.3.1 DSNZPARM values -- 2.3.2 Buffer pools and storage group -- 2.3.3 DB2 objects for Siebel -- 2.3.4 Stored procedures -- 2.4 Mid-tier setup -- 2.4.1 AIX V5L configuration -- 2.4.2 SAMBA install and setup -- 2.4.3 HTTP Web server install and setup -- 2.4.4 DB2 Connect EE V7.2 installation -- 2.4.5 DB2 Connect Fix Pack 5s installation -- 2.4.6 DB2 Connect configuration -- 2.5 Installation of Siebel 7 servers -- 2.5.1 Installation of Siebel 7 Gateway server -- 2.5.2 Installation of Siebel 7 Application server.

2.5.3 Installation of Siebel 7 database scripts -- 2.5.4 Installation of Siebel 7 maintenance - 7.0.4.200 -- 2.5.5 Installation of Siebel 7 database schema -- 2.5.6 Post-installation tasks -- 2.6 Installation of Siebel 7 Web server and extensions -- 2.6.1 Customizing the Siebel 7 Web server -- 2.7 Installation of Siebel 7 Web server maintenance - 7.0.4.200 -- Chapter 3. Modifying the Siebel schema for a production environment -- 3.1 Extracting a current storage control file -- 3.2 Modifying the storage control file - table space partitioning -- 3.2.1 Running the Siebel Database Configuration utility -- 3.2.2 Creating a backup table -- 3.2.3 Synchronize schema definition - produce a new schema file -- 3.2.4 Applying the schema changes -- 3.2.5 Saving the storage control file -- Chapter 4. Migration from development to the production system -- 4.1 Running dev2prod -- 4.2 Reviewing the schema file - applying the DDL to the production system -- 4.3 Activating the repository imported from development -- Chapter 5. Identifying and removing unused, non-unique indexes -- 5.1 Why remove indexes -- 5.2 Which indexes to remove -- 5.3 Siebel functional areas of interest -- 5.4 Identifying unused, non-unique indexes -- 5.4.1 In the EIM load process -- 5.4.2 In Siebel online -- 5.4.3 Index identification procedure -- 5.5 Inactivation of unused indexes -- Chapter 6. Partitioning method using DB2 utilities -- 6.1 Planning steps for partitioning Siebel tables -- 6.2 Identifying candidate tables and partition columns -- 6.3 Planning for REXX procedures -- 6.4 Unloading the tables -- 6.4.1 Reference table -- 6.4.2 Unloading the data -- 6.5 Creating new tables with partitions -- 6.6 Loading the tables -- 6.7 Reorganizing the tables -- Chapter 7. Monitoring dynamic SQL -- 7.1 Monitoring dynamic SQL in the DSC -- 7.1.1 DB2 PM Workstation Online Monitor tool.

7.1.2 Explaining SQL statement from the cache -- 7.1.3 Identifying inefficient SQL -- 7.1.4 Considerations on parameter markers -- 7.2 Siebel SQL tracing -- 7.2.1 Object Manager -- 7.2.2 Dedicated Web client -- 7.2.3 EIM performance considerations -- Chapter 8. Monitoring the Siebel 7 database -- 8.1 DB2 installation considerations -- 8.1.1 Database objects -- 8.1.2 Free space -- 8.1.3 EDM pool size -- 8.1.4 Buffer pools -- 8.2 DB2 statistics -- 8.2.1 Why collect statistics -- 8.2.2 What statistics should you gather for Siebel -- 8.2.3 Monitoring VSAM data set extents -- 8.3 DB2 history statistics -- 8.3.1 Monitoring space growth -- 8.3.2 Monitoring the rebuild of the compression dictionary -- 8.4 DB2 realtime statistics -- 8.5 Database reorganization -- 8.6 Siebel-DB2 database recovery -- 8.6.1 Recovery to currency -- 8.6.2 Disaster recovery -- 8.6.3 Point-in-time recovery -- Appendix A. DB2 parameters -- A.1 DSNZPARM values used for the Siebel 7 installation -- Appendix B. Sample Siebel 7 generate DDL output -- B.1 Sample generate DLL output -- Appendix C. Batch jobs for table space partitioning -- C.1 Batch job used to create a backup table space -- C.2 Batch job used to create a partitioned table space -- Appendix D. REXX procedures for table space partitioning -- D.1 Reference table -- D.2 Unload jobs and procedures -- D.3 Load jobs and procedures -- Appendix E. REXX program for EXPLAIN -- Appendix F. Additional material -- Locating the Web material -- Using the Web material -- How to use the Web material -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.