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
Darren,
you may need to say you want to create the temp WITH NO LOG.
TEMP dbspaces are not logged so if you don;t specify that you don;t
want logging on your temp table IDS will assume you do.
Regards
johnd
Darren_Jac...@carmax.com wrote:
> 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
I'm not positive, but I think you need commas between the dbspace names, not
":".
<Darren_Jacobs@carmax.com> wrote in message
news:1110903083.b833eb8aa70a42e88fb9a4879f7f871a@teranews...
>
> 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