HCL Workload Automation, Version 9.4

Procedure to create the HCL Workload Automation SQL schema on Informix

To create the HCL Workload Automation database, perform the following steps:
  1. Log on as root on your Linux system and go to the following directory:
    TWSTEMPDIR/TWS/dbtools/ids/scripts

    Where TWSTEMPDIR is the directory you specified in the TWSTEMPDIR property of the configuration file. For more information about how to customize the property file, see Customizing the properties file for Informix Dynamic Server.

  2. Run the following command:
    createdb_root.sh 
    <TWS_HOST> <TWS_SRVC_PORT>
    <TWS_DB_USER> <TWS_DB_PW>
    <TWS_DB> <TWS_DBSP_NAME>
    <IS_BKM> <IS_PARTITIONED>
    <TWS_GRANT_USER>
    Where:
    <TWS_HOST>
    The IP address or host name of the workstation where Informix Dynamic Server is installed.
    <TWS_SRVC_PORT>
    The TCP/IP port number that the remote Informix Dynamic Server instance uses to communicate.
    <TWS_DB_USER>
    The user name of the database administrator that has access to the HCL Workload Automation schema on the database.
    <TWS_DB_PW>
    The password of the database administrator user. It must comply with the Informix Dynamic Server naming rules.
    <TWS_DB>
    The name of the database. The default value is TWS.
    <TWS_DBSP_NAME>
    The name of the db space used to store scheduling objects and event rules.
    <IS_BKM>
    Specify TRUE if the workstation where you are creating the database is an HCL Workload Automation backup master domain manager. Otherwise, specify FALSE.
    <IS_PARTITIONED>
    Specify TRUE if you use fragmentation on the Informix Dynamic Server database. Otherwise, specify FALSE.
    <TWS_GRANT_USER>
    Always specify TRUE.