Search found 42189 matches

by chulett
Thu Sep 24, 2009 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: comma seperated qouted job parameter
Replies: 2
Views: 1362

Your slashes are going the wrong way.
by chulett
Thu Sep 24, 2009 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One project hangs attempting to connect
Replies: 7
Views: 3477

No, not the box yet, just DataStage. The box would take an Act of Congress. And yes, everyone has the issue not just me... if it was just me I wouldn't be quite so worried. :wink: I've never been able to telnet over to it, I think they have that locked down for some reason as I can only get there vi...
by chulett
Thu Sep 24, 2009 5:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: get the "compiled" job status in Unix cmd-line int
Replies: 5
Views: 3786

Well... run it in a loop for all jobs in the project and see if you get a '99' for anything other than your compiled jobs. May give you some peace of mind, or show that we need something "tighter".
by chulett
Thu Sep 24, 2009 5:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job link can't show message
Replies: 9
Views: 2475

jerrylzdd wrote:OK,i will move the topic to Enterprise Edition forum.
Actually, the request was for the Moderator (not you) to move (not repost) this in the proper forum. That way we don't lose the conversation history.
by chulett
Thu Sep 24, 2009 5:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rules in transformer for deleting rows
Replies: 9
Views: 2148

Have you not worked with hashed files yet? They are the heart and sould of Server jobs so something to become very, very familiar with if you haven't already. :? Probably easiest to do this in two jobs. First one that just creates the hashed file and looks something like: OCI -> Transformer -> Hashe...
by chulett
Thu Sep 24, 2009 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One project hangs attempting to connect
Replies: 7
Views: 3477

Nothing, eh? Dang. :cry:
by chulett
Thu Sep 24, 2009 5:29 am
Forum: General
Topic: capture duplicate
Replies: 9
Views: 2515

I can't tell from your example what the "duplicates" would be. General advice - sort by the grouping key(s) then check for duplicates using stage variables. First time you see a 'group' is ok, if you see the same one again, not so ok and you should be able to discard or capture them fairly...
by chulett
Thu Sep 24, 2009 5:26 am
Forum: General
Topic: capture duplicate
Replies: 9
Views: 2515

y dont u use remove duplicate stage nd dn a compare stage. aneways transformer degrades the performance :!: Two points, last one first: Transformer performance has not been an issue for quite some time, that was addressed years ago, so your advice while good intentioned is out of date. Please use a...
by chulett
Wed Sep 23, 2009 10:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to split one file into two
Replies: 7
Views: 2164

You haven't said what exactly your "problem" was.
by chulett
Wed Sep 23, 2009 10:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I load a binary file?
Replies: 6
Views: 2126

Actually, your new requirement is to explain to us exactly what you mean by "binary file" in this context. As noted, without a proper explanation of what you need to do, we're all guessing as to the solution.
by chulett
Wed Sep 23, 2009 8:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborts after 50 warning messages
Replies: 13
Views: 11472

You can't. You need to be disciplined with how you run jobs and manage the warning limits, typically via some kind of job control, and avoid the urge to run jobs with 'unlimited' warnings.
by chulett
Wed Sep 23, 2009 7:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job link can't show message
Replies: 9
Views: 2475

Then that's what I would expect the job report to show as well. Are you sure you have the JobMonApp running properly?
by chulett
Wed Sep 23, 2009 5:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One project hangs attempting to connect
Replies: 7
Views: 3477

Here is what I see while my connection attempt is "hung", there's only one other person connected and that's to another project. I removed their small number of records from the Active Record Locks section for clarity. >LIST.READU EVERY Active Group Locks: Record Group Group Group Device.....
by chulett
Wed Sep 23, 2009 4:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One project hangs attempting to connect
Replies: 7
Views: 3477

One project hangs attempting to connect

Not sure what's going on, so need some help. Had something strange going on in one particular project where you'd open a job named 'A' and internally it would show with name 'B' in the Designer. We found this with two jobs so exported one and found the Category "corrupted" - it showed in t...