RC/Extract : SHRLEVEL Use for SQL Extract in RC/Extract

Products

• RC/Extract for DB2 for z/OS

Issue/Introduction

Is the SHRLEVEL parm on the RC/EXTRACT JCL control card ignored for an SQL type extract?

 

Environment

Release: R20
Component: RCX

Resolution

Yes. It is only used if Fast Unload is used to extract the data.

On the RC/EXTRACT SQL Extract Options these options can be seen. The SHRLEVEL parm is not there.

--------------- RC/EXTRACT SQL Extract Options -------------- yyyy/mm/dd hh:mm
Command ===>

Advanced Options:
  Keys mode        ==> 1  (0-private, 1-1 dataspace, 2-n dataspaces)
  Dup elimination  ==> U  (N-None, X-Sort only, S-System only, U - User RI)

Extract Options:
  Isolation level  ==> RR  (CS-Cursor Stability,UR-Uncommitted Read,
                            RS-Read Stability,RR-Repeatable Read)

It can be seen on the Fast Unload Extraction Options....

--------------- RC/Extract PFU Extract Options -------------- yyyy/mm/dd hh:mm
Command ===>

Extract Options:
  Share level     ==> C  (C - Change, I - Ignore, R - Reference)
  Use Image Copy  ==> Y  (Y-Yes, P-Parts, T-Template, N-No)

Advanced Options:
  Keys mode       ==> 1  (0-private, 1-1 dataspace, 2-n dataspaces)
  Split extract   ==> N  (N-No, Y-Yes, U-Update default allocations)
  Dup elimination ==> U  (N-None, X-Sort only, S-System only, U-User RI)
  Unit count      ==> 01 (01-59) This value is used when Split extract=Y