HCL Workload Automation, Version 9.4

Customizing the properties file for Microsoft SQL Server

Before you proceed to customize the properties file, you must have created the directories where the TWS_TS_NAME, TWS_LOG_TS_NAME, and TWS_TS_PLAN_NAME table spaces will be placed when the HCL Workload Automation schema is created. Default directories are:
  • C:\MSSQL\TWS_DATA for TWS_TS_NAME table space.
  • C:\MSSQL\TWS_LOG for TWS_LOG_TS_NAME table space.
  • C:\MSSQL\TWS_PLAN for TWS_TS_PLAN_NAME table space.
To customize the properties file, perform the following steps:
  1. From the eImage containing the master domain manager or the dynamic domain manager, open the following properties file: 
    <images_dir>\dbtools\customizeWinMSSQLSql.properties
    where: <images_dir> specifies the directory where you extracted the product image.
  2. Customize the SQL properties with the values appropriate for your needs:
    TWSTEMPDIR
    The directory where you want to store the SQL scripts to create the database tables. The default value is:
    C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\TWA\tws
    DB_USER
    The ID of the user that accesses the HCL Workload Automation and the dynamic workload broker database. The default is the DB administrator.

    When you run the customization script (Installing for a Microsoft SQL Server database), you must specify this value in the dbUser field.

    TWS_USER
    The HCL Workload Automation user name specified also when installing the master domain manager or the dynamic domain manager.

    When you run the customization script (Installing for a Microsoft SQL Server database), you must specify this value in the twsUser field.

    TWS_DB
    The name of the HCL Workload Automation database. The default value is TWS.

    When you run the customization script (Installing for a Microsoft SQL Server database), you must specify this value in the dbName field.

    COMPANY_NAME
    The name of the company. You can use spaces and the maximum field length is 40 characters. The default is MYCOMPANY.
    EIF_PORT
    The port used by the event management processor to receive events. The valid range is from 1 to 65535. The default value is 31131.
    HOST_NAME
    The fully qualified host name or IP address of the dynamic workload broker.
    WAS_SEC_PORT
    The HTTPS port of the dynamic workload broker. The dynamic agent uses it to connect to the dynamic workload broker. The valid range is from 1 to 65535. The default value is 31116.
    TWS_TS_NAME
    The name that identifies the HCL Workload Automation data table space. The default for this field is TWS_DATA.
    TWS_DATA_TS_PATH
    The path to the HCL Workload Automation data table space. The default is C:\MSSQL\TWS_DATA. The C:\MSSQL\TWS_DATA path must already exist in the filesystem.
    TWS_LOG_TS_NAME
    The name of the tablespace for the HCL Workload Automation log. The default value for this field is TWS_LOG.
    TWS_LOG_TS_PATH
    The path to the HCL Workload Automation log table space. The default is C:\MSSQL\TWS_LOG. The C:\MSSQL\TWS_LOG path must already exist in the filesystem.
    TWS_PLAN_TS_NAME
    The name of the tablespace for the HCL Workload Automation plan. The default value for this field is TWS_PLAN.
    TWS_PLAN_TS_PATH
    The path to the HCL Workload Automation plan table space. The default is C:\MSSQL\TWS_PLAN. The C:\MSSQL\TWS_PLAN path must already exist in the filesystem.
    DB_USE
    The value for this field is MSSQL. Do not change it or the customization process will fail.
    MASTERDOM_NAME
    The value for this field is MASTERDM. Do not change it or the customization process will fail.
Parent topic: Creating or upgrading the database schema if you are using Microsoft SQL Server