HCL Workload Automation, Version 9.4

Generating the SQL files for DB2

Steps that need to be taken to generate the SQL files for DB2.

To generate the SQL files, you use the customizeSQL script which is located:
On Windows operating systems:
<images_dir>\dbtools\customizeSQL.bat
On UNIX and Linux operating systems:
<images_dir>/dbtools/customizeSQL.sh
Where <images_dir> is the directory where you stored the product images. If you want to use the eImage, download the one containing the master domain manager.
To show command usage, run: 
customizeSQL -usage
The script has the following syntax:
On Windows operating systems:
customizeSQL.bat -propertyFile <property_file>
On UNIX and Linux operating systems:
customizeSQL.sh -propertyFile <property_file>
Where <property_file> is the absolute path of the directory where the property file is located.
On Windows operating systems:
If you store the properties file in the C:\Temp\ directory, run:
customizeSQL.bat
-propertyFile "C:\Temp\customizeDb2Sql.properties"
On UNIX and Linux operating systems:
If you store the properties file in the /tmp/ directory, run:
customizeSQL.sh 
-propertyFile /tmp/customizeDB2SQL.properties
Note: The SQL files are created in the directory that 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 DB2.