PH51789: AFTER A HALOAD COMPLETES, IF THE ACCEL_LOAD_TABLES SP FAILS OR DOES NOT END CAUSES THE LOAD JOB TO HANG.

APAR status

• Closed as program error.

Error description

• The following changes are made with this APAR,
  1. On a HALOAD job after the load is completed, and if the
  ACCEL_LOAD_TABLES stored procedure fails or does not end causes
  the load job to hang. The health monitor stops monitoring the
  job when the load is completed. The HALOAD health monitor is
  modified to check and cancel the ACCEL_LOAD_TABLES stored
  procedure if they do not end in the provided HALOAD Monitor
  Timeout, even after the load is completed. This will result in
  the job to fail with an error and rollback the load to avoid
  hang.
  
  2. On a HALOAD if the stored proc does not make progress and if
  the HALOAD_MONITOR_SLEEP is greater than HALOAD_MONITOR_TIMEOUT
  then the HALOAD health monitor wont cancel the job and can
  result in the HALOAD job to hang.
  
  3. When HALOAD_MONITOR_SLEEP is set to 0 from HALOAD utility
  syntax, this does not override the started task sleep time.
  
  4. On a HALOAD, set the UTILID to 'DIAGNOSE_948' on unload
  authorization check.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: On a HALOAD job after the load is       *
  *                      completed, and if the                   *
  *                      ACCEL_LOAD_TABLES stored procedure      *
  *                      fails or does not end causes the load   *
  *                      job to hang.                            *
  ****************************************************************
  The following changes are made with this APAR,
  1. On a HALOAD job after the load is completed, and if the
  ACCEL_LOAD_TABLES stored procedure fails or does not end causes
  the load job to hang. The health monitor stops monitoring the
  job when the load is completed. The HALOAD health monitor is
  modified to check and cancel the ACCEL_LOAD_TABLES stored
  procedure if they do not end in the provided HALOAD Monitor
  Timeout, even after the load is completed. This will result
  in the job to fail with an error and rollback the load to
  avoid hang.
  
  2. On a HALOAD if the stored proc does not make progress
  and if the HALOAD_MONITOR_SLEEP is greater than
  HALOAD_MONITOR_TIMEOUT then the HALOAD health monitor wont
  cancel the job and can result in the HALOAD job to hang.
  
  3. When HALOAD_MONITOR_SLEEP is set to 0 from HALOAD utility
  syntax, this does not override the started task sleep time.
  
  4. On a HALOAD, set the UTILID to 'DIAGNOSE_948' on
  unload authorization check.
  

Problem conclusion

Temporary fix

Comments

• ×**** PE23/05/10 FIX IN ERROR. SEE APAR PH54453  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI90783

Modules/Macros

• HLOADDTB HLOMSGEN HLOPIPE  HLOSINIT HLOSPLCY HLOUHAL1 HLOUHMON
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI90783

     UP23/03/05 P F303