Re: 7.23 doesn't use tempdbs

I think your problem is that you need to use "with no log" when you create temp table, if you don't, informix will create temp table in rootdbs. At 12:11 PM 2/10/98 +0000, davin_harvey@dsti.co.uk wrote: > Hi, > > I have Online 7.23.UC6 running on AIX 4.2, with over 1/2 Gb available > in my tempdbs. DBSPACETEMP is set to tempdbs in the onconfig file, > and is not set in my environment. However, any temp table created, > implicitly or explicitly, goes into my rootdbs, which has only 40Mb > free. Any ideas anyone? > > TIA > Davin > >********************************************************************** >DST International Tel:+44 181 390 5000 www.dstinternational.co.uk > >This message and any attachments to it is intended only for the >individual or company to which it is addressed and may contain >information which is privileged, confidential or prohibited from >disclosure or unauthorised use. If the recipient of this >transmission is not the intended recipient, or the employee or agent >responsible for delivering such materials to the intended recipient, >you are hereby notified that any use, any form of reproduction, >dissemination, copying, disclosure, modification, distribution and/or >publication of this e-mail message or its attachments other than by >its intended recipient is strictly prohibited by the sender. > >If you have received it in error, please notify us immediately by >telephone on the number above and destroy the message and all copies >in your possession. >********************************************************************** > > Paul Hsu SKECHERS USA 228 Manhattan Beach Blvd Manhanttan Beach, CA 90266 Phone : (310) 3183100 X 1287 Fax : (310) 3185019 E-mail: paulh@skechers.com