Subject Re: [IBO] AllowCheckOAT
Author Jason Wharton
No, I thought I had explained this better but I see it is lacking.

Attempt means it will begin trying things in an attempt to make it so that
the transaction can be released. In this case the only thing it can and will
do is work on dataset cursors that have not reached eof yet. As long as a
cursor is open the transaction handle must remain in place to preserve it.
So, IBO begins sneaking records into the buffer on windows idle CPU
messages. Once it hits EOF for all open cursors the transaction handle will
be released automatically.

There is a ceiling on this so that it will only fetch up to a certain amount
of records and then it won't try any more. Otherwise, if someone wasn't
careful this could lead to eating up all your client's memory.

That is also what the other items are for. Prompt and Force. This gives you
the ability to have IBO perform more drastic measures in order to ensure
that a transaction isn't going to be open too long and hold up the OAT.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: <guido.klapperich@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, February 13, 2001 3:43 PM
Subject: Re: [IBO] AllowCheckOAT


> Sorry, I have printed the OH and read every word many times, but I don't
see the
> difference.
> AllowCheckOAT: This property determines the amount of time in seconds IBO
will
> wait before it will physically end a transaction that is no longer needed
by the
> system.
> Attemp: This is the point in time when IBO will begin to attempt to close
the
> transaction if at all possible.
>
> Obviously, I'm too stupid, but for me, it seems to be equal.
>
>
> Guido
>
> Jason Wharton wrote:
>
> > See the help file plz. It's all in there under TIB_Timeout or something
like
> > that.
> >
> > Back to wrk.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> > ----- Original Message -----
> > From: <guido.klapperich@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Tuesday, February 13, 2001 2:14 PM
> > Subject: Re: [IBO] AllowCheckOAT
> >
> > > So, what is the difference between CheckAllowOAT and Attempt. Both are
the
> > > time, when IBO tries to end the transaction.
> > >
> > >
> > > Guido.
> > >
> > > Jason Wharton wrote:
> > >
> > > > Every transaction takes care of its own OAT. never does it have
anything
> > to
> > > > do with another transaction's OAT.
> > > >
> > > > Jason Wharton
> > > > CPS - Mesa AZ
> > > > http://www.ibobjects.com
> > > >
> > > > ----- Original Message -----
> > > > From: <guido.klapperich@...>
> > > > To: "ibobjects@egroups.com" <IBObjects@yahoogroups.com>
> > > > Sent: Tuesday, February 13, 2001 2:01 PM
> > > > Subject: [IBO] AllowCheckOAT
> > > >
> > > > > Is the AllowCheckOAT-Property only valid for the transaction it is
> > > > > defined, or is it valid for all transactions. For example, I have
20
> > > > > ib_transactions and all have a different AllowCheckOAT-Values.
> > > > > 1) From all transactions will the shortest AllowCheckOAT-time be
taken
> > > > > and after that time, IBO will try to end all transactions, that
were
> > no
> > > > > longer needed by the system. Or
> > > > > 2) Every transaction will check its own CheckAllowOAT-time and try
to
> > > > > end the transaction.
> > > > >
> > > > >
> > > > > Thank you in advance.
> > > > >
> > > > > Guido
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>