DISCONNECT bind option
The DISCONNECT option determines which remote connections to destroy during commit operations.
| Command option | Option values | Used with |
|---|---|---|
| DISCONNECT |
|
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.
- DISCONNECT(EXPLICIT)
- Destroy only connections in the release pending state. This value allows you maximum flexibility for controlling remote connections.
- DISCONNECT(AUTOMATIC)
- Destroy all remote connections.
- DISCONNECT(CONDITIONAL)
- Destroy all remote connections unless an open cursor defined as WITH HOLD is associated with the connection.
Default values for DISCONNECT
| Process | Default value |
|---|---|
| BIND PLAN | EXPLICIT |
| BIND PACKAGE | N/A |
| REBIND PLAN | Existing value |
| REBIND PACKAGE | N/A |
Catalog records for DISCONNECT
See the DISCONNECT column in SYSPLAN catalog table.