PI17581: HAAB524E ERROR WHEN MULTIPLE LOB COLUMNS EXIST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a base table has multiple LOB columns with auxiliary
  tablespaces created using DEFINE NO, a HAAB524E (LOB validation
  failed) error can occur during an Automation Tool build job.
  The error occurs when some of the VSAM datasets associated with
  the auxiliary tablespaces have been created and others have not.
  This would occur when some of the LOB columns have had insert
  activity and others have had no insert activity.
  

Local fix

• Turn off the LOB dependency check or set 'Exclude objects that
  failed Dependency check' to N to produce warning only.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a base table has multiple LOB      *
  *                      columns with auxiliary tablespaces      *
  *                      created using DEFINE NO, a HAAB524E     *
  *                      (LOB validation failed) error can       *
  *                      occur during an Automation Tool build   *
  *                      job. The error occurs when some of the  *
  *                      VSAM datasets associated with the       *
  *                      auxiliary tablespaces have been         *
  *                      created and others have not.            *
  *                      This would occur when some of the LOB   *
  *                      columns have had insert activity and    *
  *                      others have had no insert activity.     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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:

  UI19750

Modules/Macros

• HAA$BMSG HAA#LDEP HAA#UTED
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R410 PSY UI19750

     UP14/07/23 P F407

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.