Fast Unload jobs returning PUT0037E Restart Table access error - SQL Error Code: -100 via Utility-ID

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

Running Fast Unload for Db2 for z/OS (PFU) 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

Resolution

Solution; running multiple Database Management utilities using the same Utility ID is the cause of the problem.  

Remove this syntax from the Fast Unload JCL: 

//UNLD0001 EXEC PGM=PTLDRIVM,REGION=6M,                 
//          PARM='EP=UTLGLCTL/ssid,,,xxxxxxxx.yyyyyyyy' 

to look like:

//UNLD0001 EXEC=PGM=PTLDRIVM,PARM='EP=UTLGLCTL/ssid'


OR

Code unique Utility IDs for each Utility will resolve the problem.