IBM Support

How to generate a UDA trace on Windows without having to reboot the server..

Troubleshooting


Problem

This document outlines the steps to generate a UDA trace on Windows without having to reboot the server. Sometimes it is impractical to reboot production or critical development servers. You will have to restart the Cognos Services and the setting of the Environment Variables to enable the trace, which is only good for the current session. If you do not need to keep UDA tracing active, for instance while troubleshooting a specific issue, this may be a good solution. [NOTE:] This may not work when running VMware. If a trace file is not generated when following the steps below, you may need to create the environment variables as outlined in the Related Documents listed below. A server reboot would be required.

Resolving The Problem

Steps:

  1. Stop the Cognos Service.
  2. Launch a Windows command prompt.
  3. Set the required environment variables by running the following commands
    • set TRACE_FILE=C:\uda.log (Note: This can be set to any valid directory/file_name where the user has write permission)
    • set TRACE_LAYER_DMD_SQLAPIRW=0x2
  4. Change directory to \Cognos install location\bin\
  5. Type startup.bat
  6. Launch a Browser and run the report you are trying to capture the UDA trace for.
  7. Check C:\uda.log to ensure you have captured the UDA trace information.
  8. To stop the tracing, close the DOS session, parameters are only good for the session.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Install and Config","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1;8.4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21373137