Contents

About this book
Who should read this book
IBM names for Hyperion products and components
Publications
How to get support
Product information
Comments on the documentation
Before you install
Follow the installation checklist
Prepare to upgrade DB2 OLAP Integration Server
Migrating existing OLAP Metadata Catalogs
Understanding the HYPERION_HOME variable
Understanding the ESSLANG variable
Managing ESSLANG settings
About the security file and ESSLANG values
Check compatibility with earlier versions
Hardware and software requirements
Server hardware and software requirements
Windows server requirements
Solaris Operating System server requirements
AIX server requirements
HP-UX server requirements
Linux server requirements
Client hardware and software requirements
API system 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
Installing and starting on Windows
Installing DB2 OLAP Server
Shut down Windows services and applications before installation
Installation steps
Security
Installing DB2 OLAP Integration Server on Windows
Installing DB2 OLAP Server Miner on Windows
Installing the runtime client
Setting up a silent install
Installing the documentation
Setting up a silent install of the documentation
Starting the Analytic Server on Windows
Automating server startup
Automating application startup
Stopping DB2 OLAP Server
Starting the Integration Server on Windows
Starting and stopping Integration Server from the Windows desktop
Starting and stopping Integration Server from the DOS command line
Troubleshooting Common Connection Problems
Updating the path for Java on Windows (optional)
Running DB2 OLAP Server and DB2 OLAP Integration Server as a Windows service
Installing the Analytic Server and Integration Server as Windows services
Verifying that the services are running
Stopping the services
Removing the services
Adding additional software or users later
Using agent commands
Workflow for implementing external authentication
Installing and starting on UNIX
Installing DB2 OLAP Server on UNIX
Pre-installation steps
Installation steps for DB2 OLAP Server
Installing DB2 OLAP Integration Server on UNIX
Installing DB2 OLAP Server Miner on AIX
Configuring the environment on UNIX
Updating the DB2 OLAP Integration Server environment for ODBC
Updating the environment for the database client
Enabling use of cache memory locking systems
Configuring the cron scheduling daemon
Starting the Analytic Server on UNIX
Starting Analytic Server in the foreground
Starting the server in the background
Hiding Analytic Server passwords on UNIX
Shutting down Analytic Server
Starting Integration Server on UNIX
Running Integration Server on UNIX Systems
Stopping Integration Server on UNIX Systems
Troubleshooting common connection problems
Adding additional software or users later
Using agent commands
Configuring DB2 OLAP Server for relational integration
Preparing to use SQL Interface or Hybrid Analysis
SQL Interface and Hybrid Analysis on Windows
SQL Interface and Hybrid Analysis on UNIX
What happens during installation on UNIX
Linking SQL Interface to ODBC drivers on UNIX
Setting up Teradata on UNIX
Completing configuration tasks on UNIX
Setting library paths on UNIX
Additional tasks
Additional Hybrid Analysis tasks
Additional SQL Interface tasks
Hybrid Analysis features map
Setting up the sample application for DB2 OLAP Server
Loading the sample databases for DB2 OLAP Server
Providing user access to the sample applications
Preparing the sample aggregate storage application for use
Setting the environment for the partitioning sample applications
Creating the partition user
Changing embedded server names in the sample partition definitions
Loading data into Samppart and Sampeast
Connecting DB2 OLAP Integration Server
Starting Integration Services Console
Connecting to server components and data sources
Connecting to Integration Server
Connecting to Analytic Server
Setting connection defaults
Connecting to data sources
Reconnecting when connections are lost
Configuring relational data sources for DB2 OLAP Integration Server
About data source configuration
Server and client software and ODBC connections
Supported ODBC drivers
Configuring data source names on Windows
Accessing the ODBC Data Source Administrator
Configuring DataDirect Wire Protocol drivers
Testing DataDirect Wire Protocol drivers
Adding a configuration file entry for DB2 UDB for z/OS and OS/390
Configuring the SQL Server ODBC Driver for Microsoft SQL Server
Configuring the Teradata ODBC driver for Teradata
Editing a Data Source Name
Using Oracle OCI Direct Connection for Oracle
Configuring data source names on UNIX systems
Configuring environment variables
Editing the odbc.ini file
Creating DB2 bind packages for DataDirect Wire Protocol driver connections
Adding a configuration file entry for DB2 UDB for z/OS and OS/390
After configuration of data source names
Creating, upgrading, and deleting OLAP Metadata Catalogs
About OLAP Metadata Catalogs
Creating or upgrading OLAP Metadata Catalogs
Creating databases for OLAP Metadata Catalog tables
Creating or upgrading the OLAP Metadata Catalog automatically
Creating the OLAP Metadata Catalog manually
Upgrading the OLAP Metadata Catalog manually
Mapping OLAP Metadata Catalogs
Deleting OLAP Metadata Catalogs
Setting up the sample application for DB2 OLAP Integration Server
Preparing to set up the standard sample application
Setting up the standard sample application automatically
Setting up the standard sample application manually
Setting up the TBC relational data source
Creating the TBC database
Creating tables for the TBC database
Loading data into the TBC tables
Setting up the TBC_MD OLAP Metadata Catalog
Creating the TBC_MD database
Creating Tables for the TBC_MD Database
Using the XML Import utility to load data into the TBC_MD tables
Using XML Import to load data into TBC_MD
Setting up the Hybrid Analysis sample application
Setting up the Hybrid Analysis sample application on DB2 UDB
Setting up the Hybrid Analysis sample application on Oracle
Setting up the Hybrid Analysis sample application on SQL Server
Setting up the Hybrid Analysis sample application on Teradata
Setting up the Unicode sample application
Creating the Unicode TBC_U database
Creating the Unicode TBC_MD_U OLAP Metadata Catalog
Setting up the Unicode sample application
After setting up the sample application
Viewing TBC tables and columns
Viewing OLAP models
Viewing metaoutlines
Upgrading and migrating from earlier versions
Migrating DB2 OLAP Server
Supported API Versions
Upgrading applications that use APIs
Compatibility of non-Unicode applications between client and server software
Understanding input/output defaults and upgrading
Upgrading databases to Version 8.2
Moving applications and databases to another computer
Upgrading and moving applications and databases at the same time
Migrating DB2 OLAP Integration Server
ODBC drivers on Windows
Supported JDBC drivers for XML import/export
Migrating existing OLAP metadata catalogs
Other notes on migration
Notices
Trademarks
Index