Who Should Read this Book
Related Publications
Who Should Read this Book
Related Publications
The Full DB2 OLAP Server product
The DB2 OLAP Integration Server
The DB2 OLAP Starter Kit
The OLAP Engine
The Relational Storage Manager
The Multidimensional Storage Manager
Star Schema Tables and Views
Terminology
What's New in Version 7.1
Supported Hardware
Supported Software
Supported Relational Database Management Systems
Multi-Threaded Environments for AIX, Solaris Operating Environment, and HP-UX
Communications Protocols
Installing DB2 OLAP Server
Information You Need Before You Install
DB2 OLAP Server Components and Add-ons
Installation Steps
Installing DB2 OLAP Starter Kit
Components of DB2 OLAP Starter Kit
Installation Steps for OLAP Starter Kit on Windows
Installing DB2 OLAP Integration Server
Connecting to Servers and Relational Data Sources
About OLAP Metadata Catalogs
Updating the Environment for the Database Client
OLAP Integration Server Directory Structure
Manually Updating Environment Variables
Starting DB2 OLAP Server on Windows
Automating Server Startup
Automating Application Startup
Stopping DB2 OLAP Server and Starter Kit
Using DB2 OLAP Integration Server to Load Data
Upgrading DB2 OLAP Server or DB2 OLAP Starter Kit
Enabling the DB2 OLAP Server License
Loading and Configuring ODBC for the SQL Interface
Setting Up the IBM DB2 ODBC Driver
Setting Up the Merant ODBC Driver
Managing Server Operations
Installing DB2 OLAP Server
Information You Need Before You Install
DB2 OLAP Server Components and Add-ons
Installation Steps for DB2 OLAP Server
Installing DB2 OLAP Starter Kit
Components of DB2 OLAP Starter Kit
Installation Steps for DB2 OLAP Starter Kit
Installing DB2 OLAP Integration Server
Connecting to Servers and Relational Data Sources
About OLAP Metadata Catalogs
Updating the Environment for the Database Client
OLAP Integration Server Directory Structure
Updating the Environment Variables
Setting the ARBORPATH Variable
Setting the Library Path Variable
Kernel Configuration Parameters
Verifying the AIX Environment
Using the Set Path Command (Optional)
Using DB2 OLAP Server to Load Data
Starting DB2 OLAP Server for AIX, Solaris Operating Environment, and HP-UX
Starting DB2 OLAP Server in the Foreground
Starting DB2 OLAP Server in the Background
Stopping DB2 OLAP Server and OLAP Starter Kit
Upgrading DB2 OLAP Server or DB2 OLAP Starter Kit
Enabling the DB2 OLAP Server License
Loading and Configuring ODBC for the SQL Interface
Managing Server Operations
Introducing Information Catalog Manager
Information Catalog Manager components
Information Catalog Manager Tools component
Information Catalog Administrator component
Information Catalog User component
Information Catalog Manager for the Web
Before you begin
Installing the Information Catalog Manager Tools, Administrator, and User components
Installing the Information Catalog Manager components
Running the information catalog initialization utility
Installing the Information Catalog Manager for the Web
Security considerations
Installing the Information Catalog Manager for the Web on a Windows NT Websphere IBM HTTP Web server
Installing the Information Catalog Manager for the Web on an AIX Websphere IBM HTTP Web server
Installing the Information Catalog Manager for the Web on any Web server
Post-installation customization
Creating a sample information catalog
Setting Up Security for DB2 OLAP Server
Assigning a Relational Database Logon ID to DB2 OLAP Server on Windows NT and UNIX
Granting Authority to DB2 OLAP Server
Creating and Deleting a Relational Database
Cataloging Databases as Remote on AIX and HP-UX
Changing Database Settings
Managing the Size of Your Database Log File
Setting the Commit Block Parameter
Allocating Space in Your Database Log Files
Using Table Spaces
Defining Storage Architecture on UNIX and Windows NT Servers
Setting Database Buffer Pool Sizes
Ensuring Data Integrity
Restructuring a Multidimensional Database
Defragmenting (Reorganizing) Your Relational Database
Defragmenting on Windows NT and UNIX
Backing up and Restoring Data
Backing up Data
Restoring Data
Troubleshooting
What You Need to Know About Using DB2 OLAP Server
Identifying an Anchor Dimension
Limiting the Number of Dimensions in a Database
Selecting a Storage Manager
Viewing DB2 OLAP Server Run-time Parameters
Loading Data into a Database
How Multidimensional Storage Differs from Relational Storage
Creating Your First OLAP Application
Creating a Multidimensional Database in an Application
Saving the First Outline for a Database
Using Relational Attributes
Adding Relational Attribute Columns to Dimension Tables
Adding Values to Relational Attribute Columns
Using DB2 OLAP Server with a Data Warehouse
Contents of the Configuration File
Editing the Configuration File
Sample Configuration Files
Entering Comments in the Configuration File
The RSM Section
The Application Section
The Database Section
Configuration File Parameters
RDB_NAME
RDB_USERID (for Windows NT and UNIX)
RDB_PASSWORD (for Windows NT and UNIX)
TABLESPACE
ADMINSPACE
KEYSPACE
FACTS
TRACELEVEL
TRACEFILESIZE
ISOLATION
MAXPOOLCONNECTIONS
STARTCONNECTIONS
PARTITIONING
FINDEX
KINDEX
Configuring Hardware
Setting Up Your Environment
Designing the Multidimensional Database
Tuning DB2
Tuning DB2 OLAP Server
Allocating Memory
Tuning Data Loads
Calculating the Database
Tuning the System for Run-time
Using the RUNSTATS Utility on a New Multidimensional Database
DB2 OLAP Server Views
Naming Scheme for Views
Using the Cube Catalog View
Querying Dimension and Member Information
Fact and Star Views
Fact View Name
Fact View Contents
Star View Name
Star View Contents
Using Other Views in SQL Applications
Using Relational Attribute Views
Using User-defined Attribute Views
Using Alias ID Views
Using Linked Reporting Object (LRO) Views
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online