QueryTimeout

Integer (seconds)

60

Purpose

The QueryTimeout parameter specifies the number of seconds that the RPS Datapump application on the RPS node waits for a query involved in replicating data to be executed on the SQL Server database before a timeout occurs.

If the value is set to zero (0), the Datapump application waits indefinitely for the query to complete. If the value is set to -1, no call is made to the SQL Server database to explicitly set a timeout value.

The QueryTimeout parameter is not created or updated by the RPS Manager application.

Parameter is read when one of the following occurs…

The Datapump application is started.

Applicable to database role or subrole…

RPS node only.