PH71206: HALOAD JOB CANCELED BY THE HEALTH MONITOR COMPLETES WITH RC=4 INSTEAD OF THE EXPECTED RC=8.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The HALOAD job is canceled by the health monitor when no load
  activity is detected within the configured timeout period.
  Although the job encounters a load timeout condition due to no
  load activity detected and ACCEL_LOAD_TABLES is canceled, the
  job incorrectly completes with a return code RC=4 instead of the
  expected RC=8.
  
  When this issue occurs, the job issues messages indicating
  inactivity timeout, cancellation of the ACCEL_LOAD_TABLES stored
  procedure, abnormal termination, and rollback of accelerator
  table changes. Query acceleration is also disabled for the
  affected accelerator tables. However, despite these error
  conditions, the job ends with RC=4 rather than signaling failure
  with RC=8.
  
  Job generates the following messages and ends with RC=4:
  
  HLOU5931I No load activity detected. Timeout expired seconds.
  Timeout remaining 0 seconds
  HLOU5935E ACCEL_LOAD_TABLES on accelerator canceled by .........
  Reason code 3
  HLOU5738I ACCEL_LOAD_TABLES stored procedure ended on , RC=0007
  HLOU5720I DSNT408I SQLCODE = -430, ERROR: PROCEDURE
  SYSPROC.ACCEL_LOAD_TABLES (SPECIFIC
  
  HLOU5720I NAME SYSPROC.ACCEL_LOAD_TABLES) HAS ABNORMALLY
  TERMINATED
  
  HLOU5720I DSNT418I SQLSTATE = 38503 SQLSTATE RETURN CODE
  
  HLOU5929E ACCEL_LOAD_TABLES was terminated due error or
  inactivity. Accelerator table changes are ROLLED BACK.
  
  HLOU4024W Disabling query acceleration for tables loaded on
  accelerator .
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  HALOAD job canceled by the health monitor completes with
  RC=4 instead of the expected RC=8.
  

Problem conclusion

• HALOAD job canceled by the health monitor completes with
  RC=4 instead of the expected RC=8.
  

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:

Modules/Macros

• HLO#VERS HLO#WRIT HLOCLBK1 HLOCLBK2 HLOMSGEN HLOPIPE  HLOPIPEA
  HLOPIPEG HLOPOSRV HLOPSTPR HLORBKU1 HLORDELD HLORERD  HLORUSQL
  HLOSINIT HLOSTCMD HLOSUSQL HLOUBKU1 HLOUCBAS HLOUCE15 HLOUDELD
  HLOUGACG HLOUHAL1 HLOUHLTP HLOUHMON HLOUHTMG HLOUMAIN HLOUNTOK
  HLOUSE35 HLOUTMGR HLOUUMON
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R310 PSY UO08311

     UP26/06/20 I 1000

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.