Data Warehouse Center Application Integration Guide

Appendix C. Writing your own program to use with the Data Warehouse Center

You can write Data Warehouse Center programs in any language that supports one of the following program types: executable, batch program, or dynamic link library.

If the program has a program type of executable, command file, or dynamic link library, it must reside on the agent site. The Data Warehouse Center agent starts the program at the scheduled time. On Windows NT and Windows 2000, the agent runs as a system process by default. The program cannot access resources or programs that require a user ID. Also, any environment variables that the program needs to access must be system variables.

To change the Data Warehouse Center server, logger, and agent daemon processes to run as user processes:

  1. Double-click the Services icon in the Control Panel folder.
  2. Stop the Agent service.
  3. Select the Agent service and click Startup.
  4. Click This Account.
  5. Click the push button after the This Account field to select a user ID.

    The user ID must have administrator authority in Windows NT or Windows 2000 and authorization to any required network drive.

  6. Type the password for the user ID twice.
  7. Click OK.
  8. Restart the workstation.

If you write programs that use Object REXX, complete the following procedure to enable these programs to run on Windows NT or Windows 2000:

  1. Define the Data Warehouse Center agent or server service as a system process that can interact with the Windows NT or Windows 2000 desktop:
    1. Select the agent or server service from the Service list.
    2. Click Startup.
    3. Click System Account.
    4. Select the Allow Service to Interact with Desktop check box.
  2. Initialize the Object REXX environment before the agent or server starts the program. You can initialize the environment by running any Object REXX program from the command line.
  3. If your Object REXX program issues a DB2 CONNECT statement, verify that the statement includes the user ID and password, as in the following example: 
    DB2 CONNECT TO testdb USER vwadmin USING vwpass

[ Top of Page | Previous Page | Next Page ]