Db2 Data Management Console setup scripts
You can use the setup scripts to validate the prerequisites for setting up Db2® Data Management Console.
<installed-dmc>\IBM Db2 Data Management Console\resources\bin\dsutil\bin\pre_req_script\
check_dmc_server
- 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
- 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
- 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
- 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.