Re: SQL0901: "SQL system error" and MCH2601: "Lock enforcement rules broken when trying to access object &1" -- RPG400-L

Subject: Re: SQL0901: "SQL system error" and MCH2601: "Lock enforcement rules broken when trying to access object &1"
From: Dan <dan27649@xxxxxxxxx>
Date: Tue, 23 Mar 2010 18:08:19 -0400
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the IBM i / System i <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

Carsten, thanks for posting the link. We're not using stored procedures,
and our program starts off with an explicit EXEC SQL SET OPTION COMMIT =
*NONE.

Paul, I'm very much inclined to agree with your suggestion that this is an
OS bug. I've forwarded the appropriate information to the folks who handle
sys admin in our company, as this is out of my area of responsibility.

Thanks!
- Dan

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.