A basic System Option Table is installed when you install CA Dataquery. The DQOPTLST macro creates a System Option Table when it is assembled and link-edited. Default DQOPTLST parameters that affect space or resource allocations are specified at installation/upgrade time. If you decide to change any parameter value at a later time, you can do so, but you must reassemble the DQOPTLST macro to re-create the System Option Table.
The CA Dataquery System Option Table determines such CA Dataquery system options as:
The system options are defined by the DQOPTLST macro. The CA Dataquery Administrator can override some of the defined system options for specific users through a CA Dataquery administrative function. Parameters which the CA Dataquery Administrator can override are noted in the descriptions on the following pages.
Options Which Impact CA Dataquery Performance
Evaluate the effect of the parameters which affect the number of physical blocks used for query execution, the amount of query processing time, the maximum find time, and the number of times CA Dataquery is to relinquish control to other tasks during the execution of a query, such as:
SQL users are not impacted by the DQOPTLST parameters MXREQ=, MFTIME=, and MXTLR= because SQL is a database management language.
Option Table Considerations
Before specifying the DQOPTLST parameters, determine the answers to the following questions about your CA Dataquery environment.
|
Copyright © 2014 CA.
All rights reserved.
|
|