Data Warehouse Center Application Integration Guide

VWPEXUNX

The VWPEXUNX program remotely issues a command or runs a program. VWPEXUNX runs on Windows NT, Windows 2000, and UNIX.

If you are running the VWPEXUNX program on Windows NT or Windows 2000, the REXECD program must also be running on the workstation.

Parameters

Table 121 shows the parameter list for the VWPEXUNX program. The list includes the predefined token for a parameter if one exists.

Table 121. Parameters for VWPEXUNX

Order	Description
1	The remote host name.
2	The remote user ID.
3	The remote program to execute.
4	The remote error file.
5	The remote warning file. If there is no warning file, specify - (the not-applicable symbol).
6	The remote log (summary) file. If there is no log file, specify - (the not-applicable symbol).
7	The remote operating system type. Specify either UNIX, WINNT, or WIN2000.
8	The password type. Specify either PasswordNotRequired, EnterPassword, or GetPassword.
9	The password value if the password type is EnterPassword. - (not-applicable symbol) if the password type is PasswordNot Required. The password program if password type is GetPassword. The password program must reside on the agent site that is selected for the step. The program must write a file that contains the password to use in the first line of the file. It must return 0 if it runs correctly.
10	The password program parameters if the password type is GetPassword

The following example shows how to start the VWPEXUNX program from a command prompt. The command must be typed all on one line. The line break shown in this example is not significant.

vwpexunx tomari labriejj db2cmd \usr\labriejj\db2cmd.err - - 
	UNIX EnterPassword mypass 

tomari

The name of the remote host

labriejj

The user ID used to access the remote host

db2cmd

The remote program to run

\usr\labriejj\db2cmd.err

The path and name of the remote error file

-

No remote warning file exists

-

No remote log (summary) file exists

UNIX

The remote operating system

EnterPassword

The password type

mypass

The password

Return codes

The VWPEXUNX program uses the remote error file to determine the success or failure of the remote command or program:

• If the error file is empty or nonexistent, the VWPEXUNX program returns an error code that indicates success.
• If the error file is not empty, the VWPEXUNX program:
  • Saves the contents of the error file in a temporary file.
  • Returns an error code that indicates failure.

The VWPEXUNX program does not check the contents of the remote error file.

Table 122 lists the return codes for the VWPEXUNX program.

Table 122. Return codes for the VWPEXUNX program

Return code	Description
0	The program ran successfully.
4	The program ran with a warning. The program could not erase the password file after the password program ran.
8	Parameter error. Too few or too many parameters were supplied to the program, or an invalid value was supplied for a parameter.
16	Internal error. The program detected an internal error, such as the inability to open, create, or write to a temporary file.
48	Environment variable error. The VWS_LOGGING environment variable was not set.
52	Get password program error. The program detected a password program error, such as a missing program, an invalid name, or the wrong number of parameters
56	Remote execution error. The program detected a remote execution error, such as the following errors: An incorrect user ID or password was supplied. A remote file was not found. A remote host is not responding. The supplied user ID is not authorized to create or read the remote file.

Log files

The VWPEXUNX program writes a trace file to the directory that the VWS_LOGGING environment variable specifies.