DB2 10.5 for Linux, UNIX, and Windows

InterruptProcessingMode IBM data server driver configuration keyword

Sets the interrupt processing mode.

Equivalent CLI keyword

Interrupt

Equivalent IBM® data server provider for .NET connection string keyword

Interrupt

IBM data server driver configuration file (db2dsdriver.cfg) syntax

<parameter name="InterruptProcessingMode" value="0 | 1 | 2"/>

Default setting:

In Version 10.5 GA client:: 1
In Version 10.5 Fix Pack 2 and later client:: 1 for connection to all database servers other than DB2® for z/OS® servers.; 2 for connection to DB2 for z/OS servers.
Important: The default value affects direct connections to DB2 for z/OS server.

Usage notes:

The InterruptProcessingMode keyword can be set in the IBM data server driver configuration file for a specific data source.

The InterruptProcessingMode keyword can be set to the following values:

0

Disables interrupt processing (the SQLCancel function call do not interrupt the processing.)

1

Interrupts are supported. In this mode, if the server supports an interrupt, an interrupt is sent. Otherwise, the connection is dropped.

The settings for INTERRUPT_ENABLED (a DB2 Connect™ gateway setting) and the DB2 registry variable DB2CONNECT_DISCONNECT_ON_INTERRUPT takes precedence over the Interrupt keyword setting of 1.

When you connect to a DB2 for z/OS server with the interrupt mode 1 setting, the following operations are not interrupted:

Stored procedure operations.
SQL statement operations that hold a DB2 internal resource lock manager (IRLM) lock used by DB2 for z/OS servers to serialize access to your data. DB2 for z/OS servers request locks from IRLM to ensure data integrity when applications, utilities, and commands attempt to access the same data.

2

Interrupt drops the connection regardless of server's interrupt capabilities (the SQLCancel function call drops the connection).

In Version 10.5 Fix Pack 2 and later, interrupt processing mode 2 is the default value when you are directly connecting to a DB2 for z/OS server.

Embedded C or C++ applications supports the QueryTimeout keyword for running SQL statements. The QueryTimeout keyword must be specified in the IBM data server driver configuration file (db2dsdriver.cfg). Application can specify a unique QueryTimeout keyword value for each database alias entry in the IBM data server driver configuration file.

The interruptProcessingMode keyword value affects when the QueryTimeout keyword value elapses.