Hi All,
Our Datastage jobs on prod server are running slow compared to few days back....So i was trying to figure out and checking all posts in dsxchange..
I came across phantom process and PH dir stuff ....and also phantom errors like
"DataStage Job 751 Phantom 5260..."
Can i know what are 751 and 5260 numbers are?
All the phantom logs are stored in PH directory but in some posts i saw for above errors the log files are located in RT_BPxxx dir....
Is RT_BPxx sub dir of PH dir ?Does both are same storing logging info about jobs and active stages?
Thanks....
RT_BPxxx
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
751 is the job number, mapped to the job name in the DS_JOBS table.
5260 is the process ID of the process that ran the job.
Output from these processes (not logs) are only stored in &PH&.
Logs for job number 751 are stored in table RT_LOG751.
RT_BP751 contains run time BASIC programs (source code) for job number 751.
RT_BP751.O contains run time BASIC programs (object code) for job number 751.
Never change anything in the RT_BPxxx or RT_BPxxx.O directories!
There are no logs there.
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = '751';
Output from these processes (not logs) are only stored in &PH&.
Logs for job number 751 are stored in table RT_LOG751.
RT_BP751 contains run time BASIC programs (source code) for job number 751.
RT_BP751.O contains run time BASIC programs (object code) for job number 751.
Never change anything in the RT_BPxxx or RT_BPxxx.O directories!
There are no logs there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks Ray for information...ray.wurlod wrote:751 is the job number, mapped to the job name in the DS_JOBS table.5260 is the process ID of the process that ran the job.Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = '751';
Output from ...
For performance improvement i came across "ade" processes in dsxchange..
when i used "ipcs" for "ade" like 10 processes came out....
These "ade" are for RTI jobs ri8...but the output processes for me are not having any RTI jobs...
What exactly these "ade" process do ?
Thanks...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Each of these processes is executing something in the DataStage engine. It needs to communicate via shared memory, so has to have a shared memory key, which is what the ipcs command is showing you.
The ps command for these processes may show what each is doing.
The ps command for these processes may show what each is doing.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.