DSXchange

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....

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.

ray.wurlod wrote:751 is the job number, mapped to the job name in the DS_JOBS table.

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO = '751';

5260 is the process ID of the process that ran the job.

Output from ...

Thanks Ray for information...

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...

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.

Thank you very much Ray for information...

:D