Home | Previous Page | Next Page   Appendix I. Running Load and Unload Jobs on a Windows Computer >

Preparing Jobs for Windows with the ipload Utility

You cannot prepare load and unload jobs for the High-Performance Loader (HPL) on Windows computers. However, you can use the ipload utility on UNIX to prepare the load and unload jobs and then use the onpload command on Windows to run those jobs.

To use the ipload utility on UNIX to prepare jobs for a database server on Windows
  1. Make the UNIX computer a trusted host on your Windows computer.
  2. Make sure that the UNIX computer can connect to the Windows computer.
  3. Install a database server on Windows and make sure that it is running.
  4. Install a database server on UNIX. You need not start the database server to run the ipload utility.
  5. Make sure that the database server installed on UNIX is the same version as the Informix database server on Windows.
  6. If the database server on UNIX is running, do not modify the environment variables. If the database server on UNIX is not running, set the environment variables (from your UNIX workstation), as the following example shows:
    INFORMIXSERVER WINservername
    INFORMIXSQLHOSTS full.sqlhosts.pathname
    WINservername
    The name of the database server on Windows
    full.sqlhosts.pathname
    The full pathname of the sqlhosts file on your UNIX workstation (for example, $INFORMIXDIR/etc/sqlhosts.wn)
  7. Add the following line to the $INFORMIXSQLHOSTS file on the UNIX workstation:
    WINservername ontlitcp WINname servicename
    WINservername
    Name of the database server on the Windows computer
    WINname
    Name of the Windows computer
    servicename
    Service that the Windows database server uses
  8. On UNIX, run ipload as the DBA or as user informix.

    If the database server on UNIX is not running (and you set the environment variables correctly), ipload immediately connects to the Windows database server. If the database server on UNIX is running, ipload initially connects to that database server. To connect to the database server on Windows, choose Configure Server.

    The Connect Server dialog shows two columns: Onpload Server and Target Server. Select the database server on Windows in both columns and click OK. The ipload utility connects to the database server on Windows.

  9. Create, edit, view, and run HPL jobs on the database server on Windows. After you prepare the load and unload jobs using ipload, you can also run the jobs using the onpload command on your Windows computer.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]