Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

MAXTEMPS keyword - Syntax needed.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rskumar

New User


Joined: 21 Nov 2005
Posts: 35
Location: chennai

PostPosted: Tue Apr 20, 2010 8:13 pm    Post subject: MAXTEMPS keyword - Syntax needed.
Reply with quote

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
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Apr 20, 2010 8:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Tue Apr 20, 2010 8:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Apr 20, 2010 8:52 pm    Post subject:
Reply with quote

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
View user's profile Send private message
rskumar

New User


Joined: 21 Nov 2005
Posts: 35
Location: chennai

PostPosted: Tue Apr 20, 2010 9:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm
No new posts Syntax to check the first 4 digits of... kshirabdhi DFSORT/ICETOOL 10 Tue May 03, 2016 12:21 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us