Skip to Content
avatar image
Former Member

XI: Message-Processing: Total Runtime?

Hi!

We have a Unix-Script which makes a daily statistic of our messages running through our XI-Machine:

This is done by selecting IB_SYSTEM, IB_NAME, OB_SYSTEM, OB_NAME from Table SXMSPEMAS and EXETIMEST ("Processing Time??") from SXMSPMAST. Both tables are joined through matching fields MSGGUID and PID.

This script works pretty well. But now, we want to see the total runtime of each message.

Just one example:

If a message comes from a ftp-server and is sent to a SAP-System:

First the message is retreived by the File-Adapter running on the J2EE-Engine. Then the message was sent to the ABAP-Engine (Integration Server) and Queued,... there and finally it was sent (by help of TRFC-Queue, or: sap TA SM58) as IDOC to the SAP-System).

Now it would be nice, if we could see each step seperatly, meaning: how long the processing within the J2EE-Engine has needed, how long the ABAP-Engine, and (this would be very nice) when the Message was definitly delivered to the SAP-System.

For example: a message is marked as done within SXMB_MONI even if is still in processing within j2ee (for example if we have to deliver it finally as file on a ftp-server) or if it is still in the TRFC-Queue.

Any help would be great.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Jan 03, 2006 at 04:04 PM

    SXMS_TEST_RUNTIME..USE THAT.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 03, 2006 at 04:20 PM

    I'm sorry, but I'm not able to find SXMS_TEST_RUNTIME.

    Is this a transaction or a table? Is there a misspelling?

    We currently have XI 3.0, SP14 installed.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      it is a report of package SXMSFTEST which contains some test programms for XI....

      best regards

      Christine

  • Jan 03, 2006 at 04:25 PM

    It is a report and you can execute from se38 transaction.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2006 at 09:46 AM

    Thanks Guys,

    --> but I don't want to test my XI-System.

    I want to see how long each message, which have been processed the day before, have lasted.

    For example:

    I want to see, which messages have been processed by our XI-System (as of Transaction SXMB_MONI) but additionaly I want to see each step of the processing of each messages and how long each step has been lasted.

    Like a "Trace", but for each message, which has been processed.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2006 at 12:48 PM

    Use Performance Header.that gives u the snapshot.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2006 at 01:16 PM

    Thanks Sravya,

    yes, thats exaclty what i'm want.

    But: is there a way to extract this data automaticaly (Report,...) to a CSV-File for easily evaluating with some 3rd-party-tools?

    --> We want to extract all data available for all messages which were executed by our system on a given date (and if this works, we want to automaticaly export them day by day)

    Or can you tell me, which tables,... are used to get this information?

    But another thing: This Performance-Header only shows the ABAP-Part of the Message Processing. We want also see the Java-Part (for example, if the process is somehow like that: File -> Routing/Mapping -> Mail then the following components would be involved: J2EE -> Abap -> J2ee)

    Message was edited by: Rene Pilz

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2006 at 03:17 PM

    USE SXMSPMAST.You can derive the statstics by taking info from system tables..but let me blog it ..

    Add comment
    10|10000 characters needed characters exceeded