Welcome
HCL Workload Automation
Welcome to the HCL Workload Automation documentation, where you can find information about how to install, maintain, and use HCL Workload Automation. The documentation has been updated for HCL Workload Automation Version 10.2.3.
Administration Guide
Data maintenance
Administrative tasks - DB2®

Product requirements
This section contains links to the HCL Workload Automation Product Requirements.
Overview
Mobile Applications Userʼs Guide
Dynamic Workload Console User's Guide
AI Data Advisor (AIDA) User's Guide
Scheduling Job Integrations with HCL Workload Automation
HCL Workload Automation
Welcome to the HCL Workload Automation documentation, where you can find information about how to install, maintain, and use HCL Workload Automation. The documentation has been updated for HCL Workload Automation Version 10.2.3.
- Planning and Installation
- User's Guide and Reference
- Administration Guide
  - Customizing and configuring HCL Workload Automation
  - Configuring the Dynamic Workload Console
  - Configuring user authorization (Security file)
  - Configuring authentication
  - Network administration
  - Configuring secure communications
    HCL Workload Automation ensures your business operations are always secure with robust, authenticated, and encrypted connections powered by the Secure Sockets Layer (SSL) protocol.
  - Data maintenance
    - Backing up and restoring the database
    - Reorganizing the DB2 database
    - Maintaining the file system
    - Administrative tasks - DB2®
    - Administrative tasks - Oracle
    - Customizing your RDBMS server
    - Connecting the master domain manager to a new database
      Connecting the master domain manager to a new database involves reconfiguring the system to recognize and interact with the new database. This process typically includes updating connection strings, ensuring database drivers are compatible, migrating relevant data, and validating connectivity. This ensures the master domain manager can continue to perform its tasks without interruption, leveraging the new database resources and capabilities.
    - Auditing facilities
      Describes the audit facilities to track changes in the database and the plan, as well as those that track changes to objects involved in dynamic workload scheduling.
    - Collecting job metrics
  - Administrative tasks
  - Administering IBM i dynamic environment
    On overview on how to administer the HCL Workload Automation IBM i dynamic environment.
  - Performance
  - Availability
  - License computation model
- Scheduling with the Agent for z/OS
- Database Views
- High Availability Cluster Environment
- Driving HCL Workload Automation
- Extending HCL Workload Automation
HCL Workload Automation for Z
Welcome to the HCL Workload Automation for Z documentation, where you can find information about how to install, maintain, and use the product.
Messages and Codes
Glossary
Notices

Administrative tasks - DB2®

A set of scripts and SQL files is provided to perform actions such as granting rights or reorganizing the database. These files are located in inst_dir/dbtools/db2/script. To use these files, copy the relevant folder to the database server. The DB2® tools must be run by a user who has the following permissions:

DB2 administrator permissions – the user must be defined to DB2 as a DB2 Administrator
Full access (777) to the HCL Workload Automation installation directory

The available files are as follows:

dbrunstats: This script runs the DB2 statistics program, to maximize the performance of DB2.
dbreorg: This script reorganizes the database. See Reorganizing the DB2 database for a full description of how to use the tool.
dbgrant: This script adds grants to new users on HCL Workload Automation DB schema for the views that can be used to generate reports

To find out how to perform specific administrative tasks on DB2®, see:

To add feedback about this topic, select the following checkbox:

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners Four, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site. Personal data should not be shared in this comment box. See our Privacy Statement to understand how personal data is used.