Re: RBSBIG

[George Jansen <GJANSEN@AFLCIO.ORG>]

Paul,

What I was trying to illustrate was that

a. SET TRANSACTION USE ROLLBACK SEGMENT is effective within SQR
b. It is good for one transaction only: do  a commit (or rollback, or
issue some DDL), and the new transaction will probably bring a new
rollback segment.

Sorry if this wasn't clear. It doesn't have to be the same
begin-sql/end-sql paragraph; executing another procedure will affect it
only there's a commit or rollback (possibly implicit or auto).

George

>>> phoyte@SHARIDIONNE.COM 07/10/02 03:42PM >>>
George:

I would suggest executing the insert/update commands within the same
begin-sql paragraph or set the transaction to use the rbsbig EACH time
just before you execute the insert but within the same begin-sql
paragraph.  Transactions can be assigned different RBSegments so to
hold
the one that you want you have to use it right away with the sql
paragraph.  Executing another procedure will create the possibility to
lose the assigned segment.

HTH

Paul Hoyte
Sharidionne Inc.
(248) 559-6868
Email: phoyte@sharidionne.com