DSXchange

Basically you have overloaded some resource on your UNIX machine by starting that many jobs and processes at the same time. The actual error is "Fork failed" which means UNIX tried to issue a call to fork() and it was not able to spawn that new process. You could have set user limits on the number o...

The certification is offerred and supported by IBM/Ascential. This site is not affiliated with IBM/Ascential directly and therefore the certification will only get you recognition in these circles, but not any different type of membership.

Use stage variable in a transform stage Variable: "ACount", derivation "IF In.Column="A" THEN ACount + 1 ELSE ACount Variable: "BCount", derivation "IF In.Column="B" THEN BCount + 1 ELSE BCount That gives you a numeric value for subsequent occurrences of a string and you can do the rest from that.

Nagesh,

you can't design any type of a workaround until you solve the cause of your jobs aborting. The error message doesn't mean much; it is like trying to diagnose the reason why an engine isn't running using the red "motor" light on the panel.

Have you tried any diagnosis on the issue yet?

A memo field can store a string up to 65,536 bytes. It is just a long string field and if you define your DB/2 column large enough there should be no problem storing that data. What do you mean by "junk" characters? If the incoming data has binary control characters that are not displayable then the...

Hello and welcome to DSXchange, JSDWBI. this sounds like a Server issue and should be posted in that forum. The access violation is usually a result of exceeding array/storage size in a program - either through bad programming or unexpected data. In this case it is within the aggregator which usuall...

One quick way is to export your project into a .dsx file and then search through it for the hashed file name and then go backwards until you find the job name. This is quick and easy if there are only a few occurrences of the hashed file name. I think that Kim's EtlStats might also assist in finding...

You cannot just remove locks in DS unless you are the Administrator, you can remove those sessions and that will also remove the locks. The easiest thing to do is have your administrator activate the deadlock daemon and that will ensure that all you need to do when this happens in the future is to w...

EdWink - Ray did say what that length is - go to the uvconfig file in your DS directory and look for the value of MAXKEYLENGTH

I haven't seen any actual physical limit on the number of stages in either jobs or sequences - but I've seen lots of jobs with FAR too many stages. Even though it is a matter of style, I feel that if a job goes over 1-2 screens at normal size it is unwieldy, and if it exceeds 4 screens it is crimina...

Put a reject output link that is set to fail the job if any rows go along it, and put in the condition "LEN(In.ShortColumnName)>10" and you are don.

Export each job from the Manager into .dsx files and then do a UNIX "diff" on the two objects. This will show you if they are identical and will let you find the differences between them.

You can use the command to remove all occurrences of CR and LF in your string.

DataStage Version 8.0 is still in beta testing and won't be released for some time. There are some significant changes with version 8 and there might be some migration issues if you have used some of the undocumented internal functions. Are you sure that you are already planning a migration to Versi...

The compiler will not affect the connectivity, just compilation of PX jobs on 7.5x2