HCL Workload Automation, Version 9.4

Customizing the properties file for DB2

Steps that need to be taken to customize the property file for DB2.

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 Windows operating systems:
    <images_dir>\dbtools\customizeWinDB2Sql.properties
    On UNIX and Linux systems:
    <images_dir>/dbtools/customizeUnixDB2Sql.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 or update the database tables. The default value is:
    On Windows operating systems:
    C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\TWA\tws
    On UNIX and Linux systems:
    /tmp/TWA/tws
    DB_USER
    If you are creating the database tables before installing the product:
    Specify the user to be granted access by the administrator of the DB2 server to access the HCL Workload Automation database.
    When the IT administrator installs the product, he must specify this value in the DB2 server administrator user field.
    On Windows operating systems:
    The default value is db2admin.
    On UNIX and Linux operating systems:
    The default value is db2inst1.

    On UNIX, verify that you can switch to this user and that it can load the DB2 environment.

    If you are upgrading the database tables before upgrading the product:
    Specify the user that you used when you installed the version of the product you are upgrading. When you later upgrade the product, you can specify a user different from the one you specified in the DB_USER field, but it must have database access permissions.
    TWS_USER
    Specify the HCL Workload Automation user name.

    It can contain alphanumeric, dash (-), and underscore (_) characters; it cannot contain national characters. The first character of the user name must be a letter.

    When the IT administrator installs the product, he must specify this value in the User name field.

    TWS_DB
    The name of the DB2 database. The maximum length is five characters. The default value is TWS. If you are creating the SQL tables for a:
    Master domain manager
    Provide the name of a database that is not used by a dynamic domain manager.
    Dynamic domain manager
    Provide the name of a database that is not used by a master domain manager.

    When the IT administrator installs the product, he must specify this value in the Database name field.

    TWS_TS_NAME
    The name of the DB2 instance table space. This table space is used to store scheduling objects and event rules. For information about DB2® table spaces, see the DB2 documentation. The default table space name is TWS_DATA.

    When the IT administrator installs the product, he must specify this value in the Table space name field.

    TWS_DATA_TS_PATH
    The relative path of the DB2 table space. The path can be a relative or a fully qualified path. When the table space path is a fully qualified path, the DB2 administrator user must have complete access rights to the directory where the table space is installed. The default table space path name is TWS_DATA. For UNIX and Linux operating systems, make sure that the DB2 administrator has write access to the directory above the table space directory.

    When the IT administrator installs the product, he must specify this value in the Table space path field.

    TWS_LOG_TS_NAME
    Specify the name of the DB2 table space where HCL Workload Automation event logs are to be stored. These logs include data about event rule instances, triggered actions, and operator messages that are displayed by the Dynamic Workload Console. Data from the logs can be used to create reports. You can view report data by using the Dynamic Workload Console. The default name is TWS_LOG.

    When the IT administrator installs the product, he must specify this value in the Report tablespace name field.

    TWS_LOG_TS_PATH
    Specify the path of the DB2 table space where HCL Workload Automation event logs are to be stored. The default path is TWS_LOG. The path can be a relative or a fully qualified path. When the table space path is a fully qualified path the DB2 administrator user must have complete access rights to the directory where the table space is installed. For more information, see DB2 tablespace relative paths.
    Note: The report table space path cannot be the same as the table space path.

    When the IT administrator installs the product, he must specify this value in the Report table space path field.

    TWS_PLAN_TS_NAME
    Specify the name of the DB2 table space where HCL Workload Automation stores the Plan. The default name is TWS_PLAN.

    When the IT administrator installs the product, he must specify this value in the Plan table space name field.

    TWS_PLAN_TS_PATH
    Specify the path of the DB2 table space where the HCL Workload Automation Plan is stored. The default path is TWS_PLAN. The path can be a relative or a fully qualified path. When the table space path is a fully qualified path the DB2 administrator user must have complete access rights to the directory where the table space is installed. For more information, see DB2 tablespace relative paths.
    Note: The plan table space path cannot be the same as the table space path or the report table space path.

    When the IT administrator installs the product, he must specify this value in the Plan table space path field.

    COMPANY_NAME
    The name of the company. You can use spaces and the maximum field length is 40 characters. The default is MYCOMPANY.

    When the IT administrator installs the product, he must specify this value in the Company field.

    EIF_PORT
    The port used by the event management processor to receive events. The default value is 31131. The valid range is from 1 to 65535.

    When the IT administrator installs the product, he must specify this value in the Event Processor field.

    HOST_NAME
    The fully qualified host name or IP address on which the dynamic domain manager is contacted by the dynamic agent.

    When the IT administrator installs the product, he must specify this value in the dynamic agent configuration information Host name or IP address field.

    WAS_SEC_PORT
    The WebSphere Application Server HTTPS transport port. The port for the secure HTTP transport. It is used by the composer command line and the Dynamic workload broker when this protocol is selected. The dynamic agent uses it to connect to the dynamic workload broker. The default value is 31116. If you leave the field blank, it defaults to 0. The valid range is from 1 to 65535.

    When the IT administrator installs the product, he must specify this value in the WebSphere Application ServerHTTPS transport port.

    DB2LOCALADMINUSER
    DB2 Server
    Specify the user to be granted access by the administrator of the DB2 server to access the HCL Workload Automation database. The value must be the same as the DB_USER variable.
    DB2 Client
    Specify the local DB2 administrator user of the DB2 client instance.
    DB2DIR
    Specify the path of the DB2 installation.