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
 

 

Utility to copy VSAM cluster to GDG other than IDCAMS

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

New User


Joined: 03 Apr 2008
Posts: 14
Location: Chennai

PostPosted: Thu May 07, 2009 5:00 pm    Post subject: Utility to copy VSAM cluster to GDG other than IDCAMS
Reply with quote

Hi All,

Is there any efficient utility to copy VSAM cluster to GDG other than IDCAMS?
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Thu May 07, 2009 5:24 pm    Post subject: Reply to: Copy Utility
Reply with quote

Most people would use their sort (DFSORT or SYNCSORT) product.
Back to top
View user's profile Send private message
yasodha_p

New User


Joined: 03 Apr 2008
Posts: 14
Location: Chennai

PostPosted: Thu May 07, 2009 5:33 pm    Post subject:
Reply with quote

If VSAM records are less, as you said DFSORT or SYNCSORT is preferred. I think records are more then it wont be efficient .
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu May 07, 2009 5:35 pm    Post subject: Reply to: Copy Utility
Reply with quote

Quote:
I think records are more then it wont be efficient .

apart Your thinking do You have any data to confirm Your assertion?
Back to top
View user's profile Send private message
yasodha_p

New User


Joined: 03 Apr 2008
Posts: 14
Location: Chennai

PostPosted: Thu May 07, 2009 5:43 pm    Post subject:
Reply with quote

enrico,

I tested now. For copying the 30 records using IDCAMS is taking less time than using DFSORT and SYNCSORT utility.

Any proof you want?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu May 07, 2009 5:54 pm    Post subject: Reply to: Copy Utility
Reply with quote

30 records is not a statistically relevant record count
so useless as a performance/capacity planning indicator

Quote:
If VSAM records are less, as you said DFSORT or SYNCSORT is preferred. I think records are more then it wont be efficient .


You are just contradicting Yourself icon_biggrin.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Thu May 07, 2009 6:06 pm    Post subject:
Reply with quote

If you're doing the copy for backup purposes, DF/DSS would be a possibility. You can't look at the VSAM data without a restore, though.

Copying 30 records is meaningless -- use anything you want. For copying 30 million records, I'd use DF/DSS or DFSORT depending on the reason for the copy.
Back to top
View user's profile Send private message
yasodha_p

New User


Joined: 03 Apr 2008
Posts: 14
Location: Chennai

PostPosted: Thu May 07, 2009 6:11 pm    Post subject:
Reply with quote

Just for check I used 30 records.

When compared to DFSORT or SYNCSORT and IDCAMS, IDCAMS is more efficient.

Any way my question is not this.

My question is " Is there any utility to copy VSAM to GDG which is more efficient than IDCAMS? "

For this DFSORT or SYNCSORT is not the answer .
Back to top
View user's profile Send private message
yasodha_p

New User


Joined: 03 Apr 2008
Posts: 14
Location: Chennai

PostPosted: Thu May 07, 2009 6:14 pm    Post subject:
Reply with quote

Robert ,

My requirement is 49,427,158 records.
when I use IDCAMS it is taking 78.53 minutes for exection.

Is there any way to reduce the execution time?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu May 07, 2009 6:17 pm    Post subject: Reply to: Utility to copy VSAM cluster to GDG other than IDC
Reply with quote

You were already given an answer...
use the sort product available in Your installation

if You do not like the answers You get, change the provider icon_evil.gif
Back to top
View user's profile Send private message
yasodha_p

New User


Joined: 03 Apr 2008
Posts: 14
Location: Chennai

PostPosted: Thu May 07, 2009 6:19 pm    Post subject:
Reply with quote

Are you sure that it will reduce the execution time?
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: Thu May 07, 2009 6:30 pm    Post subject:
Reply with quote

Only testing will tell
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Thu May 07, 2009 6:36 pm    Post subject:
Reply with quote

IDCAMS may be more efficient for 30 records due to lower overhead in setting up to run. I would expect the sort products (and DF/DSS for that matter) to be much more efficient for 50 million records.

As far as the IDCAMS time for 50 million records, how many buffers do you have on the output DD statement? How many BUFND and BUFNI on the input DD statement? Are you copying to tape or disk? What's the output block size and LRECL?
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 07, 2009 8:52 pm    Post subject:
Reply with quote

Hello,

Quote:
My question is " Is there any utility to copy VSAM to GDG which is more efficient than IDCAMS? "
Yes, almost every sort/backup/copy utility will perform better than IDCAMS.

Quote:
For this DFSORT or SYNCSORT is not the answer .
By what/whose direction?

Why you would waste the effort of running timing tests on 30 records is beyond me. Doing things like is one of the main reasons that bad information/statistics gets published.

Suggest you load a vsam file with full volume and run different available utilities (your sort, dfdss, others, etc). If you run these tests at a time the system is nearly empty, the wall time may be meaningful. Regardless of when you run the tests, you will want to note the cpu times and the amount of i/o required.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1238
Location: Richfield, MN, USA

PostPosted: Fri May 08, 2009 2:51 am    Post subject:
Reply with quote

As Dick mentioned, elapsed time is usually worthless when looking for efficiency. Pay more attention to CPU time and EXCPs.
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: Fri May 08, 2009 11:32 am    Post subject:
Reply with quote

For backup / recovery purposes I would suggest looking at FAVER. A brilliant VSAM product.
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 syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm


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