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