How to release locks when cursor is closed?

Article View: ibm.software.db2.mvs

Article #3

Back to ibm.software.db2.mvs Previous Next

From: Andreas Lederer
Date: Mon, 02 Dec 2002 15:38

26 lines
1845 bytes

Hallo!

Ich have a cli/odbc application which selects some
rows from user tables with
SQLExecDirect - SQLFetch
and then uses SQLFreeStmt(hstmt,SQL_CLOSE) to close the
cursor.
The problem is, that the select produces some locks on
system tables but the locks are only released when the
transaction is closed with SQLEndTran.

I have tried to use the SQLSetStmtAttr SQL_ATTR_CLOSE_BEHAVIOR
to set to SQL_CC_RELEASE but i got an error from the odbc driver
about not supported option.

How can I force the release of the db-locks without ending the
transaction???

My environment:
Client: Windows NT workstation with db2 connect V7.1 with FP7 (WR21311)
Database: DB2 V6.1.1 OS/390

I use Cursor Stability as isolation level!

Thanks,
Andreas Lederer

Technical Details

Message-ID: <3deb7e93$1@e-post.inode.at>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!newsfeed01.univie.ac.at!e-post.inode.at!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da59,31523e5b5847d4c0,start
X-Google-Attributes: gid10da59,public
X-Google-Thread: f675e,31523e5b5847d4c0,start
X-Google-Attributes: gidf675e,public
X-Google-ArrivalTime: 2002-12-02 07:39:03 PST
Date: Mon, 02 Dec 2002 16:38:58 +0100
From: Andreas Lederer <Andreas.Lederer@tecco.at>
Reply-To:  Andreas.Lederer@tecco.at
User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.1) Gecko/20020826
X-Accept-Language: German/Austria, de-AU, en
MIME-Version: 1.0
Newsgroups: ibm.software.db2.mvs,bit.listserv.db2-l
Subject: How to release locks when cursor is closed?
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.99.185.90
Message-ID: <3deb7e93$1@e-post.inode.at>
X-Trace: e-post.inode.at 1038843539 62.99.185.90 (2 Dec 2002 16:38:59 +0100)
Lines: 27
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!newsfeed01.univie.ac.at!e-post.inode.at!not-for-mail