DB2 Version 9.7 for Linux, UNIX, and Windows

Default value or behavior of selected IBM Data Server Driver keywords have changed

In Version 9.7 Fix Pack 6 and later fix packs, the default values for the QueryTimeoutInterval CLI/ODBC configuration keyword, and ClientWorkstationName IBM® Data Server Driver keyword have changed. Also, the behavior of ConnectionTimeout keyword has changed.

Details

The QueryTimeoutInterval CLI/ODBC configuration keyword specifies the time interval in seconds before the query timeout is checked. The default value for the QueryTimeoutInterval CLI/ODBC configuration keyword is now 1 second.

The ClientWorkstationName keyword specifies the client workstation name that is sent to a database. The default value for the ClientWorkstationName keyword is now the host name of the client.

The ConnectionTimeout keyword specifies the time in seconds to wait for a reply when trying to establish a connection to a server before terminating the attempt. The ConnectionTimeout keyword value is enforced for a connection regardless of a high availability solution being enabled. If a connection attempt fails within the time specified by the ConnectionTimeout value, control is returned to the application with an SQL30081N error.