Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
vsi
- Premium Member
- Posts: 507
- Joined: Wed Mar 15, 2006 1:44 pm
Post
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??
-
kumar_s
- Charter Member
- Posts: 5245
- Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s »
Is it SPU or CPU?
Which database? Where are you firing this query?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
meena
- Participant
- Posts: 430
- Joined: Tue Sep 13, 2005 12:17 pm
Post
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??
-
vsi
- Premium Member
- Posts: 507
- Joined: Wed Mar 15, 2006 1:44 pm
Post
by vsi »
Its SPU. Its any query which used to work usually?
-
prabu
- Participant
- Posts: 146
- Joined: Fri Oct 22, 2004 9:12 am
Post
by prabu »
misleading topic of this millenium
:shock:
-
DSguru2B
- Charter Member
- Posts: 6854
- Joined: Wed Feb 09, 2005 3:44 pm
- Location: Houston, TX
Post
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.