Tivoli Workload Automation, Version 9.2

Customizing the properties file for Oracle

To customize the properties file, perform the following steps:
  1. From the installation DVD or 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\customizeWinOracleSql.properties
    On UNIX and Linux systems:
    <images_dir>/dbtools/customizeUnixOracleSql.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:
    On Windows operating systems:
    C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\TWA\tws92
    On UNIX and Linux systems:
    /tmp/TWA/tws92
    MDL_USER
    The database administrator user name (such as SYSTEM) that accesses the Tivoli Workload Scheduler and the dynamic workload broker database. It is a user that must be created on Oracle; it is not an operating system user.

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

    TWS_PASSWORD
    The password of the MDL_USER.

    When the IT administrator installs the product, he must specify this value in the Oracle administrator user password field.

    TWS_USER
    Specify the Tivoli® Workload Scheduler 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_TS_NAME
    The name that identifies the Tivoli Workload Scheduler data table space. The default for this field is USERS.

    When the IT administrator installs the product, he must specify this value in the Tivoli Workload Scheduler data tablespace field.

    TWS_LOG_TS_NAME
    The name that identifies the Tivoli Workload Scheduler table space where report data is to be stored. You can view the report data by using the Dynamic Workload Console. The default value for this field is USERS.

    When the IT administrator installs the product, he must specify this value in the Tivoli Workload Scheduler reports tablespace field.

    TWS_TS_TEMP_NAME
    The name that identifies the Tivoli Workload Scheduler temporary table space. The default value for this field is TEMP.

    When the IT administrator installs the product, he must specify this value in the Tivoli Workload Scheduler temporary tablespace 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 valid range is from 1 to 65535. The default value is 31131.

    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 HTTPS port of the Tivoli dynamic workload broker. The dynamic agent uses it to connect to the Tivoli dynamic workload broker. The valid range is from 1 to 65535. The default value is 31116. If you leave the field blank, it defaults to 0.

    When the IT administrator installs the product, he must specify this value in the dynamic workload brokerHTTPS port number field.

    ORACLE_HOME
    Specify the path of the Oracle installation.