Page 1 of 1
DRS Stage Hangs
Posted: Wed Jun 06, 2007 9:47 am
by sri75
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
Posted: Wed Jun 06, 2007 10:11 am
by Minhajuddin
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?
Posted: Wed Jun 06, 2007 11:24 am
by DSguru2B
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.
Posted: Wed Jun 06, 2007 8:52 pm
by ray.wurlod
Is your client running Windows XP sp2? If so, do you have the DataStage patch installed?
DRS Stage Hangs
Posted: Wed Aug 29, 2007 5:20 pm
by msauhta
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.
Posted: Wed Aug 29, 2007 7:36 pm
by chulett
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.
Posted: Wed Aug 29, 2007 8:23 pm
by ray.wurlod
May I suggest that regedt32 has better key-search capability? It also has the same dangers.
Posted: Wed Aug 29, 2007 11:08 pm
by chulett
Sam Ting.
Posted: Fri Aug 31, 2007 9:36 am
by msauhta
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
Posted: Fri Aug 31, 2007 6:24 pm
by ray.wurlod
chulett wrote:Sam Ting.
The man who invented the photocopier before migrating to Russia to invent the technique known as samizdat.