DRS Stage Hangs

sri75 · Post by **sri75** » Wed Jun 06, 2007 9:47 am

Hi

when I am trying to open DRS Stage , job just hangs.we can run the jobs and view the stage from the designer . This happens only from one machine

does anyone have any idea ?

Thanks

Minhajuddin · Post by **Minhajuddin** » Wed Jun 06, 2007 10:11 am

Does your DRS Stage have a very big complex Join or a view which has a very Complex Join?
If so then it will definitely hang.
Can you post the SQL Query you have in the DRS Stage?

DSguru2B · Post by **DSguru2B** » Wed Jun 06, 2007 11:24 am

How much is the memory (RAM) on this particular machine? And what is the difference with other machinces?
If there is no difference then try to cut out some programs that are running in the background to release some memory.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 06, 2007 8:52 pm

Is your client running Windows XP sp2? If so, do you have the DataStage patch installed?

msauhta · Post by **msauhta** » Wed Aug 29, 2007 5:20 pm

ray.wurlod wrote:Is your client running Windows XP sp2? If so, do you have the DataStage patch installed?

Hi Ray,

Even i am facing the same error, i installed the patch for XP sp2 but nothing works out. If i try opening a DRS Stage then Datastage client just freezes and i have to end the DS client from task manager. Any help is highly appreciated. I am using DS 7.5.1 on a windows client with UNIX server having solaris OS 9.

chulett · Post by **chulett** » Wed Aug 29, 2007 7:36 pm

The SP2 patch is for problems with Sequence jobs, not the DRS stage. Are you the only one having this problem? If so, I'd suggest you completely uninstall the DataStage client and then re-install it. And by 'completely', I mean with extreme prejudice:

1) Uninstall.
2) Remove any leftover Directories.
3) Use (Run...) 'regedit' to remove all traces of any 'Ascential' keywords.
4) Reboot.
5) Re-install.

Be careful with #3, if you've never used 'regedit' before you can get yourself in a World of Hurt if you use it improperly.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 29, 2007 8:23 pm

May I suggest that regedt32 has better key-search capability? It also has the same dangers.

chulett · Post by **chulett** » Wed Aug 29, 2007 11:08 pm

Sam Ting.

msauhta · Post by **msauhta** » Fri Aug 31, 2007 9:36 am

ray.wurlod wrote:May I suggest that regedt32 has better key-search capability? It also has the same dangers.

Hi Ray, I tried that thing an dit worked...

Thanks for all help

ray.wurlod · Post by **ray.wurlod** » Fri Aug 31, 2007 6:24 pm

chulett wrote:Sam Ting.

The man who invented the photocopier before migrating to Russia to invent the technique known as samizdat.