HP3000-L Archives

November 2003, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: transaction rollback, row-level locking, checkpoint
From:
Gavin Scott <[log in to unmask]>
Reply To:
Gavin Scott <[log in to unmask]>
Date:
Thu, 13 Nov 2003 08:47:51 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (15 lines) 
Eben writes:
> Another question, however.  If DBXBEGIN is called and the
> program crashes
> without DBXUNDO or DBXEND being called, what is the impact on the
> database?  Does it automatically result in a rollback, a commit, or
> something halfway in-between?

It rolls back.  If the program does not explicitly commit the
transaction then it will be rolled back no matter what.

G.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2