Siebel 7 with DB2 for z/OS database implementation and administration guide
In this IBM Redbooks publication, we describe the implementation, customization, and administration of the Siebel 7 database with DB2 UDB for z/OS and OS/390 V7 using AIX V5L or Win2000 Siebel Servers, and we discuss the following topics: Installation tasks for setting up a three-tier configuration,...
| Autor Corporativo: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[San Jose, Calif.] :
International Technical Support Organization
2003.
|
| Edición: | 1st ed |
| Colección: | IBM redbooks.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627221706719 |
Tabla de Contenidos:
- 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.
