Running onpladm on UNIX™ with the database server running on Windows™
You can run the Run Job or Run Project commands on the onpladm utility on a UNIX™ computer and create objects in a database server that runs on a Windows™ computer.
About this task
To run the Run Job or Run Project commands on UNIX™ with a database server on Windows™:
Procedure
- 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.