Tuning the InfoSphere Information Server engine for large numbers of users or jobs (Windows Server)

For Microsoft Windows Server systems that have large numbers of simultaneously connected users or large numbers of simultaneously running jobs, you can configure the IBM® InfoSphere® Information Server engine to support the number of open files, lock table entries, and locks that are necessary for correct engine operation. To tune the engine, modify settings in the uvconfig file.

Before you begin

  • Back up the uvconfig file. By default, this file is located in the following directory: C:\IBM\InformationServer\Server\DSEngine.
  • Stop all IBM InfoSphere DataStage® jobs and ask all users to log out of InfoSphere DataStage.

About this task

For new installations of IBM InfoSphere Information Server, change the settings described in this task if you are configuring production systems that have 80 or more simultaneously connected users or 50 or more simultaneously running jobs.

For existing installations, change these settings if you encounter resource problems while running InfoSphere DataStage jobs.

Procedure

  1. Perform the following steps to verify that no InfoSphere DataStage jobs or osh.exe processes are running on the server and that no connections are active:
    1. From the Microsoft Windows Task Manager, click the Processes tab, and then click the Image Name column to sort the process list by name.
    2. Verify that the Show processes from all users check box is selected.
    3. In the list of processes, verify that the following processes are not running: uvsh.exe and osh.exe.
      If these processes are not running, there are no InfoSphere DataStage jobs running on the server.
    4. In the list of processes, verify that the following processes are not running: dsapi_server.exe and dsapi_slave.exe.
      If these processes are not running, there are no active InfoSphere DataStage connections.
  2. Stop the InfoSphere Information Server engine.
  3. Use a text editor to edit the uvconfig file. By default, this file is located in the following directory: C:\IBM\InformationServer\Server\DSEngine. Specify the following settings
    MFILES    200
    T30FILES  300
    RLTABSZ   300
    MAXRLOCK  299
  4. Save the uvconfig file. Make sure that you do not save the file with a .txt extension. The uvconfig file cannot have a file extension.
  5. From the Windows command prompt, change to the directory that contains the uvconfig file. For example, change to the following directory:
    C:\IBM\InformationServer\Server\DSEngine
  6. Issue the following command to regenerate the binary uvconfig file:
    bin\uvregen.exe
  7. Restart the InfoSphere Information Server engine.