Subject Re: mass inserts
Author sboyd_kanservu_ca

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
> We have answers.