SHRLEVEL Use for SQL Extract in RC/Extract

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

Description:

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

Solution:

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

An alternative when the SQL type extract is desired is to bind the RCX1xxxx plan with ISOLATION set to 'UR' to utilize "dirty reads".