PI table for Pipelines

[Former Member]

Hi everybody,

I wonder If someone know in which table I can find the details for start/end time for each pipeline for each PI message.

Exactly I want to know how much time took the message mapping to process the message.

Any help will really appreciated.

Thanks in advance

Ivan

[Former Member]

Hi Arteaga,

Go through this sap help link http://help.sap.com/saphelp_nw70/helpdata/en/42/e7bb8f7c9d3ee0e10000000a1553f6/content.htm

that provides you a step by step guide to see the time taken by pipeline steps in SXMB_MONI

[Former Member]

Hi Kubra,

Thanks for your help,

Do you know how extract the performance header information for a set of messages? (summary)

Regards

Ivan

[Former Member]

It is SXMSPFRAWD

Thanks

Ivan

[Former Member]

Can you just find the times using the SXMB_MONI "Performance Header" information?

[Former Member]

Hi,

Thanks for ur response.

where exactly is the option You mentioned in your before email?

Regards

Ivan

[Former Member]

Go into SXMB_MONI. Click on the bottom-most object on the left and open it up. SOAP HEADER...go into "Performance Header"...then you will see the date/time of each runtime step.

for example....my mapping in this message ran for just milliseconds (153419.288824 to 153419.290696).

- <SAP:RunTimeItem>

<SAP:Name type="DBQUEUE">DB_SPLITTER_QUEUING</SAP:Name>

<SAP:Timestamp type="end" host="sapipg">20091013153419.287361</SAP:Timestamp>

</SAP:RunTimeItem>

- <SAP:RunTimeItem>

<SAP:Name type="PLSRV">PLSRV_MAPPING_REQUEST</SAP:Name>

<SAP:Timestamp type="begin" host="sapipg">20091013153419.288824</SAP:Timestamp>

</SAP:RunTimeItem>

- <SAP:RunTimeItem>

<SAP:Name type="PLSRV">PLSRV_MAPPING_REQUEST</SAP:Name>

<SAP:Timestamp type="end" host="sapipg">20091013153419.290696</SAP:Timestamp>

</SAP:RunTimeItem>

- <SAP:RunTimeItem>

<SAP:Name type="PLSRV">PLSRV_OUTBOUND_BINDING</SAP:Name>

<SAP:Timestamp type="begin" host="sapipg">20091013153419.303789</SAP:Timestamp>

</SAP:RunTimeItem>