You can run the Run Job or Run Project commands on the onpladm utility
on a UNIX computer and create High-Performance Loader (HPL) objects
in a database server that runs on a Windows computer.
To run the Run Job or Run Project commands on UNIX with a database server on Windows:
- Make the UNIX computer
a trusted host on your Windows computer.
- Verify that the UNIX computer
and Windows computers can
connect to each other.
- Install a database server on the Windows computer. Verify that
the database server is running.
- Install a database server on the UNIX computer.
Ensure that the
database servers on the UNIX and Windows computers are the same
version. You do not need to start the database server on the UNIX computer to run the onpladm utility.
- Set the INFORMIXSERVER and INFORMIXSQLHOSTS environment
variables on your UNIX workstation
as follows:
INFORMXSERVER WINservername
INFORMIXSQLHOSTS full.sqlhosts.pathname
- WINservername
- Name of the database server on the Windows computer
- full.sqlhosts.pathname
- Complete path of the sqlhosts file on the UNIX computer (for instance, $INFORMIXDIR/etc/sqlhosts.wn)
Use the -S or -T onpladm utility
option to override the INFORMIXSERVER environment
variable setting.
- 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.
- Use the onpladm utility commands to
create, configure, delete, describe, list, and modify HPL objects
on your Windows database
server. For more information, see The onpladm utility.
- Prepare load and unload jobs with the onpladm utility. For more information, see Create onpladm jobs.
- Type the following line into the .netrc file
in your home directory on a UNIX computer:
machine WIN_machinename login username password user_password
- WIN_machinename
- Name of the Windows computer.
- username
- Your user name.
- user_password
- Your user password.
Your user name and user password must be valid on
the Windows computer.