Executing Fast Unload where SQL Access unload method is being used to process SELECT statement and job fails with SQL-904 00C90084 RESOURCE 100 NAME DSNDB07.
Article ID: 40167
Updated On:
Products
Issue/Introduction
Executing Fast Unload for DB2 for z/OS (PFU) with SQL-ACCESS EXTENSION keyword for a large WHERE statement with
many IN criteria and JOIN processing which is using SQL Access method to unload from the table.
The job is failing with the following:
PFU0261I - TASK #01 -- MESSAGE DDNAME: PTIMSG01 -- MAX RC: 008 INCLUDES
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000100, AND
RESOURCE NAME DSNDB07
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRSOR SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -115 13172746 0 13231826 -959250432 14090279 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF8D' X'00C9000A' X'00000000' X'00C9E6D2'
X'C6D30000' X'00D70027' SQL DIAGNOSTIC INFORMATION
Cause
Insufficient DB2 DSNDB07 work space to complete the SELECT statement passed to DB2 for dynamic processing.
Resolution
One possible solution would be to specify CURRENT-DEGREE 1 in the PFU syntax and rerun the unload job.
The permanent solution would be to increase the available DB2 DSNDB07 work space.
Feedback
