How to set ISOLEVEL in RC/Extract?

Document ID : KB000014464
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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.

Question:

CA RC/Extract for DB2 for z/OS (RCX) is using an ISOLEVEL option that we do not want.

ie, ISOLEVEL(RR)

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?

Answer:

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.

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:
ISOLEVEL(CS)

Additional Information: