Setting isolation-level behavior for applications after migration

Version 9 and later supports statement-level isolation for remote Db2® family data sources and Microsoft SQL Server data sources. If you migrate from version 8, existing applications that contain a WITH isolation clause in SELECT, INSERT, UPDATE and DELETE statements might show different isolation behavior. If you want the application to show pre-upgrade isolation level behavior, you must disable statement-level isolation.

Procedure

Set the DB2_STATEMENT_ISOLATION server option to N from the CREATE SERVER or ALTER SERVER statement, for example:

ALTER SERVER db2server OPTIONS (ADD DB2_STATEMENT_ISOLATION 'N')