search cancel

SQLCODE = -607 when attempting to edit e.g. SYSIBM.LULIST

book

Article ID: 32031

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS

Issue/Introduction

Symptoms: 

SQL-607 when trying to edit a catalog table.

SQLCODE = -607, ERROR:  OPERATION OR OPTION LOCK IS NOT 
DEFINED FOR THIS OBJECT  

  

Environment:  

DB2 – all releases

 

Cause: 

The SQLCODE = -607 has most often been seen when editing with Update Method = P (positional) and the field 'Lock Table for Edit' field set to Y.

 

Resolution:

Overwrite ‘Update Method’ and set it to S or D.

Both fields are shown on the ‘RC/Edit Options’ panel.

 

<Please see attached file for image>

rcedit options2.BMP

Additional Information:

You can change the default value by issuing command ‘PROFILE’ then select option 3 -  RC/Edit Profile Variables.

The ‘'Lock Table for Edit' field is defined in member RCEDIT in the highlvl.CDBAPARM library.

 

The default values can also be set in member DEFAULTS in the CDBAPARM library. 
Refer to the ‘CA DB2 DB Management Common Functions’ manual,  Using Cross Product Features/Global Defaults, for details 

 

Environment

Release:
Component: RCU

Attachments

1558699045221000032031_sktwi1f5rjvs16oie.bmp get_app