Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Distributed Trace Formatter: A Program to Format Trace Data In Any Format and Any Language

IP.com Disclosure Number: IPCOM000121542D
Original Publication Date: 1991-Sep-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 3 page(s) / 80K

Publishing Venue

IBM

Related People

Jordan, LE: AUTHOR [+3]

Abstract

Trace data for Database Manager is difficult to read. It is shown as hexadecimal bytes which makes understanding the underlying data structures difficult. Distributed trace allows the user to format the data in any format or language.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Distributed Trace Formatter: A Program to Format Trace Data In Any
Format and Any Language

      Trace data for Database Manager is difficult to read.  It
is shown as hexadecimal bytes which makes understanding the
underlying data structures difficult.  Distributed trace allows the
user to format the data in any format or language.

      The distributed trace formatting consists of three parts:
      1)   The trace formatters placed in the trace probes.
      2)   The formatter program.
      3)   The format file which maps the formatters in the traced
data to the formats the user desires.
      1)   When the program author places trace statements (probes)
in the program code, he may instruct the trace facility to save as
many data areas as desired (for later debugging).  Each data area
that is to be saved must also be assigned a "trace formatter".  The
formatter is an integer, and the choice of what formatter to use for
what data type (or structure) is completely arbitrary.
         Examples of formatters are:
             1 - the data is an integer
             2 - the data is a character string
             3 - the data is a SQLCA structure
             etc...
      2)   Distributed trace provides a FORMAT program.  It takes the
information in the trace data file on a given machine, and formats it
based on the formatters in the trace data and the format descriptors
in the format file. Since this is a part of distributed trace, FORMAT
can work on trace data on either the local or a remote workstation.
This allows a user to work on all of the trace data for a particular
database session from one location.
      3)   The trace formatters are listed in a file of trace
formatter descriptions.  The descriptions are in a form very similar
to the printf language used by C.  What follows is an example of a
formatter:
           10: "This is an SQLCA\n\n"
               "uc(8), ld, ld, s, uc(7), uc(8), l(6),
                uc(11),
                uc(5)"
               "Eyecatcher: %1\n", %s
               "Sqlcode   : %3\n", %ld
         ...