Start of change

Command line processor COMMIT command

The command line processor COMMIT command commits all SQL work since the previous commit or rollback operation, and releases any database locks that are currently held by the active connection.

The DB2® command line processor COMMIT command performs the same function as the SQL COMMIT statement.
>>-COMMIT------------------------------------------------------><

Notes®

Implicit commit operation
By default, autocommit mode is enabled. This means that the command line processor implicitly issues a COMMIT statement after execution of every SQL statement. If an active connection exists, and you issue a new CONNECT command, the command line processor closes the currently active connection before making the new connection. When autocommit mode is enabled, the new connection can be established. However, if autocommit mode is disabled, you need to issue a COMMIT or ROLLBACK command before you issue the new CONNECT command. Otherwise, an error occurs.
End of change