PH69744: OBJECT-LEVEL HISTORY COLLECTION UNDULY DISABLED IF DB2 SQL STRING DELIMITER SET TO QUOTATION MARK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Although requested, the object-level utility history collection
  feature is unduly disabled for the irrelevant reason reported by
  the following message:
  INZU592I ERROR DURING UTILITY HISTORY COLLECTION, TABLE
  SYSIBM.SYSOBJEVENTS DOES NOT EXIST, UTILITY HISTORY COLLECTION
  FOR THIS STEP IS ALTERED : ONLY SYSIBM.SYSUTILITIES TABLE
  POPULATED.
  
  This occurs if all the following conditions are fulfilled:
  
  - The history collection at object-level feature is available,
    i.e.
         - the Db2 subsystem/data sharing group is at version V13
           or later
         - the SYSIBM.SYSOBJEVENTS table exists
  - The object-level history collection is enabled in one of the
    following two ways
         - the VUU100/ENBHIST parmlib parameter is set to DETAIL
         - the VUU100/ENBHIST parmlib parameter is set to
         AS_DB2_ZPARM and the Db2 settings specify OBJECT for the
         UTILITY_HISTORY parameter
  - The Db2 settings specify the quotation mark as a SQL STRING
    DELIMITER (SQLDELI) which is reported by the field "SQL STRING
    DELIMITER QUOTE"  from the Db2 HPU message INZU020I
  
  Note: As mentioned by the INZU592I the utility-level history
  collection is enabled despite the issue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Although requested, the object-level    *
  *                      utility history collection feature is   *
  *                      unduly disabled for the irrelevant      *
  *                      reason reported by the following        *
  *                      message:                                *
  *                      INZU592I ERROR DURING UTILITY HISTORY   *
  *                      COLLECTION, TABLE SYSIBM.SYSOBJEVENTS   *
  *                      DOES NOT EXIST, UTILITY HISTORY         *
  *                      COLLECTION FOR THIS STEP IS ALTERED :   *
  *                      ONLY SYSIBM.SYSUTILITIES TABLE          *
  *                      POPULATED.                              *
  *                                                              *
  *                      This occurs if all the following        *
  *                      conditions are fulfilled:               *
  *                                                              *
  *                      - The history collection at             *
  *                        object-level feature is available,    *
  *                        i.e.                                  *
  *                             - the Db2 subsystem/data sharing *
  *                               group is at version V13 or     *
  *                               later                          *
  *                             - the SYSIBM.SYSOBJEVENTS table  *
  *                               exists                         *
  *                      - The object-level history collection   *
  *                        is enabled in one of the following    *
  *                        two ways                              *
  *                             - the VUU100/ENBHIST parmlib     *
  *                               parameter is set to DETAIL     *
  *                             - the VUU100/ENBHIST parmlib     *
  *                               parameter is set to            *
  *                               AS_DB2_ZPARM and the Db2       *
  *                               settings specify OBJECT for    *
  *                               the UTILITY_HISTORY parameter  *
  *                      - The Db2 settings specify the          *
  *                        quotation mark as a SQL STRING        *
  *                        DELIMITER (SQLDELI) which is reported *
  *                        by the field "SQL STRING DELIMITER    *
  *                        QUOTE"  from the Db2 HPU message      *
  *                        INZU020I                              *
  *                                                              *
  *                      Note: As mentioned by the INZU592I the  *
  *                      utility-level history collection is     *
  *                      enabled despite the issue.              *
  *                                                              *
  *                      Local fix: none                         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Object-level history collection unduly disabled if Db2 SQL
  STRING DELIMITER set to quotation mark
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO06602

     UP26/01/30 P F601

• R610 PSY UO06604

     UP26/01/30 P F601

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.