Creating a Db2 repository database
You can create a Db2® repository database by using the Db2 administration tool of your choice, such as the Db2 command line processor.
Before you begin
- Ensure that a supported version of the database is installed on the system on which you want to host the repository database (Db2 version 11.1 or later). For more information, see System requirements for IBM Db2 Data Management Console.
- Ensure that Oracle compatibility is disabled on your repository database. Differences in how timestamps are calculated in this mode will cause the Data Management Console to fail.
- When running the CREATE DATABASE command, ensure that the AUTOMATIC STORAGE option is set to YES.
- Create or identify a database user ID that will be used by IBM®
Db2 Data Management Console to connect
to the repository database. This user ID must have the following minimum authorities:
- DBADM WITH DATAACCESS on the database
- SYSCTRL on the database instance
- The repository database should have the following minimum log
settings:
LOGPRIMARY 25 LOGSECOND 200 LOGFILSIZ 8192
- While you can create a repository database within a Db2 instance that is
shared with other applications, an ideal repository database would reside in a dedicated Db2 instance,
particularly when a large number of databases are monitored and managed. The repository would not
compete with other applications and databases that may require more resources for your business
needs. For best results, consider using the most recent version of Db2, and enable adaptive
compression and Db2
storage optimization to best compress the resulting data.Note: It is recommended to use circular logging when you create a repository database. For more information, see Circular logging.
Procedure
To create a Db2 repository database and configure the database logs with the Db2 command-line processor: