Logical log for Temp table
falco...@gmail.com
be logged in logical log. However, will any logical operation on
temporary table be logged too in logical log. I ask this question as
it is non sense to log logical operation for temp table as it will not
be recovered when recovery is required.
Thanks for any reply.
bozon
It depends. If you create the temporary table with logging then it
will log if you create it without logging it won't
Here are the two syntax types:
create temp table(
....
) with no log;
create temp table(
) ;
select * from <table> into temp <temp table> with no log;
select * from <table> into temp <temp table> ;
Madison Pruet
If the temp table is not created "without logging", then it will be
logged. The reason is that rollbacks on the temp table can not be
performed unless the temp table is logged.
>
> Thanks for any reply.
Fernando Nunes
Besides the answers you already got, it's worth mentioning that IDS 11 (maybe
late 10.x versions?) introduced a global parameter called TEMPTAB_NOLOG which
can be used to disable temp table logging.
This can have serious impacts on your applications, so be careful if you want
to use it.
Doc:
Regards,
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
Jack Parker
non-logging tables. Pre-creation and sizing of a temp table can help
performance quite a bit.
cheers
j.
"He's right. No one can deny the results of No Child Left Behind, because
thanks to the program, no one has any basic reasoning skills." -- The Onion
>
> Thanks for any reply.
_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
jpre...@yahoo.com
> It should be noted that extent allocation is always logged - even for
> non-logging tables. Pre-creation and sizing of a temp table can help
> performance quite a bit.
>
> cheers
> j.
>
> "He's right. No one can deny the results of No Child Left Behind, because
> thanks to the program, no one has any basic reasoning skills." -- The Onion
>
>
Actually temp tables created in dbspaces flagged and created as
"temp" (used the -t flag in onspaces) don't even log extent allocation
because at initialization time the entire dbspaces structure (chunk
free list page, tblspace tblspace, etc...) is recreated as if the
dbspace had just been added.
Jacques
Jack Parker
correct. Is this new behaviour?
cheers
j.
-----Original Message-----
From: informix-l...@iiug.org
[mailto:informix-l...@iiug.org]On Behalf Of jpre...@yahoo.com
Sent: Wednesday, January 30, 2008 10:06 AM
To: inform...@iiug.org
Subject: Re: Logical log for Temp table
Jacques
jpre...@yahoo.com
> Finally got a chance to test this out (10.00.TC5I1). Indeed you are
> correct. Is this new behaviour?
>
> cheers
> j.
>
> -----Original Message-----
>
> [mailto:informix-list-boun...@iiug.org]On Behalf Of jpren...@yahoo.com
> Sent: Wednesday, January 30, 2008 10:06 AM
> Subject: Re: Logical log for Temp table
>
> On Jan 29, 7:29 pm, "Jack Parker" <jack.park...@verizon.net> wrote:
> > It should be noted that extent allocation is always logged - even for
> > non-logging tables. Pre-creation and sizing of a temp table can help
> > performance quite a bit.
>
> > cheers
> > j.
>
> > "He's right. No one can deny the results of No Child Left Behind, because
> > thanks to the program, no one has any basic reasoning skills." -- The
> Onion
>
> Actually temp tables created in dbspaces flagged and created as
> "temp" (used the -t flag in onspaces) don't even log extent allocation
> because at initialization time the entire dbspaces structure (chunk
> free list page, tblspace tblspace, etc...) is recreated as if the
> dbspace had just been added.
>
> Jacques
> _______________________________________________
> Informix-list mailing list
I don't recall when this was added actually but I believe it's been
this way awhile. I went back and tested a 7.31.UD7 and it also behaves
that way.
Jacques