On Tue, Oct 28, 2014 at 02:20:52PM +0000, Knal Astrfisson wrote: > Hi, > > The problem: database locks are left behind after the statement > handles of simple select statements are closed, e.g. $sth->finish; > and undef $sth; when I fetch BLOB fields from DB2 using AutoCommit=0.
I'd guess that the locks are being held by the transaction that was implicitly started by the select statement. Read the DB2 docs on Transaction Isolation. Tim.