Specifies the maximum number of asynchrony table queues (ATQs) that the federated server supports in the access plan for programs
that use embedded SQL.
Syntax:
FEDERATED_ASYNCHRONY={ANY | atqsNo}
NOFEDERATED_ASYNCHONY
Parameters:
| ANY
|
The optimizer determines the number of ATQs for the access plan. The optimizer assigns an ATQ to all eligible SHIP or remote
pushdown operators in the plan. The value that is specified for DB2_MAX_ASYNC_REQUESTS_PER_QUERY server option limits the
number of asynchronous requests.
|
| atqsNo
|
The number of ATQs in the plan. You specify a number in the range 0 to 32767.
|
Properties:
| Default:
|
NOFEDERATED_ASYNCHONY
|
Comment:
Applies to DB2 LUW only.