Logging SQL queries

You can log all the SQL queries that are issued by the CICS® IA or CICS PA plug-in, and view the query text, the time when the query was issued, and the ID of the process thread that executed the query.

About this task

You use the Database Retrieval Debug pane in the Preferences window to start or stop logging the SQL queries that are issued by the plug-in, and to open the DB Retrieval Debug view. You use the DB Retrieval Debug view to view details of the SQL queries that are logged. You can also use this view to start or stop logging the SQL queries, and to clear the table of entries in the view.

Procedure

  1. From the workbench menu bar, click Window > Preferences > Database Retrieval Parameters > DB Retrieval Debug. The Database Retrieval Debug pane is displayed in the Preferences window:
    Screen capture of the Preferences window that shows the Database Retrieval Debug panel
  2. To start logging SQL queries, click Yes.
  3. To stop logging SQL queries, click No.
  4. To view details of the SQL queries in the DB Retrieval Debug view, click Open Debug View, then click OK. This view shows the following information:
    Message
    The text of the SQL query
    Date
    The time and date when the SQL query was issued
    Thread ID
    The ID of the process thread that executed the SQL query
  5. To start or stop logging the SQL queries from the DB Retrieval Debug view, click the SQL Logging: On or SQL Logging: Off icon SQL logging icon, as appropriate, in the toolbar of the view.
  6. To clear the table of SQL messages in the DB Retrieval Debug view, click the Clear log table icon Clear log table icon in the toolbar of the view.