Running a Data Warehouse Center component trace

Run a Data Warehouse Center trace at the direction of IBM Service to produce a record of a program execution. You can run an ODBC trace, a trace on the Data Warehouse Center control database, and traces on the Data Warehouse Center server, agent, and logger components.

When you run a trace, the Data Warehouse Center writes information to text files. Data Warehouse Center programs that are called from steps will also write any trace information to this directory. These files are located in the directory specified by the VWS_LOGGING environment variable.

The default value of VWS_LOGGING is:

Windows NT and OS/2

x:\sqllib\logging

UNIX

/var/IWH

AS/400

/QIBM/UserData/IWH

 The Data Warehouse Center writes these files:

AGNTnnnn.LOG

Contains trace information. Where nnnn is the process ID of the agent, which can be 4 or 5 characters depending on the operating system.

AGNTnnnn.SET

Contains environment settings for the agent. Where nnnn is the process ID of the agent, which can be 4 or 5 characters depending on the operating system.

IWH2LOG.LOG

Contains the results of the trace for the logger component.

IWH2SERV.LOG

Contains the results of the trace for the Data Warehouse Center server.

IWH2DDD.LOG

Contains the results of the trace for the warehouse control database.

../byb.gif Authorities and privileges

To run a Data Warehouse Center component trace:

  1. Open the Data Warehouse Center Properties notebook.

  2. Specify the trace level for the warehouse control database, ODBC, server, agent, or logger as directed by IBM Software Support.

  3. Click OK.

  4. Restart the services that you are requested to restart.

  5. Perform the failing operation.

  6. Repeat steps 1 through 4 to set the trace level back to 0.

Related information

Changing the Data Warehouse Center properties

Data Warehouse Center Properties notebook