Command Reference

LOAD QUERY

Checks the status of LOAD during processing.

Authorization

None

Required Connection

Database

Command Syntax

>>-LOAD QUERY--remote-file---+-------------------------+------->< +-TO--local-message-file--+

Command Parameters

remote-file: Specifies the base name that was used when creating temporary files during a load.
TO local-message-file: Specifies the destination for warning and error messages that occur during the load. This file cannot be the message-file specified for LOAD. If the file already exists, all messages that the load utility has generated are appended to it.

Example

A user loading a large amount of data into the STAFF table wants to check the status of the load. Assuming that the LOAD parameter remote-file was set as:

   remote file /u/remotedir/rmsg/staff

the following commands are issued:

   db2 connect to <database>
   db2 load query /u/remotedir/rmsg/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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]