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 number
PH28293
Reported component name
ANYTCS ACCLTR Z
Reported component ID
5697DA700
Reported release
750
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-07
Closed date
2020-12-02
Last modified date
2020-12-02
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
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"750"}]
Document Information
Modified date:
03 December 2020