PH60809: A QUERY TERMINATES ABNORMALLY WITH SQLCODE -901 (REASON "UNEXPECTED ERROR AT JOINSPILLINFO:CPP4342". SQLSTATE=58004).

APAR status

• Closed as documentation error.

Error description

• A query terminates abnormally with SQLCODE -901 accompanied by
  the following error information:
  "The SQL statement or command failed because of a database
  system error.
  (Reason "unexpected error at JoinSpillinfo:CPP4342".)
  SQLSTATE=58004."
  
  The origin of issue is in the database engine incorporated by
  the Accelerator.
  It is covered by Known issue DT270401 having got the title
  "Db2 11.5.8. CDE query fails with AssertionFailedException
  Thrown at JoinSpillInfo.cpp : 4342".
  
  A new edition of the Db2wh engine with the corresponding
  fix is planned to be incorporated in Accelerator
  maintenance level 7.5.13.
  
  Additional keywords:
  TS01496034 DT270401 DT378634 query SQLCODE901 SQLSTATE58004
  database system error #idaa7513
  GH/.../Customer-Cases/issues/679
  
  Additional information for IBM support:
  The logs unveil the following database issue:
  AssertionFailedException: An assertion '(isSuccess &&
  procParts.get(partId) &&
  (mJoinHashTableInfo->getHashTable(partId) != __null)) ||
  (!isSuccess && !procParts.get(partId) && failIfNoMemory)'
  failed. Additional info: loadPart: loaded part not flagged:
  agentId: 2 gjpId: 2 partId: 0 isSuccess: 1
  Thrown at JoinSpillInfo.cpp : 4342
  

Local fix

Problem summary

• Problem Summary:
  See APAR Error description.
  
  Users Affected:
  User of accelerated queries
  
  Problem Scenario:
  See APAR Error description.
  
  Problem Symptoms:
  See APAR Error description.
  

Problem conclusion

• The fix for the underlying Db2wh issue is part of the Db2wh
  engine "11.5.9.0 (Build special 42753)" that has been
  incorporated in Accelerator maintenance level 7.5.13.
  
  Upgrade your Acelerator 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