Using 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 may have 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 call CA Support. CA Support may request that you perform diagnostics on the query because they need more information about the query.

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

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 CA Dataquery is causing the problem or the Compound Boolean Selection Facility.

SQL Mode diagnostics functions somewhat differently, in that you can request summary, detail, or no messages about query processing.

For more information, see Using DQL Diagnostics and Using SQL Mode Diagnostics for detailed instructions about using the diagnostics facility.