PM81245: INZUTILB ENDS SQL CODE -607 TRYING TO OBTAIN A SHARED LOCK ON TABLE SYSIBM.SYSDATABASE

Obtain the fix for this APAR.

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 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

• R410 PSY UK94106

     UP13/05/14 P F305

• R420 PSY UK94107

     UP13/05/14 P F305

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.