|
View previous topic :: View next topic
|
| Author |
Message |
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
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 |
|
 |
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
please provide the JCL and job output log.
Gerry |
|
| Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005
Posts: 459
Location: Belgium
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| 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  |
|
| Back to top |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
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 |
|
|
PeD
Active User
Joined: 26 Nov 2005
Posts: 459
Location: Belgium
|
|
|
|
| As I said ... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
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 |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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  |
|
| Back to top |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
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 |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi amal,
I believe i misunderstood your last post  - 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
d |
|
| Back to top |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
Hi Gerry,
The job is working fine. Thanks for your reply.
|
|
| Back to top |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006
Posts: 21
Location: delhi
|
|
|
|
Hi Dick,
Thanks for showing interest on this topic.The job is running fine |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
You're welcome - my pleasure
d |
|
| Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005
Posts: 459
Location: Belgium
|
|
|
|
mmmhh welcome too  |
|
| Back to top |
|
|
|
|
