Fast Unload SQL-905 Db2 Resource Limit Exceeded RLF

Products

• Fast Unload for DB2 for z/OS
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Executing Fast Unload for Db2 for z/OS (PFU) and encountering SQL-905 error indicating Resource Limit exceeded:

DSNT408I SQLCODE = -905, ERROR:  UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT

         BEING EXCEEDED, RESOURCE NAME = ASUTIME LIMIT = 000000000000 CPU    

         SECONDS (000000000000 SERVICE UNITS) DERIVED FROM SYSIBM.DSNRLST01

DSNT418I SQLSTATE   = 57014 SQLSTATE RETURN CODE                             

DSNT415I SQLERRP    = DSNXEDP SQL PROCEDURE DETECTING ERROR                  

DSNT416I SQLERRD    = -361  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION        

DSNT416I SQLERRD    = X'FFFFFE97'  X'00000000'  X'00000000'  X'FFFFFFFF'     

The Db2 Resource Limit Facility (RLF) was recently implemented.

Environment

Release: r20

Component: CA Fast Unload for Db2 for z/OS (PFU)

Resolution

Modify the RLF table SYSIBM.DSNRLST01 to exclude the Fast Unload utility.

The RLFCOLLN column can be utilized to specify package collections. 

For Fast Unload the following package collections are utilized:

DGL1Rxxx_PUT_PFU

PASMRxxx_PAS

Please refer to the PLANSxx member utilized in hlq.CDBAPARM for the PASPLN01= and DGLPLN01= entries

to complete the RLFCOLLN information.