Connections must be ended under certain circumstances.
Connections
end when:
- In Interactive SQL or Embedded SQL, a user or application issues an explicit
DISCONNECT statement for the current connection, a specified connection, or all
connections for that application
- In Interactive SQL, a user selects SQL > Disconnect
- An application with active connections, such as Interactive SQL, is closed
Users with
DROP
CONNECTION system privilege can also drop a specific connection in Interactive SQL or
Embedded SQL by issuing a DROP CONNECTION statement.