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.