DB2 OLAP Server Installation Guide

Contents

About this book

  • Who should read this book
  • Publications
  • Additional support

    • Chapter 1. What's new in Version 8.1

  • What's new in DB2 OLAP Server 8.1
  • What's new in DB2 OLAP Integration Server 8.1

    • Chapter 2. Before you install

  • Read the installation checklist
  • Prepare to upgrade DB2 OLAP Integration Server
  • Preserving an existing ODBC Driver
  • Migrating existing OLAP Metadata Catalogs
  • Check compatibility with earlier versions

    • Chapter 3. Hardware and software Requirements

  • Server hardware and software requirements
  • Windows server requirements
  • Solaris Operating System server requirements
  • AIX server requirements
  • HP-UX server requirements
  • Client hardware and software requirements
  • API client hardware and software requirements
  • Supported ODBC drivers and relational data sources
  • For DB2 OLAP Server
  • For DB2 OLAP Integration Server
  • Supported JDBC Drivers for XML Import/Export in OIS

    • Chapter 4. Installing on Windows

  • Installing DB2 OLAP Server
  • Installation steps
  • Security
  • Network Protocol Files
  • Installing DB2 OLAP Integration Server on Windows
  • Installing DB2 OLAP Server Miner on Windows
  • Setting up client installation from a network file server
  • Loading the client image onto the network
  • Installing the clients from the network
  • Maintaining the common clients
  • Configuring Client and Server for Non-English DB2 OLAP Server
  • Starting DB2 OLAP Server on Windows
  • Automating server startup
  • Automating application startup
  • Stopping DB2 OLAP Server
  • Optimizing network throughput on Windows NT
  • Adding additional software or users later
  • Using agent commands

    • Chapter 5. Installing on AIX, Solaris Operating Environment, and HP-UX

  • Installing DB2 OLAP Server on UNIX
  • Installation steps for DB2 OLAP Server
  • Installing DB2 OLAP Integration Server on UNIX
  • Updating the Environment for the Database Client
  • Installing DB2 OLAP Server Miner on AIX
  • Updating the environment settings
  • For all UNIX operating systems
  • For Solaris Operating Environment only
  • For HP-UX only
  • Starting and shutting down the server
  • Starting the server in the foreground
  • Starting the server in the background
  • Securing a password script
  • Shutting down the server
  • Adding additional software or users later
  • Using agent commands

    • Chapter 6. Installing and configuring Java

  • Setting up Java on UNIX
  • Installing Java on UNIX
  • Updating Java variables for DB2 OLAP Server on UNIX
  • Giving DB2 OLAP Server access to JAXP on UNIX
  • Updating Java variables for DB2 OLAP Integration Server on UNIX
  • Finding which shell you are using
  • Setting up Java on Windows
  • Setting Java environment variables on Windows
  • Setting JVMMODULELOCATION on Windows

    • Chapter 7. Configuring the SQL Interface

  • Configuring SQL Interface on Windows
  • Configuring SQL Interface on UNIX
  • Workflow for configuring SQL Interface on UNIX
  • Setting up RDBMS for the SQL Interface on UNIX
  • Directories and files created
  • Setting up ODBC drivers before linking them to SQL Interface
  • Linking SQL Interface to the ODBC driver on UNIX
  • After you link SQL Interface to your ODBC Driver on UNIX
  • Configuring the data source and ODBC driver

    • Chapter 8. Configuring data sources for DB2 OLAP Integration Server

  • About configuring relational data sources
  • Configuring the database client software
  • Supported ODBC drivers
  • Configuring data sources on Windows systems
  • Configuring the OLAP metadata catalog on Windows systems
  • Configuring data sources on UNIX systems
  • Editing the odbc.ini file
  • Configuring the OLAP metadata catalog on UNIX systems

    • Chapter 9. Creating OLAP Metadata Catalogs for DB2 OLAP Integration Server

  • About OLAP metadata catalogs
  • Creating an OLAP Metadata Catalog
  • Creating an OLAP Metadata catalog automatically
  • Deleting an OLAP Metadata Catalog
  • Creating an OLAP Metadata catalog manually
  • Upgrading the OLAP Metadata Catalog

    • Chapter 10. Setting up the sample applications

  • Samples for DB2 OLAP Server
  • Loading the sample databases for DB2 OLAP Server
  • Providing user access to the sample applications
  • Setting the environment for the partitioning sample applications
  • Loading Data into Samppart and Sampeast
  • Samples for DB2 OLAP Integration Server
  • About the DB2 OLAP Integration Server samples
  • Before you set up the sample application
  • Setting up the sample application automatically
  • Setting up the sample application manually
  • After you set up the sample application

    • Chapter 11. Upgrading and migrating from earlier versions

  • Migrating DB2 OLAP Server
  • Migrate from RSM to MSM before upgrading to Version 8.1
  • Understanding input/output defaults and upgrading
  • Considerations when upgrading from previous releases
  • Upgrading databases to Version 8.1
  • Migrating applications and databases across servers
  • Migrating DB2 OLAP Integration Server
  • ODBC drivers on Windows
  • Java Runtime Environment
  • Migrating existing OLAP metadata catalogs
  • Security Migration Tool
  • Main features of the Security Migration tool
  • Supported platforms
  • Running the Security Migration tool
  • Other notes on migration

    • Notices

  • Trademarks

    • Glossary

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]