Prepare DB2 metadata

The DB2 Task Center, scheduler and Information Catalog Center use a database to store metadata. These metadata tables, called the DB2 tools catalog, are used by the DB2 Administration Server (DAS) to store scheduling information. For full functioning of the administration tools, it is recommended that scheduling be enabled, but it is not required.

There can be multiple tools catalogs on the same system, but only one tools catalog can be actively used by a DB2 scheduler at any given time.

The DB2 warehouse tools require a database to store metadata. These metadata tables, called the warehouse control database, are required for the Data Warehouse Center to function.

The warehouse control database can be stored in a local or remote database. You can set up a local database now. If you want to use a remote database, you must set it up manually after the installation.

For information about setting up a remote database after DB2 is installed, refer to the Data Warehouse Center Administration Guide.

You may prepare a local database to hold the DB2 tools catalog or the warehouse control database, or you may prepare a local database to hold both, or you can choose to not prepare any metadata at this time. If you would like to store all the metadata in a remote database you must set the data base up after installation. If you would like to store the metadata in two different databases, you can prepare either one now, and set up the other database after installation.

For more information on setting up the DB2 tools catalog after installation, see the Administration Guide.

For more information on setting up the warehouse control database after installation, see the Data Warehouse Center Administration Guide.