jobs compare

fmartinsferreira · Post by **fmartinsferreira** » Thu Oct 05, 2006 12:52 pm

Is it possible to compare a job in a project with a job in a ".dsx" file?

Regards,

Fernando Martins

kduke · Post by **kduke** » Thu Oct 05, 2006 1:56 pm

Export the job and compare the 2 DSX files.

fmartinsferreira · Post by **fmartinsferreira** » Thu Oct 05, 2006 2:16 pm

Sorry

, but how can I compare 2 ".dsx" files?

Fernando

ds_developer · Post by **ds_developer** » Thu Oct 05, 2006 2:20 pm

.dsx files are just text. You can compare them visually with a text editor or with a tool (download a trial of UltraCompare).

John

fmartinsferreira · Post by **fmartinsferreira** » Thu Oct 05, 2006 2:40 pm

Hummm OK! :D

But, the DataStage doesn't have a specific tool to compare jobs?

Fernando Martins

kris007 · Post by **kris007** » Thu Oct 05, 2006 2:41 pm

Not yet

fmartinsferreira · Post by **fmartinsferreira** » Thu Oct 05, 2006 2:58 pm

Thanks!

kduke · Post by **kduke** » Thu Oct 05, 2006 5:22 pm

It is my understanding that MetaStage has a compare tool or report. You could also do it in Reporting Assistant. HAWK has an awesome tools for comparing anything.

chulett · Post by **chulett** » Fri Oct 06, 2006 6:45 am

I'm assuming that's what the "not yet, wink wink" message meant - it is coming in Hawk from what I understand.

I just do it the old fashioned boring way - export and UltraEdit.

kduke · Post by **kduke** » Fri Oct 06, 2006 7:53 am

Version 7x sucks. We want 8x.

ArndW · Post by **ArndW** » Fri Oct 06, 2006 8:00 am

Be careful what you wish for, you may get it! I know that we'll be pining for "good old Version 7.5x once we work with the first versions of 8"

Ultramundane · Post by **Ultramundane** » Fri Oct 06, 2006 8:42 am

Yes and so does Ascential's maintenance process of not creating rollups for patches and baselines. Hopefully IBM has mandated that Ascential test their software and remove bugs, at least 99.9% of them before they release the product instead of giving me a product that works for about 10% of what I need to do. Well, to be honest, it works about 90% of the time now that I have applied about 25 patches over the course of 1.5 years! On the patches, many of the patches I have received are over 1 year old. They never made it into 7.5.2. Seems ludicrous to me. Had I not requeted this patches be applied to 7.5.2 where would they have gone? Believe it or not, Ascential did not know what would have happened to the patches. Anyways, after getting 7.5.2 I had to request that Ascential create patches for about 20 fixes that never went into 7.5.2. Crazy.

chulett · Post by **chulett** » Fri Oct 06, 2006 9:30 am

Ultramundane wrote:Anyways, after getting 7.5.2 I had to request that Ascential create patches for about 20 fixes that never went into 7.5.2. Crazy.

Yikes... are these patches primarily for one product over the other, parallel versus server for example? I'm in the process of getting my hands on the 7.5.2 version of Server and this concerns me. Of course, I haven't needed 20 or 25 patches in the last 1.5 years...

Ultramundane · Post by **Ultramundane** » Fri Oct 06, 2006 10:40 am

We are on AIX.

Yes. They are all for parallel canvas. However, there is some overlap. The big patch which has about 20 patches rolled into one (we requested this), is associated with case 488712. This big patch contains many corruption issues caused by datastage and incorrect date, time, timestamp handling, and decimal handling. There are fixes for version control bugs, enhanced dsjob log output, fixes for issues with passwords, which are encrypted, beig displayed uncrypted in the job log. Truncate option not doing truncate but delete. Removal of many unwanted and buggy datastage permission checks. Fixes to support Sybase user defined datatypes. Varchar's being corrupted because of being padded with PAD_CHAR. NullToValue fixes in transformer. Upserts (delete then insert) failing to insert after delete. And more.

We also have newer ODBC drivers for long varchar support Case 470645. In addition, a patch which fixes incorrect warning error messages (Ecase 97821). I am still waiting for some other patches for a TIME datatype corruption bug and a few others. We still have a problem with mload jobs getting hung and stuck in "Multiload Acquisition Phase", but I am confident that that one is actually a Teradata utilities issue.