HCL Workload Automation, Version 9.4

Customizing the properties file for Informix Dynamic Server

Unless you are upgrading the HCL Workload Automation schema, before you proceed to customize the properties file, you must have created the following db and sb spaces:
  • A db space sized 100 MB and with a page size of 8K or greater, referred to as DBSPNAME in the properties file customization steps.
  • A db space space sized 20 MB, referred to as TWS_DBSP_LOG in the properties file customization steps.
  • An sb space for blob and clob data, sized 100 MB, referred to as TWS_SBSP in the properties file customization steps.
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:
    On Linux systems:
    <images_dir>/dbtools/customizeUnixIDSSql.properties
    where: <images_dir> specifies the directory where you extracted the product image.
  2. Customize the SQL properties with the values that best fit your needs:
    TWSTEMPDIR
    The directory where you want to store the SQL scripts to create the database tables. The default value is:
    On Linux systems:
    /tmp/TWA/tws
    DB_USER
    The database administrator user name (such as Informix) that accesses the HCL Workload Automation and the dynamic workload broker database.

    When you run the customization script (Installing for an Informix Dynamic Server), you must specify this value in the dbUser field.

    TWS_USER
    Specify the HCL Workload Automation user name.

    When you run the customization script (Installing for an Informix Dynamic Server), 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 an Informix Dynamic Server), 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_SBSP
    The name that identifies the HCL Workload Automation sb space. The default for this field is twssbspace.
    TWS_DBSP_LOG
    The name that identifies the HCL Workload Automation db space where log data is to be stored. The default value for this field is twsdbs.
    TWS_DBSP_LOG_RULE
    The name of the db space for LOG RULE. The default value for this field is twsdbs<version_number>.
    TWS_DBSP_LOG_ACTION
    The name of the db space for LOG ACTION. The default value for this field is twsdbs<version_number>.
    TWS_DBSP_LOG_MESSAGE
    The name of the db space for LOG MESSAGE. The default value for this field is twsdbs<version_number>.
    TWS_DBSP_LOG_AUDIT
    The name of the db space for LOG AUDIT. The default value for this field is twsdbs<version_number>.
    TWS_DBSP_LOG_AUDIT_S
    The name of the db space for LOG AUDIT_S. The default value for this field is twsdbs<version_number>.
    DBSPNAME
    The name of the db space for the database. The default value for this field is twsdbs<version_number>.
    DB_USE
    The value for this field is IDS. 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 Informix Dynamic Server