Search found 6 matches

by yendra
Wed Dec 02, 2009 1:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job control fatal error (-14)
Replies: 3
Views: 2564

Search would reveal not only the meaning of -14 (which you seem to have discovered) but also the fact that the status reported in Director is not always ... Already search and found the other case. Pretty similar. Is there any way to calculate how much memory that required to run specific job or jo...
by yendra
Tue Dec 01, 2009 10:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job control fatal error (-14)
Replies: 3
Views: 2564

Job control fatal error (-14)

Hi all DS guru, i encounter the following error message on my schedule jobs. JC_07_USAGE..JobControl (fatal error from DSRunJob): Job control fatal error (-14) (DSRunJob) Job TR_09_LOOP_CHECK_NEW_USAGE_VAL appears not to have started after 60 secs Actually the error already start several months ago,...
by yendra
Mon Nov 16, 2009 3:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Usage Analysis
Replies: 6
Views: 3588

It's not DS_OBJECTS, it's DS_JOBOBJECTS. ... Thanks a lot for your code. Now i had the result and it show all the reference the HASH FILE select DS_JOBOBJECTS.OLETYPE,DS_JOBS.NAME, DS_JOBOBJECTS.NAME from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHashedInput') and DS_...
by yendra
Mon Nov 16, 2009 3:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Usage Analysis
Replies: 6
Views: 3588

Wrap all the lines together, (remove all enter characters) and make it as a single line and execute it. Alternatively, you can can use this code in universe stage and get the desired output. Search the forum or read help, on how to use the universe stage I wrap all the lines together and run it sel...
by yendra
Mon Nov 16, 2009 2:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Usage Analysis
Replies: 6
Views: 3588

DS_SUPPORT wrote:Welcome to DSXchange...

Execute the following code in Administrator Command prompt, and you will get the desired results.
Is there any command that i need to execute before execute the select statement? Like DS.TOOLS?

I just run it command but return error

Thanks
by yendra
Mon Nov 16, 2009 1:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Usage Analysis
Replies: 6
Views: 3588

Hash File Usage Analysis

Hi everybody, I'm using the datastage 7.5 and use a lot of hash file for references. And now we in the phase that will require to modify the hash file. And the issue that we need to know the impact to the job that use that hash file. Is there any way to now what job that tied up to the hash file? Be...