Page 1 of 1
not datastage question (SQL query)
Posted: Sat Sep 09, 2006 1:39 am
by vsi
I get an error ERROR: SPU swap partition : Disk temporary work space is full, when I make the SQL queries I get this errors.
Why am I getting this, due to any absurd query which i made. that costed lot of memory?? shoudlnt there be time out etc??
Posted: Sat Sep 09, 2006 4:47 am
by kumar_s
Is it SPU or CPU?
Which database? Where are you firing this query?
Posted: Sat Sep 09, 2006 9:58 am
by meena
Hi Vsi,
Post your SQL qyery.
Why am I getting this, due to any absurd query which i made. that costed lot of memory??
Posted: Sat Sep 09, 2006 10:23 am
by vsi
Its SPU. Its any query which used to work usually?
Posted: Sat Sep 09, 2006 11:56 am
by prabu
misleading topic of this millenium
:shock:
Posted: Sat Sep 09, 2006 1:18 pm
by DSguru2B
Database issue. You need to ask your DBA to increase the temp space. You sql query is requiring more temp space than is available.