Preparing jobs with the ipload utility on Windows computers

You cannot prepare load and unload jobs for the 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.

About this task

To use the ipload utility on UNIX to prepare jobs for a database server on Windows:

Procedure

  1. Make the UNIX computer a trusted host on your Windows computer.
  2. Ensure 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 HCL 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 path name 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 by using ipload, you can also run the jobs by using the onpload command on your Windows computer.