FastUnload Jobs returning PUT0037E Restart Table access error - SQL Error Code: -100 Via Utility-ID

book

Article ID: 209580

calendar_today

Updated On:

Products

CA Fast Unload for DB2 for z/OS

Issue/Introduction

Running Fast Unload with a Utility ID the job fails with:  

 DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH, UPDATE, OR
          DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE
 DSNT418I SQLSTATE   = 02000 SQLSTATE RETURN CODE
 DSNT415I SQLERRP    = DSNXRSDL SQL PROCEDURE DETECTING ERROR
 DSNT416I SQLERRD    = -160  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
 DSNT416I SQLERRD    = X'FFFFFF60'  X'00000000'  X'00000000'
          X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
          INFORMATION
PUT0037E - Restart Table access error - SQL Error Code: -100
           Internal Function Code: 1D1
PUT0610E - RESTART TABLE Delete STMT Rec Error; RC = 008 , RSN = 090
PUT0136I - Primary restart rows deleted

Environment

Release : 20.0

Component : CA Fast Unload for DB2 for z/OS

Resolution

Solution; running multiple CA Utilities using the same Utility ID is the cause of the problem.  

Remove this syntax from the Fast Unload JCL: 

//UNLD0101 EXEC PGM=PTLDRIVM,REGION=6M,                 
//          PARM='EP=UTLGLCTL/DCP2,,,CSSUNLD1.UNLD0001' 

to look like; //UNLD0101 EXEC=PGM=PTLDRIVM,PARM='EP=UTLGLCTL/DCP2'

Or code Unique Utility IDs for each CA Utility, that will resolve the problem.