StarQuest Technical Documents

How to Generate a DRDA Trace

Last Update: 4 August 2016
Product: StarSQL
Version: All
Article ID: SQV00SQ017


This document explains how to generate a DRDA trace with the StarSQL DRDA Trace Recorder.  DRDA traces are helpful to resolve problems that result in an unusual DRDA reply code point, a language conversion error, an application GPF, or a DB2 error.  A DRDA trace is not a substitute for an ODBC trace. See How to Generate an ODBC Trace for instructions on creating an ODBC trace.


StarSQL Trace Recorder (Windows)

Follow these steps to perform a DRDA trace with the StarSQL Trace Recorder:

  1. You can find the DRDA Trace Recorder in the StarSQL program group. A magnifying glass icon will appear in the system tray when the Trace Recorder is active.

    DRDA Trace Recorder icon

  2. A dialog box entitled Save DRDA Trace File As will appear.

    Save As dialog

  3. Enter a file name and change the Save in directory, if desired, and click Save.
  4. You will see a message that says: "DRDA Tracing Has Been Enabled."

    Tracing Enabled confirmation dialog

  5. After you have reproduced your problem, turn off tracing. Right-click on the magnifying glass icon and select "Stop Trace" or "Close". You will see a message that says: "DRDA Tracing Has Been Disabled."

    Tracing Disabled confirmation dialog

  6. The file is located in the StarSQL\Programs directory by default and will have the extension .sqd. Please attach the file to an email and send it to StarQuest Customer Support.

Enabling DRDA Tracing on UNIX

On UNIX, you can enable user-specific DRDA tracing by creating $HOME/.swodbc.ini and executing the trcstart command located in the $STARSQL/bin directory

$ cp $STARSQL/etc/swodbc.ini $HOME/.swodbc.ini
$ chmod 644 $HOME/.swodbc.ini
$ trcstart -on /tmp/trace.sqd

After collecting the trace, disable the trace with trcstart -off or delete $HOME/.swodbc.ini; we recommend the latter so that you are always using the current version of the system-wide $STARSQL/etc/swodbc.ini.

Enable system-wide DRDA tracing by adding the following to etc/swodbc.ini in the StarSQL program directory:

DRDATraceFile = /tmp/trace.sqd

Using StarPipes to collect DRDA traces

To capturing DRDA traces from Windows services such as StarQuest Data Replicator, SQL Server Linked Server, and Oracle DG4ODBC, we recommend using the StarQuest StarPipes gateway. StarPipes an be useful in other situations, both UNIX and Windows, such as capturing traces from one particular ODBC data source.

See How to Generate DRDA and Debug Traces Using StarPipes for Windows. Your support engineer will supply you the download URL and temporary license keys for StarPipes if necessary.


The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.