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

book

Article ID: 14464

calendar_today

Updated On:

Products

CA RC/Extract for DB2 for z/OS

Issue/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.

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?

Environment

Release: R19, R20
Component: RCX

Resolution

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

.DATA
 REGISTRY(ssid)
 SRCDEF(source.definition)
 EXTOBJ DDNAME(PTIXOBJ)                                                +
        DSN(source.definition.dataset)                                 +
        UNIT(SYSDA,01)                                                 +
        LRECL(4078)                                                    +
        SPACE(500,200,CYL)                                             +
        DISP(CATLG)                                                    +
        MGMTCLAS(mgmtclass)                                               +
        STORCLAS(storeclass)
 OVFLOW UNIT(SYSDA)
 OPTIMIZE(YES)
 DDL(NO)
 INTERCEPTERRORS(YES)
 REPORT(Y,2000)
 KEYSMODE(0)
 ACCESSMETHOD(SQL)
 DUPELIMINATION(U)
 SPLIT(NO)
 IMAGECOPY(NO)
  ISOLEVEL(CS)
 SHRLEVEL(REFERENCE)
 RESTART(NO)
 SORTALLOC(SYSDA,1)
.ENDDATA

Additional Information

How to Specify SQL Extraction Options