ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA RC/Extract for DB2 for Z/OS : How to set ISOLEVEL in RC/Extract?


Article ID: 14464


Updated On:


RC/Extract for DB2 for z/OS


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
Component: RCX


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.

Extract Options:
  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)                                                +
        DSN(source.definition.dataset)                                 +
        UNIT(SYSDA,01)                                                 +
        LRECL(4078)                                                    +
        SPACE(500,200,CYL)                                             +
        DISP(CATLG)                                                    +
        MGMTCLAS(mgmtclass)                                               +

Additional Information

How to Specify SQL Extraction Options