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
 

 

How to overwrite the allocated sort space in SAS?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Sat May 17, 2008 2:40 am    Post subject: How to overwrite the allocated sort space in SAS?
Reply with quote

Hi,
I'm having a SAS jcl which is using a very big sized dataset. The problem is my jcl is ending with B37 abend. But my allocation of space for primary is 4200 CYLS and 4200 CYLS for secondary. I don't know how to increase the size more than this.

Note: In the program, it is doing some sort operations, the sort space I allocated is 4200 CYLS. Please help me in this.
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Sat May 17, 2008 3:32 am    Post subject:
Reply with quote

Hi,
please provide the JCL and job output log.



Gerry
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Sat May 17, 2008 4:06 am    Post subject:
Reply with quote

First, use OPTIONS COMPRESS=YES;

Second, play with multiple volumes thru UNIT=(SYSDA,nn) avoiding a too big secondary allocation.


Cheers

Pierre
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sat May 17, 2008 12:31 pm    Post subject:
Reply with quote

gcicchet wrote:
Hi,
please provide the JCL and job output log.
Gerry

Because without this information we have no idea of what you are trying to do, where in the SAS code the abend occurs, of what your settings are.

Psycics rule OK icon_biggrin.gif
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Sun May 18, 2008 5:13 am    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

Hi,
the problemis not with the jcl space allocation. It is with the sort space allocation. how to increase the sort space in SAS?
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Sun May 18, 2008 5:32 am    Post subject:
Reply with quote

As I said ...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 18, 2008 7:18 am    Post subject:
Reply with quote

Hello,

Quote:
the problemis not with the jcl space allocation. It is with the sort space allocation
Why would you believe that the sort space is not a "jcl space allocation"?

If you have a problem and someone suggests a solution, the way to proceed is to try the suggestion and reply whether it worked or if there is still a problem. Once you have tried the suggestions, let us know the outcome.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Sun May 18, 2008 1:44 pm    Post subject:
Reply with quote

Hi Amal,

why is it so difficult to provide the JCL and job output, you seem to know what the problem is but yet you are unable to fix it and yet you want people here to assist in fixing your problem, I feel like saying "fix it yourself", well I just did.

Gerry
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Sun May 18, 2008 9:30 pm    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

Hi Dick,
Thanks for your reply. This sort space is called as WRK space in SAS. to specify the work space we are using WORK='primary quantity,2ndry quand' parameter.
. Well, I will fix this problem and will post the outcome. i can't post my spool messages because of security policy of my client.

Thanks
Amal
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 19, 2008 2:19 am    Post subject:
Reply with quote

Hello Amal,

Quote:
i can't post my spool messages because of security policy of my client
If you replace the info pertaining to the client you can. . . People do this all of the time. If those who know SAS well (i'm not one of them) cannot see what you see, they cannot help so much.

Quote:
First, use OPTIONS COMPRESS=YES;
I'd suggest you incorporate this into your test as well.

Someone will be here when you post the results. Good luck icon_smile.gif
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Thu May 29, 2008 8:03 am    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

Despite of allocating the space in single volume I have allocated the work space to span on multiple volume. in SAS we have to give the work parameter as mentioned below
//STEP01 EXEC SAS
// WORK='4200,4200',UNIT=(SYSDA,10).
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 29, 2008 8:19 am    Post subject:
Reply with quote

Hello,

What you have posted pretty well shows us nothing. You have merely mentioned the value you gave for a symbolic parameter.

You need to show how this is resolved when the proc is expanded .

You also need to post the diagnostic information.

And yes, you can replace anything proiprietary with something generic as long as what you post reflects the actual run. It means you will probably need to put more effort into it, but without it, we cannot help.
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Thu May 29, 2008 8:36 am    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

Hi Dick,
While expanding the jcl it allocates 10 work spaces with each SPACE=(CYL,(4200,4200,RLSE) in 10 diffrent volumes. So now the JCL is having enough work space to process the datasets. Please let me know if you have any questions.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu May 29, 2008 8:50 am    Post subject:
Reply with quote

Hi Amil,
is the job working or failing ?

If the job fails can you post the joblog. like what's it failing with.


Gerry
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 29, 2008 9:20 am    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

Hi amal,

I believe i misunderstood your last post icon_confused.gif - i thought you were telling us that with the change, there was still a problem.

Sounds like all is well now - good to hear it is working. Thank you for letting us know icon_smile.gif

d
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Thu May 29, 2008 9:28 am    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

Hi Gerry,
The job is working fine. Thanks for your reply.
icon_biggrin.gif
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Thu May 29, 2008 9:29 am    Post subject:
Reply with quote

Hi Dick,
Thanks for showing interest on this topic.The job is running fine icon_biggrin.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 29, 2008 9:39 am    Post subject: Reply to: How to overwrite the allocated sort space in SAS?
Reply with quote

You're welcome - my pleasure icon_smile.gif

d
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Thu May 29, 2008 11:00 am    Post subject:
Reply with quote

mmmhh welcome too icon_lol.gif
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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