Connectable and unconnected state

 

An activation group is not connected to an application server. The only SQL statement that can be executed is CONNECT.

The activation group enters this state when:

• The connection was previously released and a successful COMMIT is executed.

• The connection is disconnected using the SQL DISCONNECT statement.

• The connection was in a connectable state, but the CONNECT statement was unsuccessful.

Consecutive CONNECT statements can be executed successfully because CONNECT does not remove the activation group from the connectable state. A CONNECT to the application server to which the activation group is currently connected is executed like any other CONNECT statement.

CONNECT cannot run successfully when it is preceded by any SQL statement other than CONNECT, COMMIT, DISCONNECT, SET CONNECTION, RELEASE, or ROLLBACK (unless running with COMMIT(*NONE)). To avoid an error, execute a commit or rollback operation before a CONNECT statement is executed.

 

Parent topic:

Activation group states