Re: explicit TEMP table in rootdbs?
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