To capture database tier session debug information for an OLE DB query

  1. Append the following to the URL for the query:

    &_CTXPROPERTIES=context.session.key.dbsessiondebug="true"

    For example:

    _DATAAREA=DBTEST80&_CLASS=Sybtest1&_FIELD=Mc1&_CTXPROPERTIES=context.session.key.dbsessiondebug="true"

    Note: 

    You can also specify the level of detail for the capturing of the database tier session debug by also appending a space and the following to the URL:

    context.session.key.dbsessiondebuglevel="level", where level is minimal, basic, standard, or verbose.

    For example, &_CTXPROPERTIES=context.session.key.dbsessiondebug="true" context.session.key.dbsessiondebuglevel="basic"

  2. Then use the procedures below to identify the DBSessionDebug record where you can view, export, or email it. (Session debug will only be activated for the duration of the query; no action is required to deactivate it.)