Tuning Your System for CA Dataquery › Tuning the CA Datacom/DB Operating Environment

Tuning the CA Datacom/DB Operating Environment

Multi-User Facility

Some companies can profit from having an additional MUF to handle very heavy batch workloads. They may even wish to put the second MUF on a completely separate CPU. CA Dataquery can run in batch on this machine.

Coding the CA Datacom/DB MUF startup options appropriately can affect the efficiency of CA Dataquery row searches. In a MUF environment with several applications running at the same time, consider how adjustments to the MUF startup option affect CA Dataquery and all the active applications. Expect to make trade-offs.

Here are some CA Datacom/DB MUF tuning recommendations:

• When a query does not specify a key, CA Dataquery uses the Native Key to search the entire table. To reduce processing time at sites where table type searches are common:
  • Determine which type of indexing will best meet the needs of CA Dataquery users and add the necessary keys.
  • Increase the number of data index buffers and data buffers. (This provides more data per I/O event but increases the transfer time of data and the storage required.)
  • Increase the size specified for the data buffers (DATAPOOL MUF startup option) and the user data table block sizes. (This provides more data per I/O event but increases the transfer time of data and the storage required.)
• For heavily used systems, provide enough data buffers to keep the data block in storage until CA Dataquery is finished with it.

Data Set Placement

High activity data sets (CA Dataquery tables) should be placed on different DASD/channels. When analyzing the performance of the active data sets: utilization for disk should be less than 50 percent and utilization for channels should be less than 30 percent. If the percentages are higher than this, you should consider moving the data sets to a different channel.

High activity data sets (CA Dataquery tables) should be placed on separate packs. Often it is advantageous to place them near the center of the pack. This is good for the DQF and DQM tables.