Creating, upgrading, and deleting OLAP Metadata Catalogs

Before you run DB2 OLAP Integration Server, you must create an OLAP Metadata Catalog to store the OLAP models that you create and the metaoutlines that you build from the OLAP models.

Note:
If you intend to use the Sample application to acquaint yourself with Integration Services, skip to Setting up the sample application for DB2 OLAP Integration Server. The Sample application has its own relational data source, OLAP Metadata Catalog, OLAP model, and metaoutline. Return to this chapter when you are ready to use a relational data source to build OLAP models and metaoutlines.

It is recommended that you use the automatic installation process to install the Sample applications. See Setting up the standard sample application automatically.

This chapter tells you what to consider before you create an OLAP Metadata Catalog in a relational database. You can create the catalog either automatically, through the use of Integration Services Console, or manually. You can also create an Unicode-enabled OLAP Metadata Catalog. For manual creation of an OLAP Metadata Catalog, this chapter lists the SQL scripts that you must run to create tables for the catalog. The procedures in this chapter assume that you know how to create tables by running SQL scripts.

This chapter contains the following topics: