DSNE363A ONLY RR (REPEATABLE READ), CS (CURSOR STABILITY), OR UR (UNCOMMITTED READ) ALLOWED

Explanation

The user has entered an invalid isolation level. This value must be one of the following:

• RR
• CS

'Isolation level' here refers to the degree to which the SPUFI user wants to isolate SQL execution from the effects of other concurrently executing Db2 applications.

RR

If the repeatable read (RR) level is specified and the AUTOCOMMIT option is 'YES', other applications can modify the selected database values as soon as the SPUFI EXECUTE phase is completed and as soon as the automatic COMMIT (or ROLLBACK, if an error was encountered) operation is performed. Therefore, it is possible that the retrieved data being browsed by the user has already been modified by another application.

If the RR level is specified and the AUTOCOMMIT option is 'NO', then no other Db2 application executing concurrently can change any of the selected database values until the SPUFI user issues either a COMMIT or a ROLLBACK. Therefore, other applications might be in a normal wait state while the SPUFI user is browsing the output data set.

CS

If the cursor stability (CS) level is specified, it does not make any difference whether the AUTOCOMMIT option is 'YES' or 'NO'. Other concurrently executing Db2 applications can change the selected database values as soon as the SELECT has completed.

UR

If the uncommitted read (UR) level is specified, SPUFI queries can read data that has been changed, but has not yet been committed by another application. It does not make any difference whether the AUTOCOMMIT option is 'YES' or 'NO'. Other concurrently executing Db2 applications can change the selected database values without waiting for the SELECT to complete.