The Plan Optimization Options panel allows you to request that optimization messages be produced by CA Datacom/DB when SQL queries are prepared or executed. These are diagnostic messages that are written to the MSG table. You can view them online using the Display Messages PF key or you can query the MSG table through online CA Dataquery or in DQBATCH. Use the messages to help you solve problems with SQL queries.
Panel Description
The following list describes your message options.
DQxxxxOM
where xxxx is the terminal ID. The plan is the set of information required by CA Datacom/DB to execute the SQL query. It is created dynamically by CA Dataquery whenever a query is validated.
Select the type of messages you want retained regarding preparation time for processing the active query. Preparation time is the time needed for preparation of SQL statements for execution when a query is validated by CA Dataquery. The selections are:
No messages are captured.
Only messages summarizing processing are captured.
All messages produced during processing are captured.
Select the type of messages you want retained regarding execution time for processing the active query. The selections are:
No messages are captured.
Only messages summarizing processing are captured.
All messages produced during processing are captured.
|
Copyright © 2014 CA.
All rights reserved.
|
|