Subject | Re: mass inserts |
---|---|
Author | sboyd_kanservu_ca |
Post date | 2002-04-09T20:25:24Z |
Ann;
Is isc_tpb_no_auto_undo an IB6 feature? I can't find it documented
for IB5.
Is isc_tpb_no_auto_undo an IB6 feature? I can't find it documented
for IB5.
--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> At 10:47 AM 4/9/2002 -0700, Reggie White wrote:
> >What does the isc_tpb_no_auto_undo flag really do?
> >Does it mean that the database will not have a automatic rollback
in case of
> >a problem?
>
> Rollback will work fine, but in the old fashioned way -
> leaving record versions in the database, marked with the
> id of a transaction that failed. As an optimization, someone
> added the ability for a transaction to do its own rollback,
> which involves keeping a list of changed records. If the
> transaction is told to rollback, it backs out its own changes
> rather than waiting for someone else to stumble over them
> and clean them up. The old way still works - has to because
> not all rollbacks are intentional.
>
>
> GBAK, for example, uses isc_tpb_no_auto_undo when restoring
> databases.
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.