Re: DB locks after closed select-handles

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.