The Optimization Messages Display panel displays plan optimization messages which were produced by CA Datacom/DB for the last SQL query prepared or executed for which messages were requested. These messages can be used for problem solving for SQL queries.
This panel appears when you select DISPLAY MESSAGES from the Plan Optimization Options panel. Any user authorized for diagnostic functions may view this panel.
=> ------------------------------------------------------------------------DQKV0 DATAQUERY: OPTIMIZATION MESSAGES DISPLAY ----------------------------------------------------------------------------- STMT ID SEQ # MESSAGE TEXT ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DELETE MESSAGES <PF4> NOT USED <PF5> NOT USED <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD
From this panel you can request that these messages be deleted from the MSG table when they are no longer needed by pressing <PF3> DELETE MESSAGES. See the CA Datacom/DB Message Reference Guide for information about the messages that appear on this panel.
|
Copyright © 2014 CA.
All rights reserved.
|
|