Executing CA 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.

book

Article ID: 40167

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Problem:

Executing CA 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. 

Environment

Release:
Component: PFU