Skip to main content

Generating a HiT ODBC or OLE DB Trace

Jenny Drummey
  • Updated

You can create both global and low-level traces using HiT ODBC/OLEDB Toolbox (or Workshop).  The utility to be used and the instructions depend on the version of software you are using.

To create a Global Trace

  1. Exit from the application you want to trace.
  2. Open HiT Toolbox or Workshop from the Start\Programs\HiT ODBC menu or Start\Programs\HiT OLEDB menu.
  3. On the left hand side, you will see a folder labeled “Trace”. Open the Traces folder and double click on Global Trace
  4. HiT ODBC: Check Activate Global Trace; HiT OLEDB: Select 1-Trace
  5. Use the default Trace FileName or Insert a file name.
  6. Click on OK
  7. Please leave HiT Toolbox/Workshop running. If Toolbox (Workshop) is closed, the trace will terminate before having captured the data.
  8. Start the application you want to trace
  9. Run the query you want to trace
  10. Switch off <instructions below> the trace

To stop a Global Trace

  1. Open Traces and double-click on Global Trace
  2. HiT ODBC: Uncheck ‘Activate Single DSN Trace’; HiT OLEDB: Select 0-No Trace
  3. Click on OK
  4. Exit HiT Toolbox

To create a Low Level Trace

  1. Exit from the application you want to trace.
  2. Open HiT Toolbox or Workshop from the Start\Programs\HiT ODBC menu or Start\Programs\HiT OLEDB menu. The figure below is an example of creating a Global Trace file with HiT OLEDB/400 driver. The HiT ODBC driver has a similar user interface.
  3. Open Traces and double-click on Low Level Traces
  4. Check Activate Communication Trace and Activate ODBS Trace.
  5. Use the default Trace FileName or Insert a file name.
  6. Click on OK
  7. Please leave HiT Toolbox (Workshop) running. If Toolbox (Workshop) is closed, the trace will terminate before capturing the data
  8. Start the application you want to trace
  9. Run the query you want to trace
  10. Switch off <instructions below> the trace

To stop a Low Level Trace

  1. Open Traces and double-click on ‘Low Level Trace’
  2. Uncheck ‘Activate Communication Trace’ and ‘Activate ODBS Trace’.
  3. Click on OK
  4. Exit HiT Toolbox (Workshop)

Related articles