RE: explicit TEMP table in rootdbs?
Darren,
Make sure the temp tables are created without logging. i.e.
CREATE TEMP TABLE <tabname>
(
column list...
) WITH NO LOG;
HTH.
David Buchholz
Senior Database Administrator
Vital Processing Services
david.buchholz@vitalps.com
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of
Darren_Jacobs@carmax.com
Sent: Tuesday, March 15, 2005 07:08
To: ids@iiug.org; informix-list@iiug.org
Subject: explicit TEMP table in rootdbs?
All,
I'm having a problem with an explicit TEMP table being created in my
rootdbs. I have 6 temp dbspaces created at 1 gig each. My entry for
dbspace temp in my onconfig file is below.
create TEMP table <tabname>
(
column list ....
);
Any help would be greatly appreciated.
$ onstat -c|grep TEMP
# DBSPACETEMP:# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
DBSPACETEMP temp1:temp2:temp3:temp4:temp5:temp6 # Default temp dbspaces
sending to informix-list
sending to informix-list
David Buchholz wrote:
> Darren,
>
> Make sure the temp tables are created without logging. i.e.
>
> CREATE TEMP TABLE <tabname>
> (
> column list...
> ) WITH NO LOG;
>
> HTH.
>
> David Buchholz
> Senior Database Administrator
> Vital Processing Services
> david.buchholz@vitalps.com
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of
> Darren_Jacobs@carmax.com
> Sent: Tuesday, March 15, 2005 07:08
> To: ids@iiug.org; informix-list@iiug.org
> Subject: explicit TEMP table in rootdbs?
>
>
> All,
>
> I'm having a problem with an explicit TEMP table being created in my
> rootdbs. I have 6 temp dbspaces created at 1 gig each. My entry for
> dbspace temp in my onconfig file is below.
>
> create TEMP table <tabname>
> (
> column list ....
> );
>
> Any help would be greatly appreciated.
>
> $ onstat -c|grep TEMP
> # DBSPACETEMP:> # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
> DBSPACETEMP temp1:temp2:temp3:temp4:temp5:temp6 # Default temp dbspaces
>
> sending to informix-list
>
>
> sending to informix-list
If you want to control where a logged temp table is created then have a
logged dbspace in your DBSPACETEMP $ONCONFIG or environment variable
along with non-logged (i.e. real temp dbspaces) dbspaces.
--
"I have enough problems remembering my opinions, let alone justifying them."
"Sorry, I thought you tapped me."