Addressing DQ468I "THE EXECUTION OF YOUR FIND STATEMENT IS IN PROGRESS" message

Products

• Datacom
• Datacom/DB

Issue/Introduction

When a Dataquery FIND against a large table causes the number of I/Os to exceed the MXREQ value, the message DQ468I "The execution of your find statement is in progress" and then panel DQE50 is displayed asking to press PF4 to continue. This occurs several times. How can we reduce the number of times this happens?

Environment

Component : Datacom/DB

Component : Dataquery

Cause

The Dataquery DQOPLST setting for MXREQ= directs Dataquery to issue message DQ468I each time the number of I/Os reaches the MXREQ limit. This is done so the user has the option to terminate a long-running query early.

Resolution

When using QUERYLANG of DQL, if a query or dialog runs longer than permitted based on the values specified in the MXREQ and MXTLR fields on the User Table Maintenance Menu in DQRY, Dataquery displays the Data Selection Status panel DQE50.

The MXREQ= DQOPTLST parameter tells Dataquery to issue message DQ468I each time the number of I/Os reaches the MXREQ limit.
The MXTLR= parameter tells Dataquery to count the number of DQ468I messages up to the specified MXTLR limit. When MXTLR is reached, the execution is stopped, allowing the user to continue or to end the request.

Both parameters have defaults that are customizable in the DQOPTLST module. The default for MXREQ is 100 (Datacom physical I/O events allowed at once). The default for MXTLR is 10 (number of MXREQs before an interrupt occurs).

MXREQ and MXTLR can also be tuned online in DQRY by the DBA for each user via the Dataquery Administration option. To do this, pick Option 8 (Users) to select one user via PF4 (Update) then PF4 (Additional Options) display panel DQUM0. Panel DQUM0 allows an administrator to override some of the DQOPTLST parameters like MXREQ and MXTLR.

For example, by setting MXTLR=50, the occurrences of DQE50 panel will happen less often and so will make the overall execution faster and easier for the user.

Additional Information

For more information about the DQOPTLST settings, please refer to the documentation for Tailoring the Dataquery System Option Table.

As always, please contact Broadcom support for Datacom if you have further questions.