Specifying ANLCNTL configuration parameters and selecting the target host system
Db2 SQL Performance Analyzer has the capability to project its anticipated cost and performance estimates on any configuration, including production host machines and hypothetical configurations not yet in place. The ANLCNTL parameters are not normally modified by Db2 SQL Performance Analyzer users.
About this task
The parameters define a target host configuration.
You can run Db2 SQL Performance Analyzer on a test machine and to forecast application performance on a production system.
You can have multiple configurations (PDS members) in batch using the ANLCNTL DD statement to point to the hiqual.SANLDATA PDS member, and in TSO by having multiple members in the hiqual.SANLPARM PDS.
The ANLCNTL system configuration parameters are stored in a PDS library, allowing you to select a specific target system (PDS member) for the cost analysis of SQL PA.
For SQL PA operating under TSO online, the hiqual.SANLPARM library is provided as a place to store the various configurations for different host systems, including ones that exist at your site and sample configurations that you want to test against. This PDS is populated with members for each Db2® host during installation.
In batch mode you can allocate one of these members in the ANLCNTL DD statement, point to your own copy as a flat file, or use SYSIN DD * and define them in-stream.