I'm pretty new to DB2 (just recently passed the 700 exam - WUL) but have
some questions regarding explicit table locking.

I have about 20 years experience as an R:Base DBA and developer and in
that environment it is possible to lock a table to prevent all other users
from having access and then unlocking the table when done. R:Base is
always in an Autocommit "On" state, but that doesn't prohibit one from
locking and unlocking tables.

In DB2 it seems that the default Autocommit "On" seems to mean that as
soon as you have run the "Lock Table tablename in exclusive mode" the
locked tables automatically are unlocked.

I have already done an extensive amount of VB6 DB2 programming relying on
Autocommit being "On" so I'd hate to have to rewrite all my code to
explicitly Commit every transaction.

So, in this environment, is there any way to lock and unlock tables the
way I used to in R:Base?

Tony

==============================
Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY 11706

http://www.computeryltd.com

DB2 & UDB email list listserv db2-l LazyDBA home page