IBM Workload Automation supports multiple cloud-based databases, including Amazon RDS for MSSQL. This guide outlines the steps to create and populate the IBM Workload Scheduler database for MSSQL cloud environments, specifically for the Master Domain Manager and Dynamic Workload Console.

Prerequisites

Before proceeding, ensure you have:

  • An Amazon RDS for MSSQL instance set up and running.
  • A database user with appropriate permissions (avoid using the administrator account for schema creation).
  • Network connectivity between IBM Workload Scheduler components and the RDS instance.

Step 1: Creating the IBM Workload Scheduler Database

Run the ConfigureDB Command

To create and populate the IBM Workload Scheduler database, use the following command based on your operating system:

For Windows:

cscript configureDb.vbs –rdbmstype MSSQL –dbname db_name –dbhostname db_hostname –dbadminuser db_admin_user –dbadminuserpw db_admin_password –iwstsname DATA_tablespace_name –iwslogtsname LOG_tablespace_name –iwsplantsname PLAN_tablespace_name

For UNIX/Linux:

./configureDb.sh –rdbmstype MSSQL –dbname db_name –dbhostname db_hostname –dbadminuser db_admin_user –dbadminuserpw db_admin_password –iwstsname DATA_tablespace_name –iwslogtsname LOG_tablespace_name –iwsplantsname PLAN_tablespace_name

Command Parameters:

  • –rdbmstype: Specifies the database type (MSSQL).
  • –dbhostname: The hostname or IP of the RDS instance.
  • –dbname: The name of the IBM Workload Scheduler database.
  • –dbadminuser: The database administrator user.
  • –dbadminuserpw: The password for the administrator user.
  • –iwstsname: Tablespace for Workload Scheduler data.
  • –iwslogtsname: Tablespace for Workload Scheduler logs.
  • –iwsplantsname: Tablespace for Workload Scheduler plans.

Note: Ensure consistency in parameters when setting up both the Master Domain Manager and the Dynamic Workload Console.

Step 2: Setting Up the Dynamic Workload Console Database

To create and populate the Dynamic Workload Console database, use:

For Windows:

cscript configureDb.vbs –rdbmstype MSSQL –dbname db_name –dbhostname db_hostname –dbadminuser db_admin_user –dbadminuserpw db_admin_password –iwstsname DATA_tablespace_name

For UNIX/Linux:

./configureDb.sh –rdbmstype MSSQL –dbname db_name –dbhostname db_hostname –dbadminuser db_admin_user –dbadminuserpw db_admin_password –iwstsname DATA_tablespace_name

Step 3: Creating the IBM Workload Scheduler Administrative User

The IBM Workload Scheduler requires an administrative user (wauser) to manage scheduling objects.

For Windows:

  • The user is created automatically if it does not exist.
  • If using a domain account, specify domain_name\user_name.
  • For local users, use system_name\user_name.

For UNIX/Linux:

  • Manually create the user before installation.
  • Ensure the user has a home directory and assigned group.
  • Avoid group names containing / to prevent permission issues.

Final Steps

Once the database and administrative user setup is complete, proceed with installing the Master Domain Manager and Backup Master Domain Manager.

For more details on configurations and installation, refer to the IBM Workload Automation documentation.

By following these steps, you ensure a seamless and optimized setup of Amazon RDS for MSSQL as the back-end database for IBM Workload Automation. Happy automating!