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.
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.
Required privileges
- For a Db2 repository database, the user must have the DBADM and SYSCTRL privileges.
- 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.