PH28293: WHEN RUNNING A LOAD USING STORED PROCEDURE ACCEL_LOAD_TABLES THE LOAD REQUEST MAY HANG IN DB2 WAREHOUSE.

APAR status

• Closed as documentation error.

Error description

• When running a load using stored procedure ACCEL_LOAD_TABLES
  the load request may hang in Db2 warehouse.
  
  The isssue affects all maintenance levels of IBM DB2 Analytics
  Accelerator for z/OS 7.5 up to level 7.5.2.2. The issue will be
  fixed with maintenance level 7.5.3 by incorporation of new Db2wh
  engine 11.5.4.
  
  For IBM support:
  To diagnose that a load hang is a duplicate of the issue
  mentioned here use the following command during the hang
  situation:
  db2fodc -hang full -member all
  The Db2wh call stack shows the following:
  
  0x00001000000939F4 recv + 0x00a4
  0x00001000047AA444
  _Z12sqlcctcptestP17SQLCC_COMHANDLE_TP12SQLCC_COND_T + 0x0304
  0x00001000047A08EC
  _Z9sqlcctestP17SQLCC_COMHANDLE_TP12SQLCC_COND_T + 0x022c
  0x000010000C2B2CCC _ZN8sqeAgent19AgentBreathingPointEi + 0x06ec
  0x000010000CE15E1C
  _Z8sqlkqrcvP8SQLKQ_CBP8sqeAgentPiPP10sqkfBufferS3_PN7ibm_cde5que
  ry16RuntimeStatEntryES3_Pb + 0x15fc
  
  Additional keywords:
  TS003562468, TS003547877, GH#3862
  wsdbu01440768, wsdbu01441000
  fixed in DB2/db2#2402
  GH.../DB2/tracker/issues/3862
  

Local fix

• IBM service engineer: db2set DB2CHECKCLIENTINTERVAL=0
  

Problem summary

• The underlying issue in the database engine (Db2wh) of the
  accelerator has been fixed. The fix is part of the new version
  11.5.4.0 of Db2wh being delivered with accelerator maintenance
  level 7.5.3.
  

Problem conclusion

• Upgrade your accelerator maintenance level to 7.5.3 or higher.
  

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