Compare two Datastage jobs

monaz · Post by **monaz** » Wed Jul 29, 2009 5:41 am

Hi All,

Can anyone please let me know is there anyway we can compare two datastage jobs?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jul 29, 2009 5:45 am

For v7,

Take export and do a diff.

chulett · Post by **chulett** » Wed Jul 29, 2009 6:30 am

In other words, it's a manual process. Export both to a .dsx and compare using your favorite tool. This is automated in 8.x.

cppwiz · Post by **cppwiz** » Wed Jul 29, 2009 2:39 pm

The Cross Project Compare tool in 8.x is quite nice. Just highlight the job in the repository list and click on the Repository menu then Cross Project Compare and select the other job. It gives a detailed report of the differences.

nagarjuna · Post by **nagarjuna** » Wed Jul 29, 2009 2:43 pm

Unfortunately it will take some time to produce the difference

ray.wurlod · Post by **ray.wurlod** » Wed Jul 29, 2009 4:40 pm

Minutes rather than hours. Learn patience, grasshopper.

sbass1 · Post by **sbass1** » Wed Jul 29, 2009 8:19 pm

This is a long shot, but...

Before I reinvent the wheel (ok, maybe this request isn't as common as a wheel!), has anyone developed any Beyond Compare user-configurable rules to ignore unimportant differences between DSX files? Examples might be:

* VC LOGS *
^1_1 05/26/09 14:03:57 Batch 15122_50672 INIT foddev9 DEV_XXX userid Initialize

added to the job description by the version control tool

TimeModified "some-time"
Readonly "some-value"

etc.

If so, I'd love to get an export of your rules...

Thanks...

P.S.: DS 7.x, Server, Unix

nagarjuna · Post by **nagarjuna** » Thu Jul 30, 2009 8:29 am

ray.wurlod wrote:Minutes rather than hours. Learn patience, grasshopper. ...

I understand ray ...But when i wrote a batch script to compare jobs its taking long time ...for comparision of 10 jobs across twp projects it took nearly 4 hrs

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2009 4:27 pm

Yes, that's minutes. 48 minutes each, on average.

There's a lot of work to do to compare every object and every relationship.

priyadarshikunal · Post by **priyadarshikunal** » Fri Jul 31, 2009 6:21 am

Its not the comparision command which is taking long time, probably it your network connection/server/client system which is taking long time. On my system it compares around 100 jobs with another 100 on other server per hour. Of course it depends on the complexity of the job but you shouldn't complain about the time taken to compare the jobs.

Sreenivasulu · Post by **Sreenivasulu** » Sun Aug 02, 2009 7:30 am

Cross project compare is an excellent feature of version 8. This was a very tedious and manual process in earlier versions.

Regards
Sreeni

kurics40 · Post by **kurics40** » Tue Jul 31, 2012 6:11 am

nagarjuna wrote:... when i wrote a batch script to compare jobs its taking long time ...

Hi Nagarjuna,

Can you show me your batch script?
I dont know how to invoke the compare tool from command line.

Best regards,
Janos

chulett · Post by **chulett** » Tue Jul 31, 2012 6:36 am

kurics40 wrote:I dont know how to invoke the compare tool from command line.

Oddly enough, it's fully documented. Designer Client Guide, Chapter 9.

kurics40 · Post by **kurics40** » Tue Jul 31, 2012 6:54 am

Hi Chulett,

Thanks a lot.

http://publib.boulder.ibm.com/infocente ... jects.html

Best regards,
Janos