DB2®ConnectionStringBuilder.Interrupt Property

Gets or sets the interrupt processing mode.

Namespace:
IBM.Data.DB2
Assembly:
IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual Basic]
Public Property Interrupt As int
[C#]
public int Interrupt {get; set;}
[C++]
public: __property int* get_Interrupt();
public: __property void set_Interrupt(int*);
[JScript]
public function get Interrupt() : int;
public function set Interrupt(int);

Property value

An integer value (0, 1, or 2) representing the interrupt processing mode.

Set the Interrupt keyword as follows:
  • 0 - Disables interrupt processing.
  • 1 - If the database server supports an interrupt, an interrupt is sent. Otherwise, the connection is dropped.
    When you connect to a Db2® for z/OS® server with the Interrupt property value 1 setting, the following operations are not interrupted:
    • Stored procedure operations.
    • SQL statement operations that hold an 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.

In Version 10.5 GA, the default Interrupt property value is 1 for connection to all database servers.

In Version 10.5 Fix Pack 2 and later, the default Interrupt property value is 1 for connection to all database servers other than the Db2 for z/OS servers. The Interrupt property value 2 is the default value when you are directly connecting to a Db2 for z/OS server.