Database administrative tasks - Db2
Several scripts are provided to manage the database for the server components and the Dynamic Workload Console, performing tasks such as granting permissions and reorganizing databases.
The path and the available database tools vary depending on the
component, as follows:
- master domain manager and backup master domain manager
- <MDM_installation_directory>/TWS/dbtools/<database_vendor>/<OS_type>/scripts
- dynamic domain manager and backup dynamic domain manager
- <DDM_installation_directory>/TDWB/dbtools/<database_vendor>/<OS_type>/scripts
- Dynamic Workload Console
- <DWC_installation_directory>/DWC/dbtools/<database_vendor>/<OS_type>/scripts
To use these scripts, copy the relevant folder to the database server. The scripts must
be run by a user who has the following permissions:
- Database administrator permissions
- Full access to and control of the HCL Workload Automation or Dynamic Workload Console installation directory
The available files are as follows:
- dbgrant
- This script grants read permissions to users on the HCL Workload Automation and Dynamic Workload Console database schemas. These permissions apply to the specific views used for report generation.
- dbmove
- This script is to be run only if requested by Software Support. Note: Do not run the dbmove script unless instructed to do so by Software Support. Running the script autonomously might damage or overwrite the data in your database.
- dbreorg
- This script reorganizes the database. See Reorganizing the Db2 database for a full description of how to use the tool.
- dbrunstats
- This script runs the Db2 statistics program, to maximize database performance. For more information, see Running Db2 maintenance manually.
To find out how to perform specific administrative tasks on Db2, see: