Page 1 of 1

DS server crash

Posted: Fri Jul 11, 2008 6:23 am
by kirankota79
I am running some set of jobs which includes updates, loading and selecting jobs. i am using 4 nodes in config file. The server is getting crashed and i have to re run the jobs. For the update jobs i am using hash partition on the o/p oracle enterprise stage.

Can someone tell me the possible reasons of the server getting crashed? this is happening regularly.

Thanks

Posted: Fri Jul 11, 2008 7:38 am
by ArndW
Can you explain what "server getting crashed" means? Does it mean that your job aborts or that the DS Engine stops? In either case, an error message posted here will go a long way towards getting a qualified response.

Posted: Fri Jul 11, 2008 3:48 pm
by kduke
You need system level stats to see what is happening at the server level as well. Are you paging? How much RAM do you have? How much is being used? Is your database on the same server? Are you out of disk space or scratch space when you crash? Lots of things can cause this. Answer Arnd's question then these. We should be able to help you better.

Posted: Fri Jul 11, 2008 5:43 pm
by ray.wurlod
Is it the DataStage server or a database server that is "getting crashed"? And what, precisely, does "getting crashed" involve?

Posted: Sat Jul 12, 2008 10:23 pm
by kirankota79
sorry , ignore this topic. i misunderstood the issue.