massive # of temp tables: 7.1

Posted in 1995

Joe Lumbley — Thu, 12 Oct 1995 02:31:43 GMT — source: Informix-list mailing list archive (1991-1998)

Folks, A while back someone reported a problem with a DSA system, and I seem to have lost the answer....of course, I just developed the same problem. System is 7.10.UC1. In a long select, with a complex order by clause, we get a "cannot write to table" type of error. online.log shows tablespace overflow....obviously from temp tables, lots of them. Someone posted the same problem and someone (Cathy Kipp maybe?> posted a very non-obvious fix. Anyone remember the situation? TIA Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) Dallas, Texas ----------------------------------------------------------------------------