PH10309: HAAM044W OCCURS WHEN VIEW/UPDATE OF EXCEPTION PROFILE FROM JOB PROFILE DUE TO LIKE_BLANK_INSIGNIFICANT PARM IN DB2 SSID.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HAAM044W appears when attempting to view/update an exception
  profile via a job profile and the LIKE_BLANK_INSIGNIFICANT
  parm is set in the Db2 SSID.
  This can happen if the user has LIKE_BLANK_INSIGNIFICANT
  turned on (required in SAP-Systems, see SAP-NOTE 2239553).
  This setting impacts how fixed-length character strings are
  matched in a LIKE predicate.
  Basically, when LIKE_BLANK_INSIGNIFICANT is set, the
  fixed-length character column is STRIPPED of trailing blanks
  prior to evaluation. However, blanks in the LIKE predicate
  ARE significant.
  Since the user has LIKE_BLANK_INSIGNIFICANT set, and Db2
  Automation Tool's SQL statement in DLC#IOPF is
  PROFILE_CREATOR LIKE :creator, a value of 'ABC' is being
  compared to 'ABC_bbbbb_'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Automation Tool for z/OS        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HAAM044W appears when attempting to     *
  *                      view/update an exception profile via a  *
  *                      job profile and the                     *
  *                      LIKE_BLANK_INSIGNIFICANT parm is set in *
  *                      the Db2 SSID.                           *
  *                      This can happen if the user has         *
  *                      LIKE_BLANK_INSIGNIFICANT turned on      *
  *                      (required in SAP-Systems,               *
  *                      see SAP-NOTE 2239553).                  *
  *                      This setting impacts how fixed-length   *
  *                      character strings are matched in a      *
  *                      LIKE predicate.                         *
  *                      Basically, when                         *
  *                      LIKE_BLANK_INSIGNIFICANT is set, the    *
  *                      fixed-length character column is        *
  *                      STRIPPED of trailing blanks prior to    *
  *                      evaluation. However, blanks in the LIKE *
  *                      predicate ARE significant.              *
  *                      Since the user has                      *
  *                      LIKE_BLANK_INSIGNIFICANT set, and Db2   *
  *                      Automation Tool's SQL statement in      *
  *                      DLC#IOPF is PROFILE_CREATOR LIKE:       *
  *                      reator, a value of 'ABC' is being       *
  *                      compared to 'ABC_bbbbb_'.               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Code has been changed to fix this problem.
  

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:

Modules/Macros

• HAA#ACTR HAA#IOPF HAA$BULJ
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI63119

     UP19/05/22 P F905

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.