IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Utility to copy VSAM cluster to GDG other than IDCAMS


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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

Global Moderator


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

PostPosted: Thu May 07, 2009 5:24 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu May 07, 2009 5:35 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu May 07, 2009 5:54 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu May 07, 2009 6:06 pm
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
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu May 07, 2009 6:17 pm
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
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: 8797
Location: Welsh Wales

PostPosted: Thu May 07, 2009 6:30 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu May 07, 2009 6:36 pm
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

Moderator Emeritus


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

PostPosted: Thu May 07, 2009 8:52 pm
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: 1249
Location: Richfield, MN, USA

PostPosted: Fri May 08, 2009 2:51 am
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: 8797
Location: Welsh Wales

PostPosted: Fri May 08, 2009 11:32 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts REASON 00D70014 in load utility DB2 6
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Need COBOL COPY Help in MVS Environment COBOL Programming 4
Search our Forums:

Back to Top