MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SORT output file - space abend

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
rasprasads
Beginner


Joined: 10 Dec 2002
Posts: 59
Topics: 20
Location: Chennai

PostPosted: Fri Apr 11, 2003 4:03 am    Post subject: SORT output file - space abend Reply with quote

Hi,

In a sort step

I had an input file with following characterstics:

No of records : 12 000 000
Lrecl : 600
Recfm : VB

Output file

Lrecl : 20
Recfm : FB

The doubt is that when i specified (CYL,(10,10),RLSE) the job abended due to SB-37.

I increased the space and it reran successfully. The no. of records that was selected to output file was only 7 000 000(due to an include cond). The allocated cyls was 186.

How come the job failed at first as (10 + 10 * 15) = 250 cyls should have been alloacated.

Give your ideas on this please.....
_________________
Rasprasad S
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose

PostPosted: Fri Apr 11, 2003 5:43 am    Post subject: Reply with quote

Rasprasad,

Quote:

How come the job failed at first as (10 + 10 * 15) = 250 cyls should have been alloacated.


You only will get 160 cylinders . The space calculation is PRIMARY ALLOCATION + (SECONDAY ALLOCATION * 15)

In your case it is 10 + (10 * 15) = 10+ 150 = 160 cylinders

Since your file needed 186 cylinders, the job abended earlier.

Hope this helps...

cheers

kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rasprasads
Beginner


Joined: 10 Dec 2002
Posts: 59
Topics: 20
Location: Chennai

PostPosted: Fri Apr 11, 2003 11:09 am    Post subject: Reply with quote

Kolusu,

One more doubt. How to find no. of records in a tape dataset. I tried SORT but it takes a longer time since the file is over many number of volumes. Is there any other solution to this. Can i do it using blkcnt. If so how?

Thanks.....
_________________
Rasprasad S
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose

PostPosted: Fri Apr 11, 2003 11:48 am    Post subject: Reply with quote

Rasprasad,

If you are interested to know the no: of records in the tape file , just DUMMY out the sortout dataset. Sort products are highly optimized products. The main delay is with the MOUNT of the tapes. Some shops has virtual tapes which act just like DASD files.

I think CA-1 is a tape management utility which keeps track of no: of records and volumes.

So check with your systems programmer if you have any tape management utilities on your system.

Hope this helps....

Cheers

Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rasprasads
Beginner


Joined: 10 Dec 2002
Posts: 59
Topics: 20
Location: Chennai

PostPosted: Sat Apr 12, 2003 9:03 am    Post subject: Reply with quote

I tried to copy an input file(Lrecl=565) in tape to a DASD output file. The output dataset space was given as (CYL,(300,100),RLSE).

Lrecl=20 and no of records= 3200000.

Now space would be there for 75 000 000 records(apprx).
In any case there should not be space abend. But SB-37 occured.

Any reasons...
_________________
Rasprasad S
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose

PostPosted: Sat Apr 12, 2003 10:48 am    Post subject: Reply with quote

Rasprasad,

Just because you have defined the space=(cyl,(300,100),rlse) does not gurantee that you will get 1800 cylinders. Therotically you should get all the space. But in reality it depends on your shop dasd size. If there are no sufficient volumes to allocate the space then your job will abend with a B37 or E37. Take a look at your Job output and you will find something like

Code:

REDUCED SECONDARY SPACE FROM 100 CYLINDERS TO 21


Even though you have coded 100 as your secondary space , there aren't sufficient volumes to staisfy the request. Here I gave 21 as an example. So basically what the system does it tries to grab as much as possible and eventually when it cannot it abends.

Hope this helps...

cheers

kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group