Previous Topic: -143 - INVALID PLAN OPTION: DECPOINTNext Topic: -145 - INVALID ‘ISOLEVEL’ PLAN OPTION:


-144 - TRX ISOLATION LEVELS UNMATCHED

Reason:

The transaction isolation level as coded in the SQL plan, and stored in the current LUW structure corresponding to that plan, do not match.

The SQLSTATE that equates to this SQL return code is 25004.

Action:

Verify that the isolation level of the plan is correct and that no modifications have been made to it during execution. All plans opened concurrently for the same logical unit of work (LUW) must have the same isolation level.