PH71201: HALOAD JOB MAY HANG ON PARTITIONED TABLES, CAUSING THE HEALTH MONITOR TO TIME OUT WITH NO LOAD ACTIVITY DETECTED AND CANCEL IT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The HALOAD job may hang when loading a partitioned object. In
  this scenario, the HALOAD job waits indefinitely for one or more
  partitions to complete during the postload phase. Because the
  load activity never completes, the health monitor detects a
  condition of no load activity detected and allows its timer to
  fully expire. When the countdown completes, the health monitor
  issues messages and cancels the HALOAD job.
  
  The following messages may be issued when the health monitor
  timeout expires:
  HLOU5931I <day of year> <time> No load activity detected.
  Timeout expired nn seconds. Timeout remaining 0     seconds
  
  HLOU4004I <day of year> <time> Task: 01, Load completed for
  table: <table name>, partition: xx
  After the job is canceled by health monitor, the following
  messages may also be generated:
  
  HLOU5935E <day of year> <time> ACCEL_LOAD_TABLES on accelerator
  <accelerator>   canceled by ........  Reason code nn
  
  HLOU5738I <day of year> <time> ACCEL_LOAD_TABLES stored
  procedure ended on <accelerator>, RC=0007
  Note: The value of Reason Code 'nn' may be 2 or 3
  
  
  As a result of the health monitor canceling the HALOAD job, the
  job output may also include additional messages indicating that
  internal subtasks were terminated and that the ACCEL_LOAD_TABLES
  stored procedure ended. The following messages may appear after
  the cancellation:
  HLOU5022E <day of year> <time> Subtask HLOUHLTP terminated
  unexpectedly. SYS=0000, USR=000C
  HLOU5022E <day of year> <time> Subtask HLOUHTMG terminated
  unexpectedly. SYS=0000, USR=000C
  HLOU5064I <day of year> <time> WLM ASIDS: <wlm asid>
  HLOU5738I <day of year> <time> ACCEL_LOAD_TABLES stored
  procedure ended on <accelerator>, RC=0014
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  HALOAD job may hang on partitioned tables, causing the
  health monitor to time out with no load activity detected
  and cancel the job
  

Problem conclusion

• HALOAD job may hang on partitioned tables, causing the
  health monitor to time out with no load activity detected
  and cancel the job
  

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:

  UO08311

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.