Dataloader/MP Reference Manual

Running DataLoader/MP
DataLoader/MP Reference Manual—424148-003
3-11
Default Exit Examples
Even if you have a very large amount of data, DataLoader/MP can help you. Suppose
you have so much data that there is too much to sort, even if you just sort the keys.
You can use the % modifier to randomly sample the data. One option is to randomly
sample from the beginning of the data by using the parameters in this command:
1>DATALOAD -I=infile(1%, MAX=100000) -P=10
Random sampling selects 1% of the records and stops when 100,000 records have
been selected. DataLoader/MP can easily sort the key values for this many records.
If you know that the key values are uniformly distributed throughout the file, this is a
good solution. DataLoader/MP will look at less data, but the partition boundaries it
gives you will be very accurate.
However, if the key values are not uniformly distributed over the entire file, or if you do
not know how the key values are distributed, the boundary values that DataLoader/MP
produces in this situation will not be accurate. We will get more accurate values if we
lower the sampling percentage to 0.1% so that DataLoader/MP will be forced to
sample the whole file. Then get the boundaries for the sample with this command:
1>DATALOAD -I=infile(0.1%) -P=10
DataLoader/MP uses FastSort, so you can use the =_SORT_DEFAULTS
DEFINE before running DataLoader/MP to specify sorting parameters.
Default Exit Examples
The default DataLoader/MP user exits perform neutral actions when called. The
following syntax examples show how to run DataLoader/MP with its default exits.
Command Result
>DATALOAD -q
Directs DataLoader/MP to not write
informational messages to the home
terminal
>DATALOAD -e=ERROR
Directs DataLoader/MP to write error
messages to a file named ERROR
>DATALOAD -E=ERROR
Directs DataLoader/MP to write error
messages to a file named ERROR.
Parameters are not case sensitive.
>DATALOAD -e = error
Produces a syntax error because there
are blanks embedded in the -e
parameter
>DATALOAD -e=error -t=100
Directs DataLoader/MP to write error
messages to a file named error and sets
the number of records per TMF
transaction to 100