Previous Topic: Diagnostics RequestNext Topic: Plan Optimization Options

Using SQL Mode Diagnostics › Diagnostics Request › Request Table

Request Table

Enter any character in the DISPLAY DATAQUERY REQUEST TABLE option field and press Enter to perform the request. CA Dataquery displays the Current CA Dataquery Request Table panel, an example of which follows:

Current CA Dataquery Request Table (DQKF0)

 =>

 ------------------------------------------------------------------------DQKF0
 DATAQUERY:  CURRENT DATAQUERY REQUEST TABLE
 -----------------------------------------------------------------------------
  C 0004C3D8                                                               00000
  N 0006D5FFFFFF                                                           00004
  F 0035C600D7C1E8D9D6D3D3404040404040404040404040404040404040404040404040 0000A
    400001D7C1E80001C5D4D7D5D6C5D4D7D5D6
  + 00054EE600                                                             0003F
  I 0032C900E8E3C460C3D6D4D4C9E2E2C9D6D54040404040404040404040404040404040 00044
    40000100D500080602D50017C3
  R 0004D902                                                               00076
  V 000CE500000000000200000F                                               0007A
  + 00054ED900                                                             00086
  F 0035C600D7C1E8D9D6D3D3404040404040404040404040404040404040404040404040 0008B
    400001D7C1E80001C5D4D7D5D6C5D4D7D5D6D
  K 0033D240D5E4D4C2C5D940404040404040404040404040404040404040404040404040 000C0
    40C5D4D7D5D6D405D500050500D5000
  F 0035C600D7C5D9E2D6D5D5C5D340404040404040404040404040404040404040404040 000F3
    400001D7D4C60001C5D4D7D5D6C5D4D7D5D6
 -----------------------------------------------------------------------------
 <PF1>  HELP       <PF2>  RETURN       <PF3>  NOT USED     <PF4>  NOT USED
 <PF5>  NOT USED   <PF6>  NOT USED     <PF7>  BACKWARD     <PF8>  FORWARD

The information displayed by the execution of the CA Dataquery Request Table is used by CA Support to help solve certain problems.

PF Keys

Key

Objective

Result

CLEAR

Return to Main Menu.

Return to the Main Menu.

<PF1> HELP

Display HELP panel
PF key options.

CA Dataquery displays the HELP panel.

<PF2> RETURN

Return to previous panel.

Previous panel or Main Menu is displayed.

<PF3> NOT USED
<PF4> NOT USED
<PF5> NOT USED
<PF6> NOT USED

Not used.

 

<PF7>BACKWARD

Scroll to previous CA Dataquery Request Table screen, if any.

Display previous CA Dataquery Request Table screen, if any.

<PF8> FORWARD

Scroll to next screen
of CA Dataquery Request Table, if any.

Display more CA Dataquery Request Table, if any.

If the problem with the query or dialog cannot be solved from the information received from the CA Dataquery Request Table, CA Support can request that you produce a transaction or module storage dump.

Transaction or Module Dump

To produce a transaction or module dump, select the DIAGNOSTICS option from the Administrative Menu, or use the DIAG command from the command line and:

Step 1

Enter 1 for a transaction dump, or 2 for a module dump next to the STORAGE DUMP option.

Step 2

Enter the terminal ID of the user who executed the query in the space following the TURN DUMP ON AT TERMINAL prompt.

Step 3

Execute the query from the specified terminal.

Step 4

When it is time to turn the dump off, place the same terminal ID used to turn the dump on in the space following the TURN DUMP OFF AT TERMINAL prompt.

CA Dataquery turns on a transaction dump or module dump at the specified terminal. The transaction dump produces a dump for every screen displayed on the selected terminal, while a module dump produces a dump for every program that is invoked by CA Dataquery to process a screen. These dumps are written to the CICS dump data sets. Contact your systems programmer to print the dumps. The dumps have special identifiers for CA Dataquery.

CA Support can review the dumps or the CA Dataquery Request Table with you or the systems programmer over the telephone, or request that you send the dumps to the CA Support office.