How to get OS PID in DS job trace log

[Former Member]

Hi

Please let me know how can I configure OS PID to be captured in trace log of a job. At present trace logs contain a run id which I am not able to track with OS process.

I would also like to know if there is an easier way to capture which Job/Wf/DF is using how much pCache. We have a 100GB allocated and it getting full couple of times in a week.

Regards

Manish Singh

[Former Member · Accepted solution]

This should be right in the trace log (red is PID, blue is TID).

(14.2) 04-15-15 07:20:33 (5896:5428) DATAFLOW: Process to execute data flow <DF_GL_BUDGET_ACCOUNTS> is started.

See section 3.2.4 of the Performance guide: http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_perf_opt_en.pdf

For the cache, if you run with "Collect statistics for monitoring" checked, you can see the cache usage in the Data Services Management Console > Administrator > Status > Click the name of your system > Performance Monitor in the list of completed batch jobs.

[Former Member · Accepted solution]

Hi

Thank you for your response.

Is there a table where PID/pCache usage for a job/DF is stored and I query to get that info. I need to get pCache usage by jobs so that I can find out which jobs are consuming high pCache.

Regards

Manish Singh

[srinivasan_vinayagam]

Hi Manish,

The trace log file has the PID of the OS Process, if its windows, go to the JobServer machine, and AL_ENGINE.EXE process from the task manager PIDs you can find.

The default pageable cache directory is %LINKDIR\Log\PCache.

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_perf_opt_en.pdf

The PCache option is stored in your DSConfig.txt file

Check AL_* tables like AL_STATISTICS

AL_HISTORY_INFO maintains a log files history

AL_STATISTICS maintains history of job statistics at Dataflow and transform level.

http://webcache.googleusercontent.com/search?q=cache:GHLnr2eMI8gJ:wiki.scn.sap.com/wiki/download/att...

Regards,

V Srinivasan