Why phantom process took all the CPU usage? How can I avoid phantom?
Thanks in advance
Alex
phantom in DataStage
Moderators: chulett, rschirm, roy
Alex
"phantom" is the process name for the process to run DataStage jobs in the background. You cannot change that. If you are running 100% cpu then you must have a big query or not much RAM or even a slow processor. You need to give us more details:
1. DataStage version
2. OS and version.
3. Hardware
4. How much RAM
5. List SQL statement
Kim.
Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com
"phantom" is the process name for the process to run DataStage jobs in the background. You cannot change that. If you are running 100% cpu then you must have a big query or not much RAM or even a slow processor. You need to give us more details:
1. DataStage version
2. OS and version.
3. Hardware
4. How much RAM
5. List SQL statement
Kim.
Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com
Hi,
sometimes (on windows at least) when you stop a job with hash files being loaded to memory they get corrupted and then any attempt to run that job will freez your system and take 100% CPU.
you must first fix or delete theese files.
also after any aborted job it would be wise to search for any zombies.
Roy R.
sometimes (on windows at least) when you stop a job with hash files being loaded to memory they get corrupted and then any attempt to run that job will freez your system and take 100% CPU.
you must first fix or delete theese files.
also after any aborted job it would be wise to search for any zombies.
Roy R.