Database configuration - configureDB script
This script creates and populates the HCL Workload Automation database
This script is typically used by the database administrator for creating and populating the HCL Workload Automation database. For a typical scenario, see Creating and populating the database.
This section lists and describes the parameters that you can use to create and populate the HCL Workload Automation database.When running the command, you can type parameters and values from a properties file, type them in the command line, or use a combination of both properties file and command line. If a parameter is specified both in the properties file and in the command line, the command line value is used.
- On Windows operating systems
- TWA_home\logs
- On UNIX operating systems
- TWA_DATA_DIR/installation/logs
- On z/OS operating system
- TWA_DATA_DIR/installation/logs
Syntax for Windows operating systems
- Show command usage
-
configureDb -? | --usage | --help
- Retrieve the command parameters and values from a file
-
configureDb --propfile | -f [property_file]
- General information
-
[--lang lang_id] [--work_dir working_directory] [--wlpdir wlp_directory] [--componenttype MDM | DDM] [--dbadminuser db_admin_user] --dbadminuserpw db_admin_password [--rdbmstype|-r DB2 | DB2Z | ORACLE | MSSQL | DERBY]
The following configuration information for the data source is ignored if --rdbmstype is set to DERBY:
[--dbname db_name] [--dbuser db_user] [--dbport db_port] --dbhostname db_hostname [--dbdriverpath db_driver_path] --auth_type aythentication_type ] [--iwstsname table_space_name] [--iwstspath table_space_path] [--iwslogtsname log_table_space] [--iwslogtspath log_path_table_space] [--iwsplantsname plan_table_space] [--iwsplantspath plan_path_table_space] [--execsql execute_sql]
- Configuration options when --dbsslconnection=true or customized certificates are used for SSL connections
-
--sslkeysfolder keystore_truststore_folder --sslpassword ssl_password
- Oracle-only configuration options
-
--dbpassword db_password [--usePartitioning true | false ] [--Usage_TsTempName IWS_temp_path] [--skipdbcheck true | false]
- DB2 for z/OS-only configuration options
-
[--zlocationname zOS_location_containing_db] [--zbufferpoolname buffer_pool_in_zOS_location]
Syntax for UNIX operating systems
- Show command usage
-
configureDb -? | --usage | --help
- Retrieve the command parameters and values from a file
-
configureDb --propfile | -f [property_file]
- General information
-
configureDb [--lang lang_id] [--work_dir working_directory] [--wlpdir wlp_directory] [--componenttype MDM | DDM] [--dbadminuser db_admin_user] --dbadminuserpw db_admin_password [--rdbmstype|-r DB2 | DB2Z | ORACLE | MSSQL | IDS | ONEDB | DERBY]
The following configuration information for the data source is ignored if --rdbmstype is set to DERBY:
[--dbname db_name] [--dbuser db_user] [--dbport db_port] --dbhostname db_hostname [--dbdriverpath db_driver_path] [--dbserver db_server_name [--iwstsname table_space_name] [--iwstspath table_space_path] [--iwslogtsname log_table_space] [--iwslogtspath log_path_table_space] [--iwsplantsname plan_table_space] [--iwsplantspath plan_path_table_space] [--execsql execute_sql ]
- Oracle-only configuration options
-
--dbpassword db_password [--usePartitioning true | false ] [--Usage_TsTempName IWS_temp_path] [--skipdbcheck true | false]
- Informix-only configuration options
-
[--iwssbspace blob_clob_table_space]
- Configuration options when --dbsslconnection=true or customized certificates are used for SSL connections
-
--sslkeysfolder keystore_truststore_folder --sslpassword ssl_password
- DB2 for z/OS-only configuration options
-
[--zlocationname zOS_location_containing_db] [--zbufferpoolname buffer_pool_in_zOS_location]
Syntax for z/OS operating system
- Show command usage
-
configureDb -? | --usage | --help
- Retrieve the command parameters and values from a file
-
configureDb --propfile | -f [properties_file]
- General information
-
configureDb [--lang lang_id] [--work_dir working_directory] [--wlpdir wlp_directory] [--dbadminuser db_admin_user] --dbadminuserpw db_admin_password [--rdbmstype|-r DB2Z | DERBY]
The following configuration information for the data source is ignored if --rdbmstype is set to DERBY:
[--dbname db_name] [--dbuser db_user] [--dbport db_port] --dbhostname db_hostname [--dbdriverpath db_driver_path] [--iwstsname table_space_name] [--iwstspath table_space_path] [--iwslogtsname log_table_space] [--iwslogtspath log_path_table_space] [--iwsplantsname plan_table_space] [--iwsplantspath plan_path_table_space] [--execsql execute_sql ]
- DB2 for z/OS-only configuration options
-
[--zlocationname zOS_location_containing_db] [--zbufferpoolname buffer_pool_in_zOS_location]
Database configuration parameters
- -? | --usage | --help
- Displays the command usage and exits.
- --propfile|-f [properties_file]
- Optionally specify a properties file containing custom values for
configureDb
parameters. The default file for the server components is image_location/TWS/interp_name/configureDbdatabase_vendor.properties, while the default file for the Dynamic Workload Console is image_location/configureDbdatabase_vendor.properties. Specifying a properties file is suggested if you have a high number of parameters which require custom values. You can also reuse the file with minimal modification for several installations. If you create a custom properties file, specify its name and path with the -f parameter. - --lang lang_id
- The language in which the messages returned by the command are displayed. If not specified, the
system LANG is used. If the related catalog is missing, the default C
language catalog is used. If neither --lang nor LANG are used, the
default codepage is set to SBCS. For a list of valid values for these
variables, see the following table:
Table 1. Valid values for -lang and LANG parameter Language Value Brazilian Portuguese pt_BR Chinese (traditional and simplified) zh_CN, zh_TW English en French fr German de Italian it Japanese ja Korean ko Russian ru Spanish es Note: This is the language in which the installation log is recorded and not the language of the installed component instance. The command installs all languages as default. - --work_dir
- The working directory where you extract the installation image. It also contains the output produced by the command, such as the SQL statements if you set the execsql parameter to false. The default value is /tmp on UNIX operating systems and C:\tmp on Windows operating systems.
- [--wlpdir wlp_directory]
- The path to WebSphere Application Server Liberty Base installation directory. WebSphere Application Server Liberty Base is used to decrypt the passwords you provide in encrypted form. This parameter is required only if you encrypt your passwords with the {xor} or {aes} encoding.
- --componenttype
- The HCL Workload Automation component for
which the database is installed. This parameter is optional and applies only to server
components. If you are installing the Dynamic Workload Console, the script detects this
automatically and proceeds accordingly. The default value is calculated at run time.
Supported values are.
- MDM
- master domain manager
- DDM
- dynamic domain manager
- --dbadminuser db_admin_user
- The database administrator user who creates the HCL Workload Automation or Dynamic Workload Console schema objects on the
database server. This parameter is optional. Depending on the database vendor, the default
values are as follows:
- db2admin
- when --rdbmstype is set to DB2
- sysadm
- when --rdbmstype is set to DB2Z
- system
- when --rdbmstype is set to ORACLE
- sa
- when --rdbmstype is set to MSSQL
- informix
- when --rdbmstype is set to IDS or ONEDB
- --dbadminuserpw db_admin_password
- The password for the DB administrator user who creates the HCL Workload Automation schema objects on the database server. This parameter is required. You can optionally encrypt the password. For more information, see Encrypting passwords (optional).
- --rdbmstype|-r rdbms_type
- The database type. This parameter is optional. Supported databases are:
- DB2. This is the default value for the server components.
- DB2Z.
- Oracle.
- IDS This value is supported only on UNIX operating systems. and applies to Informix.
- ONEDB This value is supported only on UNIX operating systems.
- MSSQL. Applies to MSSQL and Azure SQL.
- DERBY. Applies only to the Dynamic Workload Console; it is the default value.
- --dbname db_name
- The name of the HCL Workload Automation or
Dynamic Workload Console database. This
parameter is optional. Depending on the component that you are installing and the database
vendor, the default values are as follows:
- When installing the server components
-
- TWS
- when --rdbmstype is set to DB2
- orcl
- when --rdbmstype is set to ORACLE
- TWS
- when --rdbmstype is set to MSSQL
- TWS
- when --rdbmstype is set to IDS or ONEDB
- When installing the Dynamic Workload Console
- If you are using a Derby database, this parameter is not required. If you are using a
different database, the following defaults apply:
- TDWC
- when --rdbmstype is set to DB2
- TDWC
- when --rdbmstype is set to DB2Z
- orcl
- when --rdbmstype is set to ORACLE
- TDWC
- when --rdbmstype is set to MSSQL
- TDWC
- when --rdbmstype is set to IDS or ONEDB
- --dbuser db_user
- The database user that has been granted access to the HCL Workload Automation or Dynamic Workload Console tables on the database
server. This parameter is optional. Depending on the component that you are installing and
the database vendor, the default values are as follows:
- When installing the server components
-
- db2tws
- when --rdbmstype is set to DB2
- twsora
- when --rdbmstype is set to ORACLE
- sa
- when --rdbmstype is set to MSSQL
- idstws
- when --rdbmstype is set to IDS or ONEDB
- When installing the Dynamic Workload Console
-
- db2dwc
- when --rdbmstype is set to DB2
- root
- when --rdbmstype is set to DB2Z
- twsora
- when --rdbmstype is set to ORACLE
- sa
- when --rdbmstype is set to MSSQL
- idsdwc
- when --rdbmstype is set to IDS or ONEDB
- --dbport db_port
- The port of the database server. This parameter is optional. Depending on the database vendor,
the default values are as follows:
- 50000
- when --rdbmstype is set to DB2
- 446
- when --rdbmstype is set to DB2Z
- 1521
- when --rdbmstype is set to ORACLE
- 1433
- when --rdbmstype is set to MSSQL
- 16175
- when --rdbmstype is set to IDS or ONEDB
- --dbhostname db_hostname
- The host name or IP address of database server. This parameter is required.
- --dbdriverpath db_driver_path
- The path where the database drivers are stored. This parameter is optional. By default, the configuration script references the JDBC drivers supplied with the product images. If your database server is not compatible with the supplied drivers, then contact your database administrator for the correct version to use with your database server and specify the driver path using this parameter. Ensure you provide the same path in the configureDb, serverinst, and dwcinst commands. For more information, see What if my database server does not support the drivers supplied with the product images?.
- --dbserver
- Specifies the name of the Informix or OneDB database server. This parameter is required only if --rdbmstype is set to IDS or ONEDB and is supported only on UNIX operating systems.
- --iwstsname|-tn table_space_name
- The name of the tablespace for HCL Workload Automation data. This parameter is
optional for all databases with the exception of the Oracle database. The
default value for all databases other than Oracle is:
- For all operating systems, except z/OS
- TWS_DATA
- For z/OS operating system
- TWSDATA
- --iwstspath|-tp table_space
- The path of the tablespace for HCL Workload Automation data. This parameter is
optional. The default value for all databases other than Oracle is:
- For all operating systems, except z/OS
- TWS_DATA
- For z/OS operating system
- TWSDATA
c:/<my_path>/TWS_DATA
. - --iwslogtsname|-ln log_table_space
- The name of the tablespace for HCL Workload Automation log. This parameter is optional for all databases with the exception of the Oracle database. The default value for all databases other than Oracle is TWS_LOG. This parameter applies only to the server components.
- --iwslogtspath|-lp log_path_table_space
- The path of the tablespace for HCL Workload Automation log. This parameter is
optional. The default value for all databases other than Oracle is TWS_LOG. This
parameter applies only to the server components. Only on Windows systems
hosting an MSSQL database, ensure the folder for the tablespace is already existing before
running the configureDb command and specify the path using this parameter.
Specify the path using forward slashes (/), for example:
c:/<my_path>/TWS_LOG
. - --iwsplantsname|-pn plan_table_space
- The name of the tablespace for HCL Workload Automation plan. This parameter is optional for all databases with the exception of the Oracle database. The default value for all databases other than Oracle is TWS_PLAN. This parameter applies only to the server components.
- --iwsplantspath|-pp plan_path_table_space
- The path of the tablespace for HCL Workload Automation plan. This parameter is
optional. The default value for all databases other than Oracle is TWS_PLAN. This
parameter applies only to the server components.
Only on Windows systems hosting an MSSQL database, ensure that the folder for the tablespace is already existing before running the configureDb command and specify the path using this parameter. Specify the path using forward slashes (/), for example:
c:/<my_path>/TWS_PLAN
. - --execsql|-es execute_sql
- Set to true to generate and run the SQL file, set to false to generate the SQL statement without running it. The resulting files are stored in the path defined in the --work_dir parameter. This option is useful if you wan to review the file before running it. This parameter is optional. The default value is true.
- --auth_type
- This parameter applies only to Windows operating systems. Specify the
authentication type. Supported values are as follows:
- SQLSERVER
- Enables MSSQL authentication type. Only the user specified with the --dbadminuser parameter has the grants to administer the HCL Workload Automation or Dynamic Workload Console database.
- WINDOWS
- Enables Windows authentication type. The Windows user you used to log on to the workstation is assigned the grants to administer the HCL Workload Automation or Dynamic Workload Console database.
Oracle-only configuration syntax
- --dbpassword db_password
- The password for the user that has been granted access to the HCL Workload Automation or Dynamic Workload Console tables on the database server. This parameter is required only if you are using an Oracle database. You can optionally encrypt the password. For more information, see Encrypting passwords (optional).
- --usePartitioning
- Only applies when installing the master domain manager. Set to true if you want to use the Oracle partitioning feature, otherwise set it to false. This parameter is optional. The default value is true.
- --Usage_TsTempName IWS_temp_path
- Only applies when installing the master domain manager. The path of the tablespace for HCL Workload Automation temporary directory. This parameter is optional. The default value is TEMP.
- --skipdbcheck
- This parameter specifies whether the check on the existence of the Workload Automation schema
for the Oracle user is performed or not. By default, the parameter is set to false and a
check is performed on the Oracle user. If the user does not exist, the script then proceeds to
create the user and the Workload Automation schema.
If you have already created your Oracle user, set this parameter to true. As a result, the check is skipped and the schema creation is performed also if the Oracle user is already existing.
This parameter is optional.
Informix-only configuration syntax
- --iwssbspace blob_clob_table_space
-
The name of the table space for blob and clob data. The default value is twssbspace.
DB2-only configuration syntax
- --sslkeysfolder
- The name and path of the folder containing certificates
in .pem format. The installation program
automatically processes the keystore and truststore files using the
password you specify with the --sslpassword
parameter. The folder must contain the following files:
-
- ca.crt
- The Certificate Authority (CA) public certificate.
-
- tls.key
- The private key for the instance to be installed.
-
- tls.crt
- The public part of the previous key.
You can optionally create a subfolder to contain one or more *.crt files to be added to the server truststore as trusted CA. This can be used for example to add to the list of trusted CAs the certificate of the LDAP server or DB2 server. Additionally, you can store here any intermediate CA certificate to be added to the truststore. The subfolder must be named additionalCAs.
This parameter is required if you set the --dbsslconnection parameter to true. -
- --sslpassword
- The password for the custom certificates and the path to the folder containing certificates in .pem format with the sslkeysfolder parameter. You can optionally encrypt the password using the secure script. For more information, see Optional password encryption - secure script.
- --zlocationname zos_location_containing_db
- The name of an already existing location in the z/OS environment that will contain the new database. The default value is LOC1.
- --zbufferpoolname buffer_pool_in zos_location
- The name of an already existing buffer pool created in
the location specified by
-zlocationname
. The default value is BP32K.
Comments
- --rdbmstype
- --dbhostname
- --dbport
- --dbname
- --dbuser