View previous topic :: View next topic
|
Author |
Message |
rskumar
New User
Joined: 21 Nov 2005 Posts: 35 Location: chennai
|
|
|
|
Hello - One of my jobs abended with a SQLCODE=-904 with a reason code 00C90305 meaning Workfile storage limit exceeded. Also i found that the MAXTEMPS keyword has to be set with a value = 0, meaning 'NO limit' on the work file storage. Can anyone tell me where to use this keyword in my jcl? The jcl i am using is to unload a table. Let me know if any more information is needed.
P.S. I tried searching for 'MAXTEMPS' in the forum but couldnt get any results. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
MAX TEMP STG/AGENT field
Updating the parameters
well, If you are a DBA, you can change the site installation parms,
so that you can run your job.
or,
you can change your sql so that less storage is required
or,
you can supply us with - the DDL of the table
- the sql used to unload
- the requirement that lead you to your current solution
and we can make suggestions. |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
Its good to see that you searched before you asked question on the forum. However, did you try to find out why the limit was exceeded?
Assuming you are an application programmer, talk to your DBAs about changing the zparm values. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
talk to your DBAs about changing the zparm values.
|
asking the DBAs to change the parm is like pounding sand.
If you think about it, the DBAs perform unloads, backups, loads, with the parms that are in effect.
the obvious problem is that the TS has some kind of unload that exceeds the workload space
and
why I suggested that he provide info
or
he can ask his DBAs who will tell him to change his sql.
that he wanted a JOB solution (change the parm in his JOB) only shows his inexperience. |
|
Back to top |
|
|
rskumar
New User
Joined: 21 Nov 2005 Posts: 35 Location: chennai
|
|
|
|
Thanks all for your responses. a slight modification in my question. the jcl that is abending is of a cobol prog and not an unload jcl. really sorry about that.
The program extracts records based on few criteria on the table. based on your responses, i am going to unload the entire table and load it with few records only so that only little amount of data is used. seems like the table has over 30 million records and that is causing the problem. |
|
Back to top |
|
|
|