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
 

 

merging of KE files into a single SE file

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

New User


Joined: 13 Feb 2007
Posts: 12
Location: Hyderabad

PostPosted: Tue Feb 13, 2007 10:58 pm    Post subject: merging of KE files into a single SE file
Reply with quote

i am merging 9 KE files into an SE file by using SYNCSORT

can anybody please advise how to calculate the space for that particular SE file..

Thanks
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 Feb 15, 2007 7:37 am    Post subject:
Reply with quote

Hello,

Maybe i'm the only one in the forum who isn't familiar with KE and SE files. Please explain what they are.

Unless they are allocated/stored in some unique way, the merged file will take the same or less space than the total of the 9 originals (if you keep the same blocksize).
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Thu Feb 15, 2007 2:11 pm    Post subject:
Reply with quote

No Dick, I thought I was..... icon_lol.gif
Back to top
View user's profile Send private message
pavankumarp

New User


Joined: 13 Feb 2007
Posts: 12
Location: Hyderabad

PostPosted: Fri Feb 16, 2007 11:25 am    Post subject:
Reply with quote

Hi Dick,

the 9 Ke files have been allocated with the space cyl(150,150) with around 10 volumes for each of them on an average.

the Se file into which it is getting merged has been defined with 250,500 with around 20 volumes.

we do have sufficient space in the region.

but i would know like the optimum space that is required for that particular SE file. could you please help me on this
Back to top
View user's profile Send private message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Fri Feb 16, 2007 12:04 pm    Post subject:
Reply with quote

Pavan,

Please explain what is a SE and KE file , u say Sequential file as SE or wat is the full form man....



Cheer's,

Thamilzan.
Back to top
View user's profile Send private message
pavankumarp

New User


Joined: 13 Feb 2007
Posts: 12
Location: Hyderabad

PostPosted: Fri Feb 16, 2007 12:08 pm    Post subject:
Reply with quote

ohh sorry

9 vsam files getting mergerd into an Sequential file
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Feb 16, 2007 1:57 pm    Post subject:
Reply with quote

Pull a listcat on the 9 KE files, add the hiused values, divide by track size and that should give you a starting point.
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: Fri Feb 16, 2007 8:54 pm    Post subject:
Reply with quote

Hi Pavan,

How will the sequential file be used? For some one-time processes or be available for regularly scheduled jobs. Is the plan such that it would always be online and available (except when it is being rebuilt)?

Are the 90 (if i understood correctly) volumes near full or is there a large amount of unused space? If they are even 1/2 full that would be 45 volumes (depending on how much of the 90 volumes is index space). What kind of calculation was used to determine "20 volumes"?

When you are calculating how much space for the qsam file, you will not need to consider the index space.

As far as optimum, i'd suggest taking a representative sample of the data from one of the vsam files and copy it to a qsam file with a block size of zero and see what blksize the system chooses. Once you know what your system considers to be a good blkzise, you can follow Bill's suggestion and determine what you need to allocate. Once you have a number, plan on maybe 10% extra (just in case). When you actually run the copy job it will be better to ask for more space than you calculate (using RLSE to give back what you don't need) rather than to under allocate and get an x37.

Copying that much data to a qsam file will take a while, but will be faster than copying from qsam to vsam. . . .

Good luck icon_smile.gif
Back to top
View user's profile Send private message
pavankumarp

New User


Joined: 13 Feb 2007
Posts: 12
Location: Hyderabad

PostPosted: Mon Feb 19, 2007 2:50 pm    Post subject: Re: merging of KE files into a single SE file
Reply with quote

hi dick,
thanks for your inputs..will try it out

Regards,
Pavan.
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: Tue Feb 20, 2007 1:23 am    Post subject:
Reply with quote

Good luck - let us know how it goes & maybe how much dasd space was eventually allocated/used icon_smile.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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 0 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


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