Re: CPYFRMQRYF error MCH2601 #cfochkr Lock enforcement rules broken when trying to access object CMISPROD

On 10/15/2014 5:07 PM, Stone, Joel wrote:

A job has run successfully for a long time and received the MCH2601 error last night.

It was a simple OPNQRYF followed by CPYFRMQRYF command. No custom programming or APIs were involved.

Any idea what went wrong and how to avoid recurrence of this error?


V5r4



Message . . . . : 7100 - OPNQRYF FILE((JRNFLB4AF *FIRST *ONLY))
QRYSLT('JOOBJ *eq ''APPLSHIP ''') OPNID(JRN1FILE)
CPC4001 Completion 00 14/10/14 19:55:38.912496 QQQOPNQF QSYS 0365 ETJ031 PPGMLIB 0043
Message . . . . : Member JRNFL file JRNFLB4AF in PDATALIB opened.
Cause . . . . . : The file was opened with either the Open Data Base File
(OPNDBF) command or the Open Query File (OPNQRYF) command, and the value
JRN1FILE was specified for the OPNID parameter.
*NONE Command 14/10/14 19:55:38.912584 QCADRV QSYS 03C4 ETJ031 PPGMLIB 0047
Message . . . . : 7400 - CPYFRMQRYF FROMOPNID(JRN1FILE)
TOFILE(QTEMP/JRNFL) CRTFILE(*YES)
MCH2601 Escape 40 14/10/14 19:55:38.942608 #cfochkr 000B10 QDBCRTFI QSYS *STMT
To module . . . . . . . . . : QDBCRTFI
To procedure . . . . . . . : GRT_AUTH
Statement . . . . . . . . . : 16954
Message . . . . : Lock enforcement rules broken when trying to access object
CMISPROD.
CPF2883 Diagnostic 40 14/10/14 19:55:39.070240 QCPCREAT QSYS 0082 ETJ031 PPGMLIB 0047
Message . . . . : Error creating file JRNFL in library QTEMP.
Cause . . . . . : An error occurred while creating the to-file. Recovery .

There are PTFs for 6.1 and 7.1 which mention MCH2601 in the case where
the authority list is locked by another job. Is that the situation
here? If not, perhaps there is another PTF that will address this.

http://www-912.ibm.com/a_dir/as4ptf.nsf/9939a36675eadb978625710200584cbd/$searchForm?SearchView


I searched with 'msgmch2601 f/#cfochkr t/QDBCRTFI' in V5R4 PTF Cover
Letters and found a bunch of hits, although IBM Support have a better
search engine in my opinion.