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.8.
Planning and Installation
Upgrading
How to upgrade HCL Workload Automation to the current version.
Upgrading from the CLI
Upgrade HCL Workload Automation from the command-line interface.
Parallel upgrade from version 9.4.0.x to version 10.2.8
Detailed steps to perform a parallel upgrade from version 9.4.0.x to version 10.2.8
Creating and populating the database for the Dynamic Workload Console
Create and populate the database for the Dynamic Workload Console

Product requirements
This section contains links to the HCL Workload Automation Product Requirements.
Overview
Best practices
Mobile Applications Userʼs Guide
Dynamic Workload Console User's Guide
AI Data Advisor (AIDA) User's Guide
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.8.
- Planning and Installation
  - Planning your HCL Workload Automation environment
    HCL Workload Automation orchestrates unattended, scheduled, and event-driven tasks for business and IT processes across on-premises and cloud environments organized in a network. A network consists of a set of linked workstations on which you perform job scheduling and processing to automate and manage your workflows. An HCL Workload Automation network is composed of a master domain manager, one or more Dynamic Workload Console servers, dynamic domain managers, and dynamic agents. You might also have fault-tolerant agents, extended agents, standard agents connected to the master domain manager or to domain managers.
  - Installing HCL Workload Automation
    Available installation methods
  - Configuring
    Configuring HCL Workload Automation components after installation.
  - Upgrading
    How to upgrade HCL Workload Automation to the current version.
    - Downloading installation images on your workstation
      Steps to take when downloading images on your workstation.
    - Upgrading from the CLI
      Upgrade HCL Workload Automation from the command-line interface.
      - Before upgrading
        Before starting to upgrade the product, verify that your network has the minimum required supported versions of the operating system, product, and database.
      - Performing a direct upgrade from v 9.5.0.x or 10.x.x to v 10.2.8
        Detailed steps to perform a direct upgrade from version 9.5.0.x or v 10.x.x to version 10.2.8
      - Parallel upgrade from version 9.5.0.x or 10.x.x to version 10.2.8
      - Parallel upgrade from version 9.4.0.x to version 10.2.8
        Detailed steps to perform a parallel upgrade from version 9.4.0.x to version 10.2.8
        Configuring TLS to the appropriate version
        Transport Layer Security (TLS) is a cryptographic protocol designed to provide secure communication over a computer network. It ensures that data transmitted between applications, such as web browsers and servers, remains private and tamper-proof. Setting TLS to version 1.2 is required to ensure communication between 9.4 and 10.2.8 components.
        Converting default certificates
        Procedure to extract and convert default certificates generated in your current version prior to upgrading.
        Installing Open Liberty or WebSphere Application Server Liberty Base
        Installing Open Liberty or WebSphere Application Server Liberty Base to the latest supported version.
        Encrypting passwords (optional)
        How to encrypt passwords required by the installation process
        Creating and populating the database for the Dynamic Workload Console
        Create and populate the database for the Dynamic Workload Console
        DB2 - Dynamic Workload Console
        Instructions for creating and populating the Dynamic Workload Console database for DB2
        DB2 for z/OS - Dynamic Workload Console
        Instructions for creating and populating the database for DB2 for z/OS for Dynamic Workload Console
        PostgreSQL - Dynamic Workload Console
        Instructions for creating and populating the Dynamic Workload Console database for PostgreSQL
        Oracle and Amazon RDS for Oracle - Dynamic Workload Console
        Instructions for creating and populating the Dynamic Workload Console database for Oracle and Amazon RDS for Oracle
        Informix - Dynamic Workload Console
        Instructions for creating and populating the Dynamic Workload Console database on UNIX operating systems. Both the database and the Dynamic Workload Console must reside on UNIX operating systems.
        MSSQL - Dynamic Workload Console
        Instructions for creating and populating the Dynamic Workload Console database for MSSQL
        MSSQL cloud-based databases - Dynamic Workload Console
        Instructions for creating and populating the Dynamic Workload Console database for MSSQL cloud-based databases
        Installing the Dynamic Workload Console
        Procedure for installing two Dynamic Workload Console servers on two separate nodes.
        Creating the HCL Workload Automation administrative user
        Instructions to create the HCL Workload Automation administrative user
        Upgrading the database for the server components
        Upgrade the master domain manager database tables before upgrading the server components.
        Installing a new dynamic domain manager configured as a backup
        Install a new dynamic domain manager configured as a backup and link it to your current network. Then switch it to become the new dynamic domain manager.
        Installing the new master domain manager configured as a backup
        Install the new master domain manager configured as a backup and link it to your current network. Then switch it to become the new master domain manager.
        Installing a new backup master domain manager
        Upgrading your old master domain manager, which is now your current backup master domain manager to the latest product version level.
        Upgrading agents and domain managers
        There are several methods you can choose from to upgrade your domain managers and agents.
      - Enabling product encryption after upgrading
        Enabling product encryption after upgrading from a version earlier than 10.1.
      - Enabling API Key authentication after upgrading
        Enabling API Key authentication after upgrading from v 10.x.x or v 9.5.x to 10.2.x.
      - Upgrading when there are corrupt registry files
      - Upgrading in a mixed-version environment when using default certificates
        Upgrading in a mixed-version environment when using default certificates
    - Updating containers
      Updating the container configuration parameters.
    - FAQ - Upgrade procedures
      A list of questions and answers related to upgrade procedures:
  - Enabling and disabling FIPS
    FIPS is a U.S. government security standard that defines security requirements for cryptographic modules used to protect sensitive information. FIPS 140-3 is the latest version of the U.S. and Canadian government security standard that defines security requirements for cryptographic modules in IT and telecommunications products. Its purpose is to ensure that products handling sensitive data via cryptography are secure and reliable. Federal agencies must use FIPS 140-3 validated modules. It is also widely adopted by defence contractors and financial institutions.
  - Moving from on-premises to cloud
    A quick procedure to move your workload from an on-premises to a cloud environment
  - Troubleshooting installation, migration, and uninstallation
    An overview on troubleshooting installation, migration, and uninstallation of the HCL Workload Automation.
  - Uninstalling
    An overview on how to uninstall the product.
  - Reference
- User's Guide and Reference
- Administration Guide
- Scheduling with the Agent for z/OS
- Database Views
- High Availability Cluster Environment
- Troubleshooting
- Driving 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. The documentation has been updated for version 10.2 Fix Pack 5.
Messages and Codes
Glossary
Product library in PDF format
Notices

Creating and populating the database for the Dynamic Workload Console

Create and populate the database for the Dynamic Workload Console

About this task

Creating and populating the Dynamic Workload Console database

If you are using a database other than Derby, create and populate the database tables for the Dynamic Workload Console by following the procedure appropriate for your RDBMS: