Home | Previous Page | Next Page   Browsing > Browsing Options >

Viewing the Status of a Load Job or Unload Job

When a load or unload job is complete, onpload writes a record of the load or unload job into a log file. For information on the messages that the log file can contain, see Appendix G. HPL Log-File and Pop-Up Messages.

Viewing the Log File

The default name for a log file is /tmp/jobname.log, where jobname is the name that you chose for the job.

You can specify a different name for the log file in the Load Job window (Figure 109) or Unload Job Window (Figure 104).

To view the log file
  1. Choose Browsers > Logfile from the HPL main window.

    The Browse Logfile window appears, as Figure 122 shows. When the window appears, the Filter text box and the Selection text box show the directory from which ipload was started.

    Figure 122. The Browse Logfile Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  2. In the Filter text box, type the full pathname of the directory that contains the log.

    You can use wildcards to select only certain files from that directory.

  3. Click Filter.

    The Files list box shows a list of the files that match the path that you entered in the Filter text box.

  4. In the Files list box, click the name of the file that you want to examine.

    The full pathname of the selected file appears in the Selection text box.

  5. Click OK.

    A Browse window appears that displays the contents of the selected file.

  6. Review the log using the scroll bar to move through the log.
  7. Click Cancel to return to the HPL main window.

Alternatively, if you know the full pathname of the log file, you can simply type the pathname in the Selection text box and click OK.

Sample Log File

The following example shows a sample log file entry: 

Sat Mar 11 13:52:42 1995

Session ID 1

Unload Database -> stores_demo
Query Name      -> f_manufact
Device Array    -> fmanufact
Query Mapping   -> f_manufact
Query           -> select * from manufact
Convert Reject  -> /work/data/f_manu_unl

Database Unload Completed -- Unloaded 9 Records  Detected 0 Errors

Sat Mar 11 13:52:50 1995

You can review the log file to determine load status and to see where any errors occurred. The log file is a simple ASCII file. You can print it if necessary.

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