Data Movement Utilities Guide and Reference

LOAD QUERY Command

Checks the status of a load operation during processing. A connection to the same database, and a separate CLP session are also required to successfully invoke this command. It can be used either by local or remote users.

Authorization

None

Required Connection

Database

Command Syntax

>>-LOAD QUERY---TABLE--table-name------------------------------->
 
>-----+-------------------------+---+-------------+------------->
      '-TO--local-message-file--'   +-NOSUMMARY---+
                                    '-SUMMARYONLY-'
 
>-----+------------+-------------------------------------------><
      '-SHOWDELTA--'
 

Command Parameters

NOSUMMARY

Specifies that no load summary information (rows read, rows skipped, rows loaded, rows rejected, rows deleted, rows committed, and number of warnings) is to be reported.

SHOWDELTA

Specifies that only new information (pertaining to load events that have occurred since the last invocation of the LOAD QUERY command) is to be reported.

SUMMARYONLY

Specifies that only load summary information is to be reported.

TABLE table-name

Specifies the name of the table into which data is currently being loaded. If an unqualified table name is specified, the table will be qualified with the CURRENT SCHEMA.

TO local-message-file

Specifies the destination for warning and error messages that occur during the load operation. This file cannot be the message-file specified for the LOAD command. If the file already exists, all messages that the load utility has generated are appended to it.

Examples

A user loading a large amount of data into the STAFF table wants to check the status of the load operation. The user can specify:

   db2 connect to <database>
   db2 load query table staff to /u/mydir/staff.tempmsg

The output file /u/mydir/staff.tempmsg might look like the following:

SQL3500W The utility is beginning the "LOAD" phase at time
"02-13-1997 19:40:29.645353".
 
SQL3519W  Begin Load Consistency Point. Input record count = "0".
 
SQL3520W  Load Consistency Point was successful.
 
SQL3109N The utility is beginning to load data from file
"/u/mydir/data/staffbig.ixf".
 
SQL3150N The H record in the PC/IXF file has product "DB2 01.00",
date "19970111", and time "194554".
 
SQL3153N The T record in the PC/IXF file has name
"data/staffbig.ixf", qualifier " ", and source " ".
 
SQL3519W  Begin Load Consistency Point. Input record count =
"111152".
 
SQL3520W  Load Consistency Point was successful.
 
SQL3519W  Begin Load Consistency Point. Input record count =
"222304".
 
SQL3520W  Load Consistency Point was successful.

See Also

LOAD Command.