Dataloader/MP Reference Manual

DataLoader/MP Examples
DataLoader/MP Reference Manual—424148-003
6-11
Multiple Source Parallel Maintenance
The following commands and their descriptions describe one way to accomplish the
scenario in Figure 6-4.
The following commands execute the initial DataLoader/MP processes and run an
unmodified version of DataLoader/MP that uses the default user exits.
1>DATALOAD /NOWAIT, NAME $dbl0/ -E=err0a -I=infile1 -O=$RECEIVE
& -S=100000
2>DATALOAD /NOWAIT, NAME $dblm/ -E=err0b -I=infile2 -O=$RECEIVE
& -S=100000
The preceding commands use these parameters:
•
-E directs the process to write any execution time errors to the appropriate error
file.
•
-I directs the process to read its input from the appropriate input file.
•
-O indicates the process should write the output (blocks of the unmodified input
records) to $RECEIVE. The DataLoader/MP process puts them in a buffer pool
and waits for a read from another process.
•
-S asks for a status display every 100,000 records
Command lines 3 through 6 start the downstream DataLoader/MP processes, which
are customized versions with user exits CONVERTIT (to do the conversion), INSERTIT
(to attempt to insert the converted record), and UPDATEIT (to attempt to update the
row corresponding to the converted record). Each of these command lines give the
downstream DataLoader/MP processes their own file (err1, err2, ...) in which to record
execution time errors through the -E parameter.
They use the following parameters:
•
-I directs each DataLoader/MP process to get its input from the initial
DataLoader/MP process, $dbl0.
•
-X directs them to call a series of user exits indicated by the string “CIU”:
°
“C” directs the process to call the user exit CONVERTIT.
°
“I” directs the process to call the user exit INSERTIT, which attempts to insert
the converted record into the database. If the insertion is successful, the
processing for that record is complete, and the process reads the next record.
°
If the insert is unsuccessful, “U” indicates that the next user exit, UPDATEIT,
should be called to update the corresponding row in the database. If the
update is successful, processing for that record is complete, and the process
reads the next record. If the update is not successful, a message is sent to the
Note. PRI and CPU parameters are omitted from the example. The initial DataLoader/MP
processes should run at high priority, and the downstream DataLoader/MP processes should
be distributed across processors.