Tuning considerations for asynchrony optimization

If your system has available process, memory, and CPU resources, enabling asynchrony can improve the performance of your federated queries. Enabling asynchrony can also increase the use of remote-source systems by the federated server, because a remote source can potentially process more than one request at a time on behalf of a federated query. If your system has resource constraints, asynchrony might degrade performance.

You can tune your system for asynchrony by changing configuration parameters to achieve the degree of asynchrony that is best for your system.

Each asynchronous TQ that asynchrony optimization introduces into a plan requires an additional subagent. If enough subagents are available in the system, consider tuning the MAXAGENTS database manager configuration parameter.