Using database load utilities with DB2 on z/OS
A database load utility can improve Unica 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
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.