Dataloader/MP Reference Manual

Running DataLoader/MP
DataLoader/MP Reference Manual—424148-003
3-8
Syntax of DataLoader/MP
Use this parameter to reduce the number of messages on the home terminal when
running many DataLoader/MP processes simultaneously.
When an error occurs, sometimes an earlier informational message can be helpful
in understanding the error. If you use -Q, it is generally a good idea to specify an
OUT file to capture all messages. If you cannot diagnose a problem by using the
error message, you did not capture the OUT file, and you used the -Q option, you
can obtain more information by rerunning the job without -Q.
-S=num-recs [<CSV[=out-file]>]
specifies that DataLoader/MP is to print periodic status messages.
num-recs
is the number of input records that will be processed between status
messages.
<CSV[=out-file]>
if specified, causes messages to appear in a comma-separated values (CSV)
format suitable for loading into a spreadsheet for analysis or graphical display.
If =out-file is specified, the CSV status information is written to this file, and
status in text format goes to the terminal. If =out-file is omitted, the status
information sent to the terminal appears in CSV format.
Whether or not you specify -S, if you open a DataLoader/MP process with the
#CMD.STAT qualifier, it will print the current statistics.
-T=num-recs [ <RESTARTFILE=restart-file [<{KEEP | PURGE}>]>]
specifies that DataLoader/MP is to bracket records within HP NonStop Transaction
Management Facility (TFM) transactions. If a DataLoader/MP process fails within a
transaction, TMF backs out any changes associated with records in the currently
active transaction and returns the database to the state it was in after processing
the last record in the last committed transaction. After resolving the problem that
caused the failure, you can restart the operation at that point. Information to
facilitate such a restart is put into restart-file.
num
is the number of input records per TMF transaction. If num is large, the
resources consumed by database changes associated with the records in the
transaction might hit a TMF limit, and the transaction could be aborted by TMF.
If num is very small, the TMF and DataLoader/MP costs per transaction are
excessive. Some experimentation is usually necessary to determine an
appropriate value for num.
restart-file
is the name of the restart file. DataLoader/MP generates a restart file with the
name specified if the file does not already exist. This file is an audited relative