DISCONNECT bind option
The DISCONNECT option determines which remote connections to destroy during commit operations.
| DISCONNECT |
|
On: BIND and REBIND PLAN |
The option applies to any application process that uses
the plan and has remote connections of any type. Regardless of the
value of this option, a commit operation destroys all connections
in the release pending state. You can put a connection in the release
pending state using the SQL statement RELEASE.
- ( EXPLICIT )
- Destroy only connections in the release pending state. This value allows you maximum flexibility for controlling remote connections.
- ( AUTOMATIC )
- Destroy all remote connections.
- ( CONDITIONAL )
- Destroy all remote connections unless an open cursor defined as WITH HOLD is associated with the connection.
Defaults:
| Process | Default value |
|---|---|
| BIND PLAN | EXPLICIT |
| BIND PACKAGE | N/A |
| REBIND PLAN | Existing value |
| REBIND PACKAGE | N/A |
Catalog record: Column DISCONNECT of table SYSPLAN.