Search found 42189 matches

by chulett
Thu Mar 05, 2009 2:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: stage type object ORAOCI8 not found
Replies: 3
Views: 1594

:lol: That's probably all the utility does.
by chulett
Thu Mar 05, 2009 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: procedure dbms_output in Datastage log
Replies: 3
Views: 2166

:? What exact version are you running? If you're on 7.5 or later you have it but it may not be installed.
by chulett
Thu Mar 05, 2009 2:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Designer hangs when opening DRS stage
Replies: 6
Views: 1975

It involves editing the registry. Get some help from someone who's done that before if you haven't - wrong moves there can render Windows totally inoperable.

Run 'regedit' and remove any 'Ascential' keys.
by chulett
Thu Mar 05, 2009 1:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Designer hangs when opening DRS stage
Replies: 6
Views: 1975

When you uninstalled, did you clean out any leftover registry entries as well? That can be key.
by chulett
Thu Mar 05, 2009 1:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: procedure dbms_output in Datastage log
Replies: 3
Views: 2166

AFAIK, you can't. Dbms output must be polled for to be retrieved and Oracle knows and does this (as do other tools like Toad if that option is enabled) but that won't happen in the OCI stage. Have you tried using the Stored Procedure stage instead?
by chulett
Thu Mar 05, 2009 1:34 pm
Forum: General
Topic: Specifying warning limits
Replies: 4
Views: 1809

A Sequence job run with a warning limit will pass that limit along to all jobs it runs, meaning they will all inherit the warning limit of the controlling job.
by chulett
Thu Mar 05, 2009 8:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequence
Replies: 6
Views: 1900

consulting wrote:I checked Do no Check point run
Uncheck that, then read the help on what that does.
by chulett
Thu Mar 05, 2009 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Running very slowly
Replies: 4
Views: 1718

Re: Job Running very slowly

arvind_ds wrote:Is this happening because of archival logging in DB2?
That seems like a pretty obvious 'yes' to me. As noted, a chat with your DBA is in order, see what your options are for dealing with your newly slow loads.
by chulett
Thu Mar 05, 2009 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequence
Replies: 6
Views: 1900

Checkpoints are automatic, but as noted they restart you from the point of failure, not the activity after the failure.
by chulett
Thu Mar 05, 2009 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COncatenation with blank values
Replies: 10
Views: 2607

Where are you doing this, what stage?
by chulett
Thu Mar 05, 2009 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration File Issue in Parellel Jobs
Replies: 22
Views: 13165

Looks to me like it is saying that it can't find 'default.apt' not 'sh.exe'. And that whole 'rsh issued, no response received' is problematical as well.
by chulett
Thu Mar 05, 2009 6:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: While loop in Datastage
Replies: 17
Views: 14888

You don't need a patch, you need to post your code and explain more fully the nature of your problem. And where exactly you are using this code. :?
by chulett
Wed Mar 04, 2009 6:51 pm
Forum: General
Topic: Using for loop in sequential stage filter command
Replies: 1
Views: 887

Yes, it requires a filename but like you've found you can use /dev/null when you "don't need one" or if you need to use the filename differently than it would otherwise do. Much like you've seen, I've found that it does seem to do a "cat <filename> | <filter>" under the covers, s...
by chulett
Wed Mar 04, 2009 5:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage requires sorted input?
Replies: 16
Views: 7156

Note the use of the word 'should' rather than 'must'. :wink:
by chulett
Wed Mar 04, 2009 4:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get a job name from RT_LOGnnn file ?
Replies: 11
Views: 2967

Delete those files and break the logging, meaning not being able to run the job until that was resolved. And simply viewing a hashed file updates those timestamps, from what I recall.