A database load utility can improve Campaign performance. Follow these steps to configure Campaign to use a database load utility for a DB2® user database on z/OS®.
About this task
This procedure applies specifically to DB2 on z/OS. If you are using DB2 on a different operating system, see Setting up HCL Campaign to use database load utilities.
Procedure
-
Set up the z/OS UNIX™ System Services (USS) pipes on z/OS.
-
Write a stored procedure to invoke the DSNUTILU and a script to invoke the stored
procedure.
-
Go to
Campaign|partitions|partition1|dataSources|<datasourcename>
and set the properties that begin with the word Loader.
Note: LoaderControlFileTemplate and
LoaderControlFileTemplateForAppend are not used for DB2 on z/OS.
-
Go to
Campaign|partitions|partition1|dataSources|<datasourcename>
and set both DB2NotLoggedInitially and
DB2NotLoggedInitiallyUserTables to FALSE.
