Using SQL Mode Diagnostics › Diagnostics Request

Diagnostics Request

The Diagnostic function allows the CA Dataquery Administrator to produce a CA Dataquery request table or a dump, set the optimization options or view the Optimization Messages Display panel (DQKV0).

The diagnostic information contained in the request table shows how the query was coded, which definition it was looking for in CA Datacom Datadictionary, and so on.

Diagnostics Request (DQKU0)

 =>

 ------------------------------------------------------------------------DQKU0
 DATAQUERY:  DIAGNOSTICS REQUEST
 -----------------------------------------------------------------------------
 Place any character next to the desired diagnostic facility and enter any
 required information.  Press Enter to perform the request.
 ----------------------------------------------------------------------------

 SELECT THE TYPE OF DIAGNOSTICS TO PERFORM:

                       _  DISPLAY DATAQUERY REQUEST TABLE

                       _  STORAGE DUMP (ENTER 1 or 2)
                            1. TRANSACTION DUMP
                            2. MODULE DUMP
                          TURN DUMP ON AT TERMINAL  ____
                          TURN DUMP OFF AT TERMINAL ____

                       _  SET PLAN OPTIMIZATION OPTIONS


 -----------------------------------------------------------------------------
 <PF1> HELP         <PF2>  RETURN

Panel Description

The following is a brief explanation of each field on the Diagnostics Request panel.

DISPLAY DATAQUERY REQUEST TABLE

Enter any character to execute a CA Dataquery Request Table.

STORAGE DUMP (ENTER 1 or 2)

Enter 1 to execute a transaction dump.
Enter 2 to execute a module dump.

TURN DUMP ON AT TERMINAL

Enter the terminal ID of the terminal where the query or dialog is to be executing.

TURN DUMP OFF AT TERMINAL

Enter the terminal ID of the terminal where the dump is to be turned off.

SET PLAN OPTIMIZATION OPTIONS

Enter any character to display the Plan Optimization Options panel for specifying messages and mode for the current session.

To exercise the message table you are required to have PPT (Processing Program Table) entries in a URT with a TABLE id=MSG and DBID=15.

PF Keys