If your site is installing both CA Dataquery and CA Datacom/DB at the same time, the CA Datacom installation generates the interface between them.
If your site is adding CA Dataquery to an existing CA Datacom/DB system or modifying CA Datacom/DB (such as adding databases and tuning the system), the following items need to be reviewed to help ensure that CA Datacom/DB continues to support CA Dataquery:
Preparing the MUF
All data managed by CA Datacom/DB that is to be accessed by CA Dataquery must be available on one MUF, unless CA Datacom STAR is used for distributed processing. For special considerations involving processing in a distributed environment, see your CA Datacom STAR documentation.
The MUF must include the appropriate JCL statements for all storage areas if CA Datacom/DB's dynamic allocation feature is not in use.
For more information about the MUF, see the CA Datacom/DB Database and System Administration Guide.
Multi-User Startup Options
CA Dataquery operates with the CA Datacom/DB MUF. The MUF with which you operate CA Dataquery must be initiated meeting the specific startup options requirements described in the table on the following pages.
Note: For complete information about all of the CA Datacom/DB MUF startup options, see the CA Datacom/DB Database and System Administration Guide.
Multi-User Startup Option
These options control the resources available for the CA Datacom/DB Compound Boolean Selection Facility which processes CA Dataquery queries. The values specified for these startup options affect CA Dataquery performance.
Specifies the database ID in which the Compound Boolean Selection Facility builds temporary indexes when processing queries. We recommend database 6 for this use.
Specifies the size of the buffer available for Compound Boolean Selection processing. Must be a minimum of 1024. While you are using CA Dataquery, check the CBSBFR SPILL COUNT statistic in the Statistics and Diagnostics Area report. If the count is high, you can decrease it and improve performance by increasing the CBS buffer value.
Limits the number of temporary index entries which the Compound Boolean Selection Facility creates before terminating processing. If no MAXSTEN value is specified, the Compound Boolean Selection Facility creates as many temporary index entries as are necessary to satisfy a query. If your site is having problems with the Index Area filling up (receiving a CA Datacom/DB return code 8 on a SELFR when executing queries), you can use this parameter to limit how much of the Index Area one SELFR can allocate. Consider that although most SELFRs issued by CA Dataquery do not cause a temporary index to be built, it is possible to have one for each table named in a query existing simultaneously. If a SELFR terminates because this limit has been set, query execution also terminates with a CA Datacom/DB return code 91.
Note: You can use the MAXSTEN console command to temporarily change this option while MUF is operating. For details, see the CA Datacom/DB Database and System Administration Guide.
Limits the number of CA Datacom/DB records inspected by the Compound Boolean Selection Facility when processing a query. If no MAXSTIO value is specified, the Compound Boolean Selection Facility inspects as many records as necessary to satisfy a query.
Note: You can use the MAXSTIO console command to temporarily change this option while MUF is operating. For details, see the CA Datacom/DB Database and System Administration Guide.
Allows you to specify the age beyond which unused sets can be deleted.
This option specifies the licensed CA products that execute with this MUF. DQ must be one of the entries for CA Dataquery to execute.
This option controls the number and size of the buffers for data access (data buffers). You can also specify an optional second set.
Specifies the size of the data buffers and, when using CA Dataquery, must be a minimum of 4096.
Specifies the number of data buffers.
Specifies the maximum number of records over which a single task can simultaneously hold under exclusive control. When using CA Dataquery, this must be a minimum of 8.
This option controls the number and size of the buffers for expanding compressed records.
Specifies the size of the expand buffers which, when using CA Dataquery, must be a minimum of 4108 or 12 bytes larger than the largest record that is to be expanded.
CA Dataquery tasks access compressed tables so include the CA Dataquery tasks in your specification. See the Master List discussion in the CA Datacom/DB documentation for details.
Specifies the maximum number of elements which can be accessed by a request. This option must be a minimum of 10 for CA Dataquery.
|
Copyright © 2014 CA.
All rights reserved.
|
|