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:
- Make the UNIX computer
a trusted host on your Windows computer.
- Ensure that the UNIX computer
can connect to the Windows computer.
- Install a database server on Windows and make sure that it is running.
- Install a database server on UNIX. You need not start the database server to run the ipload utility.
- Make sure that the database server installed on UNIX is the same version as the HCL Informix® database
server on Windows.
- 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)
- 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.
- 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.
- 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.