Dataloader/MP Reference Manual

Table Of Contents
DataLoader/MP Examples
DataLoader/MP Reference Manual424148-003
6-10
Multiple Source Parallel Maintenance
PARTONLY; EXIT
...
11>SQLCI /NOWAIT/ LOAD $dbln,=partn, RECIN 215, BLOCKIN 31820,
PARTONLY; EXIT
Multiple Source Parallel Maintenance
This highly parallel load scenario with write operations uses only two simple exits: one
to build the key from a raw record (the BUILDKEY exit in the initial DataLoader/MP
process) and one to convert a raw record to a suitable format (the CONVERT exit in
downstream DataLoader/MP processes).
Figure 6-4 shows multiple input streams. Assume that you are inserting or updating the
database as appropriate.
Note that Figure 6-4 is exactly like Figure 6-2 except that there is more than one input
stream, and you must have one initial DataLoader/MP process for each stream. You
could use DataLoader/MPs statistics report to adjust the number of downstream
DataLoader/MP processes and modify the input stream to start them.
Figure 6-4. Multiple Source Parallel Maintenance
VDT013
Data
Source
1
Data
Source
M
Part1
Part2
Part3
PartN
$dbl0 - initial
DataLoader/MP
1
$dblm - Initial
DataLoader/MP
N
DBL1
DataLoader/MP
N
DBL1
DataLoader/MP
1
DBL1
DataLoader/MP
N
DBL1
DataLoader/MP
1