PH40464: A QUERY MAY FAIL WITH SQLCODE -904, MSG "ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE."

APAR status

• Closed as documentation error.

Error description

• After upgrading to accelerator maintenance level 7.5.6, a query
  may fail with the following symptom strings:
  - DSNU1188I 242 DSNUGSQL - SQLCODE = -904, ERROR: UNSUCCESSFUL
    EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E7000E,
    TYPE OF RESOURCE 00001080, AND RESOURCE NAME 437:Performance
    of this complex query might be sub-o(ptimal...)"
  - DSNU1198I 242 DSNUGSQL - SQLSTATE = 57011 SQLSTATE RETURN CODE
  - DSNU1195I 242 DSNUGSQL - SQLERRP = IBM DB2 Analytics
    Accelerator (dashDB) SQL PROCEDURE DETECTING
  
  Additional keywords:
  TS006661413 SQLCODE904 SQLCODE0437W
  GH...customer-cases/251
  

Local fix

• The issue will be fixed with accelerator maintenance level 7.5.7
  
  
  A hotfix is available for maintenance level 7.5.6.
  

Problem summary

• Problem Summary:
  After upgrade to maintenance level 7.5.6, a query can fail with
  SQLCODE -904 accompanied by message "ERROR: UNSUCCESSFUL
  EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE". Affected are
  queries where the analysis of the Db2wh optimizer returns
  SQLCODE 437W together with reason code 4.
  
  Users Affected
  Customers having upgraded to Accelerator maintenance level
  7.5.6.
  
  Problem Scenario:
  See Problem Summary above.
  
  Problem Symptoms:
  See Problem Summary above.
  

Problem conclusion

• The issue has been fixed with accelerator maintenance level
  7.5.7.
  
  Upgrade your Accelerator environment(s) accordingly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels