Start of change

CURRENT QUERY ACCELERATION WAITFORDATA

The CURRENT QUERY ACCELERATION WAITFORDATA special register specifies the maximum amount of time, if any, that the accelerator delays a dynamic SQL query while the accelerator waits for the replication of committed Db2 data changes that occurred prior to Db2 running the query. This special register does not apply to static SQL queries.

The data type is a DECIMAL(5,1) in the form of nnnn.m.

Valid values are a numeric constant in the range of 0.0 - 3600.0 seconds. For example, a value of 20.0 represents 20.0 seconds (or 20000 milliseconds), and a value of 30.5 represents 30.5 seconds (or 30500 milliseconds). The maximum value of 3600.0 means that the query is delayed for 60 minutes.

The default value is 0.0, which means that the query is not delayed and is run immediately on the accelerator. Other WAITFORDATA behavior is not applied to the query.

The wait time value can also be specified as an INTEGER numeric constant value ranging from 0 - 3600 seconds, which Db2 will convert to a DECIMAL (5,1) value.

You can change the value of the special register by executing the SET CURRENT QUERY ACCELERATION WAITFORDATA statement.

The initial value of CURRENT QUERY ACCELERATION WAITFORDATA is determined by the value of the Db2 QUERY_ACCEL_WAITFORDATA subsystem parameter. The default for the initial value of this subsystem parameter is 0.0 unless your installation has changed the value.

For more information about the restrictions, requirements, and behaviors associated with CURRENT QUERY ACCELERATION WAITFORDATA, see SET CURRENT QUERY ACCELERATION WAITFORDATA.

Example: The following statement sets the CURRENT QUERY ACCELERATION WAITFORDATA special register so that the accelerator delays queries for 180 seconds (three minutes) while it waits for committed Db2 data changes to be replicated to the accelerator.
  SET CURRENT QUERY ACCELERATION WAITFORDATA 180;
End of change