syssqexplain table and error 264...
Hello IDS gurus,
Everytime I try to run queries against syssqexplain table, I've got error 264
-- I know I have lots of temp dbspaces. I tried setting PSORT_DBTEMP to a big
directory, it also failed me. Does anyone have any experience with this?
Example:
select avg(sqx_estcost), count(*) num, sqx_sqlstatement
from syssqexplain
group by 3
order by 1 desc;
264: Could not write to a temporary file.
131: ISAM error: no free disk space
I've found that ANY query against syssqexplain can impact performance
noticeably. Even at 'dirty read'.
Wonder if it's getting into a recursive loop?
Bob Roussey
Unix / Informix Administration
Spirit Airlines
Robert.Roussey@SpiritAir.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Kern Doe
Sent: Friday, February 16, 2007 4:10 PM
To: ids@iiug.org
Subject: syssqexplain table and error 264... [8422]
Hello IDS gurus,
Everytime I try to run queries against syssqexplain table, I've got
error 264
-- I know I have lots of temp dbspaces. I tried setting PSORT_DBTEMP to
a big
directory, it also failed me. Does anyone have any experience with this?
Example:
select avg(sqx_estcost), count(*) num, sqx_sqlstatement
from syssqexplain
group by 3
order by 1 desc;
264: Could not write to a temporary file.
131: ISAM error: no free disk space
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.