At 04:17 PM 10/28/2002 +0100, Ignacio J. Ortega wrote:

> > From: Ann W. Harrison
> >
> > Hmmm... gbak deadlock. There was a bug fix in restore.e -
> > ... I have no idea why gbak is using two
> > transactions ... that seems like a recipe for disaster.
>
>Yes, but in any case you need to commit from phase to phase, because
>most of the work is done in DFW..

Actually not so often as you might think because DFW can see
all the work done in the transaction being committed. So,
for example, you can create domains, use them in table definitions,
and use the tables in view definitions without intermediate
commits.

Of course that doesn't work across different transactions. If
you define your domains in one transaction and try to define
tables in a concurrent transaction, you get chopped meat, on
a good day.




Ann
www.ibphoenix.com
We have answers.