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.
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.3
Detailed steps to perform a parallel upgrade from version 9.4.0.x to version 10.2.3
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
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
  - 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.3
        Detailed steps to perform a direct upgrade from version 9.5.0.x or v 10.x.x to version 10.2.3
      - Parallel upgrade from version 9.5.0.x or 10.x.x to version 10.2.3
      - Parallel upgrade from version 9.4.0.x to version 10.2.3
        Detailed steps to perform a parallel upgrade from version 9.4.0.x to version 10.2.3
        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.3 components.
        Converting default certificates
        Procedure to extract and convert default certificates generated in your current version prior to upgrading.
        Installing WebSphere Application Server Liberty
        Installing WebSphere Application Server Liberty to the latest supported version. This is an optional step you might want to perform before you upgrade the Dynamic Workload Console and the server components.
        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
        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
        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:
  - 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
- 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

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 currently using Derby, you need to install a supported database and migrate your data. This is necessary because Derby is no longer supported as of version 10.2.3. For more information, see Connecting the Dynamic Workload Console to a new node or 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:

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.