OLAP Setup and User's Guide

Contents of the Configuration File

The relational storage manager configuration file (rsm.cfg) contains parameters that determine:

• The relational database in which DB2 OLAP Server stores your multidimensional data
• The user ID and password that DB2 OLAP Server uses to log on to your relational database
• The level of detail provided by the DB2 OLAP Server trace facility
• The file in which the trace information is stored
• The size of the trace file
• The isolation level that DB2 OLAP Server uses when working with your relational database
• The maximum number of connections to your relational database that DB2 OLAP Server can own
• The number of connections an OLAP application starts when it is activated
• The table space in which DB2 OLAP Server creates relational tables
• The table space in which DB2 OLAP Server creates the fact table
• The table space in which DB2 OLAP Server creates administration tables
• The addition of a partitioning key clause to the SQL statement DB2 OLAP Server uses to create the fact table
• The table space for the relational database index of a fact table when you are using DB2 OLAP Server on a UNIX or Windows NT platform to access data in DB2 on OS/390.
• The table space for the relational database index of a key table when you are using DB2 OLAP Server on a UNIX or Windows NT platform to access data in DB2 on OS/390. A relational database key table is the equivalent of a multidimensional database index.
• Whether to create a cluster index for a fact table when you are using DB2 OLAP Server to access data in DB2 on OS/390.