A fix is available
APAR status
Closed as program error.
Error description
The IVP unload (INZIVP in HPU 4.1 and prior releases and INZCHECK template in HPU 4.2) fails if the setting specifies ULLOCK = YES. The following messages are issued SQLCODE = -607, ERROR: OPERATION OR OPTION LOCK IS NOT DEFINED FOR THIS OBJECT SQLSTATE = 42832 SQLSTATE RETURN CODE SQLERRP = DSNXI15 SQL PROCEDURE DETECTING ERROR SQLERRD = 25 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION SQLERRD = X'00000019' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATIO ERROR WHEN TRYING TO OBTAIN A SHARED LOCK ON TABLE : "SYSIBM ".SYSDATABASE UTILITY RETURN CODE 8 (REASON CODE 0x2ea005) PB11809 SQLCODE607 SYSDATABASE
Local fix
Or add the LOCK NO option to the IVP unload statements as follows: UNLOAD TABLESPACE DB2 NO LOCK NO SELECT * FROM SYSIBM.SYSDATABASE OUTDDN SYSREC1 FORMAT DSNTIAUL ASIS OUTMAXROWS 1 and UNLOAD TABLESPACE DB2 FORCE LOCK NO SELECT * FROM SYSIBM.SYSDATABASE OUTDDN SYSREC1 FORMAT DSNTIAUL ASIS OUTMAXROWS 1
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: The IVP unload (INZIVP in HPU 4.1 and * * prior releases and INZCHECK template * * in HPU 4.2) fails if the setting * * specifies ULLOCK = YES. * * The following message are issued * * SQLCODE = -607, ERROR: OPERATION OR * * OPTION LOCK IS NOT DEFINED FOR * * THIS OBJECT * * SQLSTATE = 42832 SQLSTATE RETURN * * CODE * * SQLERRP = DSNXI15 SQL PROCEDURE * * DETECTING ERROR * * SQLERRD = 25 0 0 -1 0 0 SQL * * DIAGNOSTIC INFORMATION * * SQLERRD = X'00000019' X'00000000' * * X'00000000' X'FFFFFFFF' * * X'00000000' X'00000000' SQL * * DIAGNOSTIC INFORMATIO * * ERROR WHEN TRYING TO OBTAIN A SHARED * * LOCK ON TABLE : "SYSIBM ".SYSDATABASE * * UTILITY RETURN CODE 8 (REASON CODE * * 0x2ea005) * * pb 11809 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzsivp member was fixed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM81245
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-01-23
Closed date
2013-05-07
Last modified date
2013-06-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZCHECK INZSIVP
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"4.2.0"}]
Document Information
Modified date:
30 March 2021