PH59766: SQLCODE -803 AND INZU592I MESSAGE WHEN INSERTING DATA IN SYSOBJEVENTS HISTORY TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• From function level Db2 V13 FL504, if history by object is
  enabled (VUU100/ENBHIST set to DETAIL or AS_DB2_ZPARM and Db2
  customization is set to OBJECT), HPU encounters an SQL error
  (SQLCODE -803) when several SELECT of not determined object are
  processed by SQL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: From function level Db2 V13 FL504, if   *
  *                      history by object is enabled            *
  *                      (VUU100/ENBHIST set to DETAIL or        *
  *                      AS_DB2_ZPARM and Db2 customization      *
  *                      is set to OBJECT), HPU encounters an    *
  *                      SQL error (SQLCODE -803) when several   *
  *                      SELECT of not determined object are     *
  *                      processed by SQL.                       *
  *                                                              *
  *                      Technical explanation :                 *
  *                      The sql error is encountered because 2  *
  *                      indexes are defined on the              *
  *                      SYSIBM.SYSOBJEVENTS table on the        *
  *                      following columns:                      *
  *                                                              *
  *                      EVENTID, DBID, PSID, PARTITION          *
  *                                                              *
  *                      EVENTID DBNAME SPACENAME PARTITION      *
  *                                                              *
  *                      Technical solution:                     *
  *                      When the object is undetermined:        *
  *                      DBID = unload number in negative form   *
  *                      PSID = select number in negative form   *
  *                      DBNAME = UNLnnn (nnn = unload number)   *
  *                      SPACENAME = SELnnn                      *
  *                      (nnn = select number)                   *
  *                                                              *
  *                      Identified symptoms:                    *
  *                      INZI193E DB2 ERROR: FROM CLI   :        *
  *                      SQLCODE -803 - SQLSTATE 23505           *
  *                      INZI193E DB2 ERROR: FROM CLI   :        *
  *                      {DB2 FOR OS/390}{ODBC DRIVER}{DSN13015} *
  *                      DSNT408I SQLCODE = -803, ERROR:         *
  *                      AN INSERTED OR UPDATED VALUE IS INVA    *
  *                      BECAUSE INDEX IN INDEX SPACE DSNOEH01   *
  *                      CONSTRAINS COLUMNS OF                   *
  *                      SO NO TWO ROWS CAN CONTAIN DUPLICATE    *
  *                      VALUES IN THOSE COLUMNS                 *
  *                      RID OF EXISTING ROW IS X'000000D69E'.   *
  *                                                              *
  *                      and message                             *
  *                                                              *
  *                      INZU592I ERROR DURING UTILITY HISTORY   *
  *                      COLLECTION, SQL ERROR PREVENTED TO      *
  *                      INSERT INTO SYSIBM.SYSOBJEVENTS.        *
  *                      UTILITY HISTORY COLLECTION FOR THIS     *
  *                      STEP IS SWITCHED OFF                    *
  *                                                              *
  *                      Workaround:                             *
  *                      No workaround.                          *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  SQLCODE -803 and INZU592I message when inserting data in
  SYSOBJEVENTS history table.
  

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:

  UI96298

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UI96298

     UP24/03/30 P F403

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.