The Isolation level is referenced by the Process Source Definition step only for the SQL(S) extract type as opposed to the Utility(U) type extract.
Correct specification of the isolation level for SQL access to carry out the extract may reduce the contention on DB2 resources.
CA RC/Extract for DB2 for z/OS (RCX) is using an ISOLEVEL option that we do not want.
Because of this we are having performance problems while using Online as well as Batch mode. How do we set the required ISOLEVEL in RCX?
Release: R19, R20
To Change the Isolation level:
At the Process Source Definition(option X) when the "Extract Method" is "S", place a "Y" in the 'Update Extended Options' field.
On the "SQL Extract Options" screen see the option "Isolation Level".
The choices are CS, UR, RS and RR.
Isolation level ==> CS (CS-Cursor Stability,UR-Uncommitted Read,
RS-Read Stability,RR-Repeatable Read)
Set this field to CS or whatever you require.
Use the SAVE command on this screen to save your options to your own ISPF profile.
If run in batch or Online you can see the Isolation Level parm listed between the .DATA and the .ENDDATA lines:
EXTOBJ DDNAME(PTIXOBJ) +