Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 Introduction -- Chapter 1. DB2 OLAP Server V8.1 overview -- 1.1 Advanced analytical functions -- 1.1.1 Combining OLAP and relational databases: Hybrid Analysis -- 1.1.2 OLAP Miner -- 1.2 Advanced enterprise functions -- 1.3 Advanced administrative functions -- 1.3.1 Parallel calculation -- 1.3.2 Parallel data load -- 1.3.3 Parallel export -- 1.3.4 Administration Services -- 1.3.5 Security Migration Tool -- 1.3.6 Custom Defined Functions and Custom Defined Macros -- 1.3.7 API enhancements -- 1.3.8 Additional improvements and new functions -- Chapter 2. DB2 OLAP Server components and case studies -- 2.1 DB2 OLAP Server components architecture -- 2.1.1 The basic DB2 OLAP Server installation -- 2.1.2 Expanding OLAP capabilities with Integration Server -- 2.1.3 Expanding with Enterprise Services -- 2.1.4 Expanding with Administration Services -- 2.1.5 Using Security Migration Tool -- 2.1.6 Using Analyzer -- 2.1.7 The big picture -- 2.2 Case studies and our test environment -- 2.2.1 E-banking case study -- 2.2.2 Online Investment case study -- 2.2.3 Our test environment setup -- Part 2 Advanced analytical functions -- Chapter 3. Hybrid Analysis -- 3.1 Hybrid Analysis overview -- 3.1.1 Terminology and definitions -- 3.2 When to use Hybrid Analysis -- 3.3 Hybrid Analysis architecture -- 3.4 Hybrid Analysis challenges -- 3.5 Implementation of Hybrid Analysis -- 3.5.1 Building Hybrid Analysis using Integration Server -- 3.5.2 Hybrid Analysis member transformation -- 3.5.3 Impact of Hybrid Analysis versus multidimensional -- 3.5.4 Hybrid Analysis in Application Manager -- 3.5.5 Hybrid Analysis and Administration Services.

3.6 Tips and tricks for tuning Hybrid OLAP applications -- 3.6.1 Defining HAMEMORYCACHESIZE -- 3.6.2 Defining HAMAXNUMCONNECTION -- 3.6.3 Defining HAMAXNUMSQLQUERY -- 3.6.4 Defining HAMAXQUERYROWS -- 3.6.5 Defining HAMAXQUERYTIME -- 3.6.6 Defining HARETRIEVENUMROW -- 3.6.7 Conclusions: Hybrid Analysis configuration settings -- 3.7 Queries in the Hybrid Analysis environment -- 3.7.1 Member caching for better query performance -- 3.8 Query performance -- 3.9 Hybrid Analysis and Drill-Through Reports -- 3.9.1 Characteristics of Drill-Through Reports -- 3.9.2 Characteristics of Hybrid Analysis -- 3.9.3 Drill-Through Reports versus Hybrid Analysis -- 3.10 Data modeling for Hybrid Analysis -- 3.11 Security configuration for Hybrid Analysis -- 3.11.1 Tracing Hybrid Analysis -- Chapter 4. Mining your OLAP cube with OLAP Miner -- 4.1 OLAP Miner overview -- 4.2 Deviation detection in OLAP Miner -- 4.2.1 OLAP Miner performance -- 4.3 When to use OLAP Miner, and when not to use it -- 4.4 Mining and interpreting E-banking cube results -- 4.4.1 Scenario 1: PC-banking usage by branch -- 4.4.2 Scenario 2: Equity trade and Net-banking in branches -- 4.5 OLAP Miner setup and architecture -- 4.6 Running and monitoring OLAP Miner -- 4.6.1 Getting OLAP Miner to run, and stopping it -- 4.6.2 OLAP Miner client configuration -- 4.7 OLAP Miner results and logs -- Part 3 Advanced functions of Enterprise Services -- Chapter 5. Enterprise Services -- 5.1 Enterprise Services overview -- 5.1.1 Enterprise Services components -- 5.2 Enterprise Services configurations -- 5.2.1 TCP/IP Client Programs -- 5.2.2 HTTP client programs -- 5.2.3 EJB client programs -- 5.2.4 CORBA client programs -- 5.3 Enterprise Services deployment scenarios -- 5.3.1 Scalability overview -- 5.3.2 Clustering -- 5.3.3 Connection pooling -- 5.3.4 Workload balancing.

5.3.5 Server and application failure and failover -- 5.3.6 Enterprise Services: the whole picture -- 5.3.7 Guidelines for implementing a full cluster of OLAP servers -- 5.3.8 Copy DB2 OLAP applications and databases across servers -- 5.3.9 Synchronizing data across DB2 OLAP Servers in a cluster -- 5.3.10 Synchronizing security across all OLAP Servers in a cluster -- 5.4 Implementing Enterprise Services with TCP/IP -- 5.4.1 Installation tips for Enterprise Services: Windows and AIX -- 5.4.2 Setting up the domain storage -- 5.4.3 Starting Enterprise Services -- 5.4.4 Creating a domain -- 5.4.5 Defining users -- 5.4.6 Defining DB2 OLAP Server and Enterprise Services servers -- 5.4.7 Creating clusters -- 5.4.8 Creating connection pools -- 5.4.9 Using the sample programs -- 5.4.10 Additional tasks -- Part 4 Advanced administrative functions -- Chapter 6. Parallel calculation, data load, and export -- 6.1 Performing parallel calculation -- 6.1.1 Understanding parallel calculation -- 6.1.2 Parallel calculation architecture -- 6.1.3 Requirements -- 6.1.4 Enabling parallel calculation -- 6.1.5 Identifying concurrent tasks for parallel calculation -- 6.1.6 Running parallel calculation -- 6.1.7 Parallel calculation performance -- 6.1.8 Monitoring using the log -- 6.1.9 Estimating the size of a database calculation -- 6.2 Performing parallel load -- 6.2.1 Understanding the parallel load -- 6.2.2 Enabling parallel load -- 6.2.3 Running parallel data load -- 6.2.4 Monitoring using the log -- 6.2.5 Parallel load performance: Defining the right parameters -- 6.2.6 Tools to monitor parallel calculation and load -- 6.3 Performing parallel export -- 6.3.1 Running parallel export -- 6.3.2 Monitoring using the log -- 6.3.3 Parallel export performance -- 6.3.4 Exporting files larger than 2 GB -- Chapter 7. Administration Services -- 7.1 Administration Services components.

7.2 New administrative capabilities -- 7.3 Administration Services configurations -- 7.4 Using Administration Services -- 7.4.1 Managing security -- 7.4.2 Managing DB2 OLAP Servers, applications, and databases -- 7.4.3 Managing logs -- 7.4.4 Managing scripts -- 7.4.5 Miscellaneous -- 7.5 Implementing Administration Services -- 7.5.1 Preparing for installation -- 7.5.2 Installing DB2 OLAP Server components -- 7.5.3 Installing Administration Services -- 7.5.4 Starting Administration Services -- 7.5.5 Setting up users -- 7.5.6 Backing up Administration Services users information -- 7.5.7 Creating views -- Chapter 8. Additional enhancements -- 8.1 Direct I/O -- 8.1.1 Understanding the DB2 OLAP Server caches -- 8.1.2 The difference between buffered I/O and direct I/O -- 8.1.3 New features in DB2 OLAP Server version 8.1 -- 8.1.4 Changing the I/O access mode (buffered I/O or direct I/O) -- 8.1.5 The cache memory locking option -- 8.1.6 Defining the DB2 OLAP Server caches when using direct I/O -- 8.2 Security Migration Tool -- 8.2.1 Before running the Security Migration Tool -- 8.2.2 Running the Security Migration Tool -- 8.3 Multiple OLAP agents on the same machine -- 8.3.1 Hints and tips -- 8.3.2 A sample configuration scenario -- 8.4 Custom Defined Functions -- 8.4.1 Software requirements -- 8.4.2 Performance considerations in the Windows environment -- 8.4.3 Creating a CDF -- 8.4.4 Using a CDF in the outline -- 8.4.5 Using a CDF in calculations -- Part 5 Appendixes -- Appendix A. DB2 OLAP Integration Server -- A.1 Integration Server enhancements -- A.2 Migration of earlier OLAP metadata catalogs -- A.2.1 New configuration file for Integration Server -- A.2.2 Multiple data sources in Integration Server -- A.2.3 Drill through -- A.2.4 XML export/import of models and metaoutlines -- A.2.5 Intelligent help and increased usability.

Appendix B. Setting up DB2 OLAP Analyzer Analysis Server V8.1 -- B.1 Analyzer V8.1 overview -- B.1.1 Supported platforms -- B.1.2 Architectural overview -- B.2 WebSphere Application Server setup -- B.3 Setting up and configuring Analyzer Server V8.1 -- B.3.1 Configuring Analyzer -- B.3.2 Uninstalling Analyzer V8.1 -- B.4 Using Analyzer V8.1 -- B.4.1 Analyzer Server console -- B.4.2 Analyzer Administration Tool -- Appendix C. Enterprise Services sample programs -- C.1 Copy application/database using CopyOLAP -- C.2 Sample runsamples.cmd script -- Appendix D. Data modeling basics -- D.1 ER data models -- D.2 Multidimensional data models: star and snowflake -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.