CHANGE ISOLATION (Db2 command line processor)

The CHANGE ISOLATION command changes the isolation level for SQL statements that the Db2 command line processor executes.

Read syntax diagramSkip visual syntax diagram CHANGE ISOLATION TO RRRSCSUR

See ISOLATION bind option for the meanings of the isolation levels.

During the Db2 command line processor session, the CHANGE ISOLATION command overrides the isolation value that is set in the IsolationLevel property in the Db2 command line processor properties file. The CHANGE ISOLATION command cannot be executed if a transaction is active.