PK70875: FAST APPLY SQL MAY SHUT DOWN WITH A USER ABEND: MESSAGE "IN HPCB CONTROL BLOCK, THE EYE CATCHER IS DAMAGED"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Sometimes, date columns, time columns, timestamp columns, and
  mixed character columns can put the Fast Apply SQL into an
  unstable state. When in this state, FAS may have a user abend
  and a message indicating the eye catcher of an HPCB control
  block is damaged. Whether the unstable state causes the abend is
  unpredictable and depends largelyon the user's environment.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Log Analysis Tool.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Sometimes, date columns, time columns,  *
  *                      timestamp columns, and mixed character  *
  *                      columns can put the Fast Apply SQL into *
  *                      an unstable state.  When in this state, *
  *                      FAS may have a user abend and a message *
  *                      indicating the eye catcher of an HPCP   *
  *                      control block is damaged.  Whether the  *
  *                      unstable state causes the abend is      *
  *                      unpredictable and depends largely on    *
  *                      the user's environment.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address these issues.
  

Problem conclusion

• Apply the PTF.
  

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:

  UK40541 UK40542

Modules/Macros

•    ALA@FSP  ALA@MNT  ALAAA1   ALAA53   ALAFRA
  ALAFRTV  ALAFRTVV ALAFR1   ALAFR1A  ALAFR1AV ALAFR1C  ALAFR1CV
  ALAFR1D  ALAFR1F  ALAFR1G  ALAFR1GV ALAFR1I  ALAFR1IV ALAFR1L
  ALAFR1LV ALAFR1M  ALAFR1MV ALAFR1PV ALAFR1Q  ALAFR1QV ALAFR1V
  ALAFR1X  ALAFR1XV ALAFR12  ALAFR2   ALAFR2M  ALAFR2V  ALAFR3
  ALAFR6   ALAFR6A  ALAFR6I  ALAFR64  ALAFR7   ALAFR8   ALAFR8A
  ALAFR9   ALAGEN1  ALAISPMN ALAMDTL  ALASLOG  ALASUBG  ALAURC
  ALAZH010
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK40541

     UP08/10/23 P F810 Ž

• R310 PSY UK40542

     UP08/10/23 P F810 Ž

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.