Creating a repository database for Data Server Manager

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 Data Server Manager so that you can set up and use the product with the features that rely on historical persistence, or you can create the repository database later when you are ready to start using these features.

About this task

IBM® Data Server Manager (DSM) uses the repository database to 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. Without a repository database, you can still use the product for real-time monitoring, database exploration, and database administration.

Required privileges

The DSM repository database can reside on either a Db2 server or a Db2 for z/OS® server. DSM 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.
  • For a Db2 for z/OS database, the user can use the SYSADM SQLID
For a full listing of the privileges needed to enable a repository database on both of these database platforms, refer to the following pages:
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 DSM 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 one of the following procedures to create the repository database:

    Creating a Db2 repository database

    Creating a Db2 for z/OS repository database

  2. After you create the repository database, specify the connection information to the database. You can use the setup.conf file before you set up the DSM Enterprise Edition product. After you have set up the Enterprise Edition product, you can navigate to Settings > Product Setup > Repository Database Configuration. 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.
  3. To make use of the historical features of Data Server Manager, enable repository persistence for the monitoring profiles that you will use. You can modify monitoring profiles from the Settings > Monitoring Profiles task.