An important feature of the relationship between CA Dataquery SQL Mode and CA Datacom/DB is the plan defined in CA Datacom/DB for processing SQL queries. You can specify some options of the plan as they pertain to queries and you can use the abilities of the plan to request diagnostic information if query processing problems arise. You should only request diagnostics if asked to do so by CA Support.
Function
The Diagnostic function allows the CA Dataquery Administrator to produce a CA Dataquery request table, a transaction dump, or a module dump. It also allows you to set the optimization options for the current session.
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. A dump provides information needed by CA Support.
Three panels, one command, and two batch mode parameters allow you to access the CA Datacom/DB plan.
Panel DQKU0
Allows you to request a request table or a dump if needed by CA Support, or to set options for plan optimization.
Panel DQKT0
For the current online session, allows you to specify the types of messages you want to receive and to specify that the plan should use the join order specified in the FROM clause of the SQL query.
Panel DQKV0
For the current online session, displays messages requested and allows you to delete messages after viewing.
Displays the Plan Optimization Options panel.
Card Parameter
Allows plan optimization in batch mode.
Card Parameter
Allows plan optimization in batch mode.
|
Copyright © 2014 CA.
All rights reserved.
|
|