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
 

 

Want to compare these 2 cluster key KSDS Compare

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

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Wed May 23, 2007 8:27 pm    Post subject: Want to compare these 2 cluster key KSDS Compare
Reply with quote

I have 2 clusters

1. PROD.CLUSTER : PRODUCTION
2. PROD.BACKUP : BACKUP TILL PREVIOUS DAY

I want to compare these 2 cluster key wise and extract records from PROD.CLUSTER which have changes.

Will this process run faster with program or can anyone suggest any utility by which we can achieve same faster ?
Back to top
View user's profile Send private message

William Thompson

Global Moderator


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

PostPosted: Wed May 23, 2007 8:42 pm    Post subject:
Reply with quote

It depends, how many bytes of data in the record do you want to compare? The whole record of just some specific fields?
Back to top
View user's profile Send private message
ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Thu May 24, 2007 10:34 am    Post subject:
Reply with quote

I need to compare whole record.

I need to implement this on 14 production files.

e.g.
File :
KEY Record
100100112345ME Name Gender
100100112345MD DEP-NAME DEP-GENDER INDICATOR
.
.
Million records....

Now the production file will have same records with some changes.

I want to compare two clusters and extract changed records into a flat file.

Please suggest me an approach, whether I should code a cobol program or is there any utility which can help me to do this ?


Regards,
Ranjit
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Thu May 24, 2007 10:56 am    Post subject:
Reply with quote

Compare using FILE AID/FILE MASTER in Batch Mode.
Back to top
View user's profile Send private message
ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Thu May 24, 2007 11:14 am    Post subject:
Reply with quote

I have never used a file aid in a batch mode. Could you please let me know which document should I refer for it ?

Regards,
Ranjit
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 24, 2007 12:26 pm    Post subject:
Reply with quote

What about some programming logic to produce an audit trail of changes made to the cluster, as they are made.

Can I ask the requirement to see which records have changed.
Back to top
View user's profile Send private message
ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Thu May 24, 2007 12:41 pm    Post subject:
Reply with quote

I am creating an HLd for a project.



Its not possible to include audit trails as these clusters are updated by multiple online and batch programs daily.

We discussed about writing programs for each cluster to get the changed records.

I just want to know for millions of records which will be faster, cobol code for each cluster or using some utility to get the changed records.

We have a time limit for about an hour and half to do the entire process and this will be just an initial part of the process.

Please suggest accordingly...

thanks,
Ranjit
Back to top
View user's profile Send private message
ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Thu May 24, 2007 3:04 pm    Post subject:
Reply with quote

I tried fileaid compare but it does not give output in the same record format. It gives output like a report.
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 24, 2007 8:34 pm    Post subject:
Reply with quote

Hello,

If you have a custom requirement, i'd suggest custom code.

If you read each file in a COBOL program and compare, the performance will probably be similar to the file compare utilities and you will have more control of the process (as when new requirements arise).
Back to top
View user's profile Send private message
ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Fri May 25, 2007 8:15 am    Post subject:
Reply with quote

Thanks a lot. Will go ahead with the cobol programs.
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 May 25, 2007 7:09 pm    Post subject:
Reply with quote

You're welcome 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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts COMPARE command sivatechdrive TSO/ISPF 7 Fri Sep 16, 2016 4:31 pm
No new posts Icetool or Joinkeys example to compar... ishant chauhan DFSORT/ICETOOL 21 Sat Aug 20, 2016 2:40 am
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm


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