skip to main content

SAP NetWeaver Newbie

Checking Largest XI Message Between 2 Timestamps

Assuming that XI 3.0 is used with Oracle on UNIX system. The application's time zone setting is assumed to be EDT.

To check message sizes between:
20-Jul-2010 05:42:44 EDT and 20-Jul-2010 05:59:27 EDT

1. Convert the times to GMT
20-Jul-2010 09:42:44 GMT and 20-Jul-2010 09:59:27 GMT

2. Log into DB server and run the following commands:
sqlplus "/ as sysdba"

SET LINESIZE 300
COLUMN MSG_ID format A40
COLUMN TRAN_HEADER format A200
spool message123.txt

select MSG_ID, TRAN_HEADER from sap[sid]db.XI_AF_MSG where SENT_RECV_TIME > CAST ( to_date('20-Jul-2010 09:42:44','dd-mon-yyyy HH24:MI:SS') AS TIMESTAMP ) and SENT_RECV_TIME < length="/"> message123content.txt
sort -n message123content.txt > message123sorted.txt

tail -3 message123sorted.txt
3025555
3169956
54780241

grep 54780241 message123.txt
4e44f773-8935-402c-e130-82100a2204b0 Content-Length=54780241

3. 4e44f773-8935-402c-e130-82100a2204b0 is the largest message.

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.