A fix is available
APAR status
Closed as program error.
Error description
(HPU 5.2 only) The history collection is unduly disabled as reported by the following INZU592I message INZU592I ERROR DURING UTILITY HISTORY COLLECTION, SQL ERROR PREVENTED TO INSERT INTO SYSIBM.SYSOBJEVENTS. UTILITY HISTORY COLLECTION FOR THIS STEP IS SWITCHED OFF issued after the following message reporting the root cause as in the example below 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 INVALID BECAUSE INDEX IN INDEX SPACE DSNOEH01 CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'00000AAC06'. DSNT418I SQLSTATE = 23505 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRINS SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -110 13172739 0 13817814 -490143744 0 SQL D INFORMATION DSNT416I SQLERRD = X'FFFFFF92' X'00C90003' X'00000000' X'00D2D7D X'E2C90000' X'00000000' SQL DIAGNOSTIC INFORMATION ERRLOC=5:10:2 INZI193E DB2 ERROR: FROM SQLCA : SQLSTATE : 23505 SQLCODE : -803 INZI193E DB2 ERROR: FROM SQLCA : DSNXRINS INZI193E DB2 ERROR: FROM SQLCA : DSNOEH01 00000AAC06 This occurs when all the following conditions are fulfilled: - the unload is processed in SQL mode - the SQLPART option is specified - an output dataset (OUTDDN or UNLDDN) per partition is requested - the history collection feature is enable at the object level, i.e. either VUU100/ENBHIST is set to DETAIL or VUU100/ENBHIST is set to AS_DB2_ZPARM and the Db2 UTILITY_HISTORY subsystem parameter is set to OBJECT
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 High Performance Unload for * * z/OS * **************************************************************** * PROBLEM DESCRIPTION: (HPU 5.2 only) * * The history collection is unduly * * disabled as reported by the following * * INZU592I message * * INZU592I ERROR DURING UTILITY * * HISTORY COLLECTION, SQL ERROR * * PREVENTED TO INSERT INTO * * SYSIBM.SYSOBJEVENTS. * * UTILITY HISTORY COLLECTION FOR THIS * * STEP IS SWITCHED OFF * * issued after the following message * * reporting the root cause as in the * * example below * * 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 * * INVALID BECAUSE INDEX IN INDEX * * SPACE DSNOEH01 CONSTRAINS COLUMNS * * OF THE TABLE SO NO TWO ROWS CAN * * CONTAIN DUPLICATE VALUES IN THOSE * * COLUMNS. * * RID OF EXISTING ROW IS * * X'00000AAC06'. * * DSNT418I SQLSTATE = 23505 SQLSTATE * * RETURN CODE * * DSNT415I SQLERRP = DSNXRINS SQL * * PROCEDURE DETECTING ERROR * * DSNT416I SQLERRD = -110 13172739 0 * * 13817814 -490143744 0 SQL D * * INFORMATION * * DSNT416I SQLERRD = X'FFFFFF92' * * X'00C90003' X'00000000' X'00D2D7D * * X'E2C90000' X'00000000' SQL * * DIAGNOSTIC INFORMATION * * ERRLOC=5:10:2 * * INZI193E DB2 ERROR: FROM SQLCA : * * SQLSTATE : 23505 SQLCODE : -803 * * INZI193E DB2 ERROR: FROM SQLCA : * * DSNXRINS * * INZI193E DB2 ERROR: FROM SQLCA : * * DSNOEH01 00000AAC06 * * * * This occurs when all the following * * conditions are fulfilled : * * - the unload is processed in SQL mode * * - the SQLPART option is specified * * - an output dataset (OUTDDN or UNLDDN) * * per partition is requested * * - the history collection feature is * * enable at the object level, i.e. * * either VUU100/ENBHIST is set to * * DETAIL or VUU100/ENBHIST is set to * * AS_DB2_ZPARM and the Db2 * * UTILITY_HISTORY subsystem parameter * * is set to OBJECT * * * * Local fix: none. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** INZI193E reporting SQLCODE-803 and subsequent lack of utility history collection for an unload in SQL mode with SQLPART option and unload at partition level
Problem conclusion
Code has been changed to fix this problem
Temporary fix
Comments
APAR Information
APAR number
PH61487
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-05-23
Closed date
2024-07-01
Last modified date
2024-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZ$$CCQ INZ$$PRM INZMQRY INZPARM INZTDSC INZTOOLS INZTVAR INZUTIB1 INZUTIB2 INZUTILC INZUTILD INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R520 PSY UI97541
UP24/07/03 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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"520","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2024