Db2 Data Management Console setup scripts

You can use the setup scripts to validate the prerequisites for setting up Db2® Data Management Console.

For Windows operating system, the setup scripts are located in the following path:
<installed-dmc>\IBM Db2 Data Management Console\resources\bin\dsutil\bin\pre_req_script\

check_dmc_server

Use this script to do the following:
  • Check and get recommendations on the capacity of Db2 Data Management Console such as CPU, memory, storage, and Java™ (JVM).

Run this script as the Db2 Data Management Console administrator.

check_mon_db

Use this script to do the following:
  • Check the monitor database to ensure that the database configuration parameters meet the minimum requirements to collect monitor statistics.
  • Verify whether a user on monitor database meets the minimum required object privileges.
    The following parameters are required for running the check_mon_db script:
    • Monitor DB name
    • userid1
    • password1
    • userid2
    • password2

Run this script as the database administrator.

check_monitor_dbcfg_with_auth

Use this script to check the target database to ensure that the database configuration parameters meet the minimum requirements to collect monitor statistics.

Run this script as the database administrator.

verify_mondb_min

Use this script to verify whether a user on monitor database meets the minimum required object privileges.

Run this script as the database administrator or anyone with privileges from grant to monitored database.

grant_mondb_min

Use this script to grant a user with minimum object privileges on a restrictive monitoring database.

Run this script as the database administrator.

create_repo

Use this script to do the following:
  • Create a repository database with recommended configuration if the repository database does not already exist.
  • Check and get recommendations on various database configurations for the repository database if the specified repository already exists.
  • Create objects in the specified repository database.

Run this script as the database administrator.

create_repodb

Use this script to create a new repository database with recommended configuration.

Run this script as the database administrator.

check_repo_config

Use this script to check and get recommendations for various database configurations for repository database.

Run this script as the database administrator.

create_repo_objects

Use this script to create objects in the specified repository database.

This script requires <DMC_install_dir>/samples/DB2LUW/create.sql and <DMC_install_dir>/samples/DB2LUW/pre-create.sql to be placed under the same directory level as create_repo_objects script.

Run this script as the database administrator.

If you want to create the repository objects as a normal Db2 user, then the database administrator must grant privileges to the normal Db2 user. The normal Db2 user can then connect to the database and create the repository objects.

create

Use this script to create buffer pool and table space as needed and also to create various repository objects.

Run this script as the system administrator.

check_repo_server

Use this script to do the following:
  • Check and get recommendations on the repository server capacity such as CPU, memory, and storage.
  • Check and get recommendations on various database configurations for repository database.
  • Verify whether a user on repository database meets the minimum required object privileges.

Run this script as the database administrator.

check_repo_config

Use this script to check and get recommendations on various database configurations for repository database.

Run this script as the database administrator.

check_repo_capacity

Use this script to check and get recommendations on repository server capacity such as CPU, memory, and storage.

Run this script as the database administrator.

verify_repodb_min

Use this script to verify whether a user on repository database meets the minimum required object privileges.

Run this script as a user granted with minimum required object privileges..

grant_repodb_min

Use this script to grant a user with minimum privileges on repository tables and functions.

Run this script as the database administrator.