DataLoader/MX Reference Manual (G06.24+)

DataLoader/MX Examples
DataLoader/MX Reference Manual—525872-002
6-11
Multiple Source Parallel Maintenance
•
-S directs the DataLoader/MX process to generate a status message every
100,000 records.
The file kr is a text file containing:
"" $dbl1
"D" $dbl2
"G" $dbl3
...
"Y" $dbln
Because the DataLoader/MX process is instructed to interpret this output file as a
keyrange file, the output records are not written to kr itself. Instead, the contents of kr,
together with the key of each record, are used to determine where the records are
written. Records with keys greater than or equal to "" (NULL) but less than "D" are
written to $dbl1. Records with keys greater than or equal to "D" but less than "G" are
written to $dbl2, and so on.
Command lines 3 through 6 start the downstream DataLoader/MX processes, which
are customized versions with these user exits:
•
CONVERTIT (to do the conversion)
•
INSERTIT (to attempt to insert the converted record)
•
UPDATEIT (to attempt to update the row corresponding to the converted record)
Each of these command lines gives the downstream DataLoader/MX processes their
own file (err1, err2, ...) in which to record execution-time errors through the -E
parameter.
3$ run -name=/G/dbl1 dbl1 -E=err1 \
"-I=\$RECEIVE(recform=fb<recsize=200>)" -X=ciu &
4$ run -name=/G/dbl2 dbl1 -E=err2 \
"-I=\$RECEIVE(recform=fb<recsize=200>)" -X=ciu &
5$ run -name=/G/dbl3 dbl1 -E=err3 \
"-I=\$RECEIVE(recform=fb<recsize=200>)" -X=ciu &
...
6$ run -name=/G/dbln dbl1 -E=errn \
"-I=\$RECEIVE(recform=fb<recsize=200>)" -X=ciu &
The preceding commands use these parameters:
•
-I directs each DataLoader/MX process to get its input from its $RECEIVE,
unblocking to 200-byte records. You did not specify a block size, so the
DataLoader/MX process blocks as many records as fit into a 32,000-byte
message.
•
-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.