Previous Topic: Solving Batch CA Dataquery ProblemsNext Topic: Diagnostics Request


Using DQL Diagnostics

Diagnostics is an administrative function that is accessed from the Administrative Menu, but is only used on a request from CA Support.

For example, a user has written a query that has been edited and validated, but yet does not execute, has performance problems, or gets the wrong results. In some cases, CA Dataquery returns an error message instructing the user to contact his CA Dataquery Administrator. The CA Dataquery Administrator, in turn, if the problem is with CA Datacom/DB, can call CA Support. CA Support can request that you perform diagnostics on the query to provide more information.

Function

The Diagnostic function allows the CA Dataquery Administrator to produce a CA Dataquery request table, a transaction dump, a module dump, or a Compound Boolean Selection Facility Diagnostic Report.

Overview

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. The Compound Boolean Selection Facility Diagnostic report shows exactly what CA Dataquery passed to the Compound Boolean Selection Facility and how the Compound Boolean Selection Facility interpreted it. This report shows whether it is CA Dataquery or the Compound Boolean Selection Facility causing the problem.

Action

To produce a request table, you must first validate the query. When CA Dataquery returns an error message, go to the Administrative Menu and select the DIAGNOSTICS option or use the DIAG command from the command line. CA Dataquery displays the DIAGNOSTICS REQUEST panel, examples of which follows on the next page and in the next chapter.