Article View: net.database
Article #61Re: IBM DB2 lacks record locking
From: Darryl Olson
Date: Wed, 06 Nov 1985 15:26
Date: Wed, 06 Nov 1985 15:26
11 lines
1167 bytes
1167 bytes
In article <1621@utah-gr.UUCP> peter@utah-gr.UUCP (Peter S. Ford) writes: >> ... It is not surprising to me that IBM DB2 opted for an implicit >> locking scheme. DB2 supports both an implicit and an explicit locking scheme. The explicit locking capabilities include the SQL statement LOCK TABLE, the isolation level option of the BIND command, and the tablespace "lockable unit" parameter. Darryl Olson uw-beaver!teltone!dataio!olson
Technical Details
Message-ID:
<855@dataioDataio.UUCP>Path:
arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!mhuxr!mhuxt!houxm!vax135!cornell!uw-beaver!uw-june!entropy!dataio!olsonReferences:
<2953@sun.uucp> <1621@utah-gr.UUCP>Show Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Posting-Version: version B 2.10.2 9/18/84; site dataioDataio.UUCP Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!mhuxr!mhuxt!houxm!vax135!cornell!uw-beaver!uw-june!entropy!dataio!olson From: olson@dataioDataio.UUCP (Darryl Olson) Newsgroups: net.database Subject: Re: IBM DB2 lacks record locking Message-ID: <855@dataioDataio.UUCP> Date: Wed, 6-Nov-85 10:26:05 EST Article-I.D.: dataioDa.855 Posted: Wed Nov 6 10:26:05 1985 Date-Received: Thu, 7-Nov-85 06:45:31 EST References: <2953@sun.uucp> <1621@utah-gr.UUCP> Reply-To: olson@dataio.UUCP (Darryl Olson) Distribution: net Organization: Design Automation Products, Data I/O, Redmond, WA Lines: 11