PH71951: HAAB074E ERROR (VSAM NOT FOUND) CAN OCCUR WHEN DISJOINTED PART LIST IS RETURNED FROM A WILD-CARDED DB.TS LIST USING ADVANCED SQL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A job build can result in error message HAAB074E (VSAM not
  found) when an object profile contains a wild-carded DB name, TS
  name or IX name, specifies PART=ALL, and uses Advanced SQL to
  return a subset of partitions of an individual DB2 object.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A job build can result in error message *
  *                      HAAB074E (VSAM not found) when an       *
  *                      object profile contains a wild-carded   *
  *                      DB name, TS name or IX name, specifies  *
  *                      PART=ALL, and uses Advanced SQL to      *
  *                      return a subset of partitions of an     *
  *                      individual DB2 object.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

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:

  UO08501

Modules/Macros

• HAA#OBEX
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UO08501

     UP26/07/08 P F607

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.