Creating a repository database

You can create a repository database by using the Db2® administration tool of your choice, such as the Db2 command line processor. You can create the repository before you install IBM® Db2 Data Management Console so that you can set up and use the product features such as Monitoring, Run SQL, Explore and more.

About this task

IBM Db2 Data Management Console uses the repository database to save its metadata and enable features that rely on historical persistence. With a repository database, you can record monitoring metrics for historical analysis, identify storage access patterns for capacity planning, and track configuration changes for problem determination.

A repository database is required if you want to use IBM Db2 Data Management Console.
Note: It is recommended to use circular logging when you create a repository database. For more information, see Circular logging.

You can also continue to use the Data Server Manager repository and upgrade IBM Data Server Manager to IBM Db2 Data Management Console v3.1.x. For more information, see Upgrading Data Server Manager to Db2 Data Management Console.

Note: If your Db2 Data Management Console repository database is hosted by a Db2 server, you can download and use the restricted Db2 Standard Edition license key from the Db2 Download Center. This restricted license can only be used for the purpose of setting up a repository database for Db2 Data Management Console. You can learn more about the terms and conditions by reading the license agreement.

Required privileges

The IBM Db2 Data Management Console repository database resides on a database server. The console will use the ID and password that you provide to create the necessary objects in the repository database. Make sure that the account you use has been granted the proper privileges to enable a repository database:
  • For a Db2 repository database, the user must have the DBADM and SYSCTRL privileges.
To use a repository database, you must create a dedicated database for the repository that meets the following criteria:
  • The database must be used for only the Db2 Data Management Console repository. Do not use an existing database and do not store additional information in the repository database.
  • The database cannot use the Db2 database partitioning feature (DPF) or pureScale®.
  • The database must have a temporary table space with a page size of at least 8 KB.
  • The database must be of Unicode type to avoid SQL language errors.

Procedure

  1. Use the following procedure to create the repository database:
  2. After you create the repository database, and completing the set up of IBM Db2 Data Management console, you can configure the repository database. At this point, the database is configured with the required tables and objects.
    Note: Ensure that the user ID that you specify for the connection has DBADM WITH DATAACCESS authority for the repository database.