Search found 42189 matches

by chulett
Sat Sep 25, 2004 4:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Clear a Hashed File Outside of Datastage Job?
Replies: 37
Views: 15718

I guess Ray's not going to come back and provide some closure for this thread. :cry:
by chulett
Sat Sep 25, 2004 4:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniVerse user limit has been reached
Replies: 2
Views: 2401

I would think just failed / broken connections that failed to cleanup properly. :?

You might want to search the forum for posts on the DEADLOCK daemon. It would help with issues like this and has been discussed quite thoroughly in the past here.
by chulett
Sat Sep 25, 2004 4:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reverse the records in DataStage
Replies: 8
Views: 4714

If you do end up using a hash file to remove the duplicates in your file, you could store the record number (@INROWNUM) along with your data. Then, by accessing the hash file with a UV stage, you could pull them back out in reverse order.
by chulett
Fri Sep 24, 2004 8:21 pm
Forum: Site/Forum
Topic: RSS feed message date/time
Replies: 3
Views: 2694

Hmm... I use Trillian Pro. No dates are displayed, as far as I know, so can't really help here. :?
by chulett
Fri Sep 24, 2004 10:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle Import Error
Replies: 3
Views: 981

What happens if you try to import your metadata using the OCI stage? I.E., via the "plugin" metadata option. As long as you have your environment configured for OCI, that is...
by chulett
Fri Sep 24, 2004 9:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bus error (Coredump)
Replies: 22
Views: 7909

I ran into this problem too and was told that I could comment out the LD_PRELOAD stuff in the dsenv if I wasn't using PX, I think. Interesting. I was working on the comment in dsenv that says it must be unset on HP/UX 11.00 - and we run 11.11, which I understand is 11i. However, I've just double-ch...
by chulett
Fri Sep 24, 2004 8:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage windows NT server for 5.x or 7.x
Replies: 4
Views: 1318

Nope, won't even let you install it. And it's important to note that while the Client is certified to run on XP Pro, the Server is not. Certified, that is. My understanding is that it does work, but it is important to note the distinction.

Be careful of SP2.
by chulett
Fri Sep 24, 2004 7:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Clear a Hashed File Outside of Datastage Job?
Replies: 37
Views: 15718

I wasn't going to say anything. Didn't figure *I* should be one to comment about sigs. To Ken's point, yes - but the job will fail the first time it runs unless you remember do some manual intervention. That is, if the lookup comes first and the write to the hash comes second, then the lookup will f...
by chulett
Thu Sep 23, 2004 7:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bus error (Coredump)
Replies: 22
Views: 7909

Hmm... I'll have to check SHDISPATCH and check for a global .profile, I have no idea off the top of my head. As to the question re korn shell scripts from UNIX, yah, they all work great. It's only when they get executed by a DataStage job that they core dump - and then only on certain servers. Kim, ...
by chulett
Thu Sep 23, 2004 4:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Clear a Hashed File Outside of Datastage Job?
Replies: 37
Views: 15718

That's not the problem. It's already been established that either of those commands work for hash files created in an account, i.e. in a project. The question of the day is how to do the same thing for explicitly pathed hash files, those created outside of the project. That would mean ones without a...
by chulett
Thu Sep 23, 2004 2:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bus error (Coredump)
Replies: 22
Views: 7909

Not really. No fixes other than the need (for whatever reason) to change all references of: #! /usr/bin/ksh to: #! /usr/bin/sh in our scripts. Some of my servers can run either shell, but others (like Production!) core dump when specifying the korn shell. No clue what in the heck the difference is. ...
by chulett
Thu Sep 23, 2004 2:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Clear a Hashed File Outside of Datastage Job?
Replies: 37
Views: 15718

My earlier suggestion will work. I know, I already do this. Now just trying to make this other new fangled method work. I've done something else that looks a little goofy but also works. Drop a Transformer on the canvas and hook it to the Hash Lookup so that it thinks you want to write to it. Creat...
by chulett
Thu Sep 23, 2004 1:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Clear a Hashed File Outside of Datastage Job?
Replies: 37
Views: 15718

I'm stumped on this one. I've created my own Before/After subroutine to do this, put it into a Server Job and all I've accomplished so far is to duplicate your situation - 'normal' O/S commands work fine, but executing clear.file craters the job. Server side tracing did not shed any light on what's ...
by chulett
Thu Sep 23, 2004 1:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer Trouble
Replies: 6
Views: 1245

Strange. The Sequence stage doesn't really serve a purpose in your job and could be removed. However, it shouldn't be causing any problems, either. I don't see how adding another Notification Activity stage would be a problem. You could easily have multiple links from the Sequencer to multiple Notif...
by chulett
Thu Sep 23, 2004 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maintaining more than one Send Mail Template ?
Replies: 5
Views: 1678

I altered the dssendmail template text file to have the actual EMail address so that in future if i have to add one or more email addresses or remove anything, i can remove it just in the template and neednt really care about changing all Jobs. This is what is generally known as a "Bad Idea" and is...