A quick way to check the health of your SAP PI system is to see the status of its queues. If messages get stuck in queues, you either have a slow system or an error situation. Queues can be monitored in SAP with the SMQ2 transaction.
The problem with this approach is that it requires you to logon to SAP and execute SMQ2 transaction. SMQ2 doesn't neatly summarize the status for a quick glance. I wanted a simpler graph that shows me this information, and I wanted this to be accessible from my iPhone. This article series describes the steps I took to create it.
h3. Overview Part 1 - Introduction to the iPhone monitor (this blog)
[Part 2 | Monitoring XI/PI queues on your iPhone -- Part 2 - Retrieving Queue Information from SAP PI with Per...] - Retrieving Queue information from SAP PI with Perl.
[Part 3 | Monitoring XI/PI queues on your iPhone -- Part 3 - Create charts] - Creating a web page with a bar chart using Google Charts.(*view a demo*)[Part 4 | Monitoring XI/PI queues on your iPhone -- Part 4 - iPhone webapp] - Package the website as an ITouch applicationh3. ScreenshotsIt always helps to see what the end result would be like. So here are some screenshots from the iPhone and *view a demo* of the website. !http://farm5.static.flickr.com/4023/4584782826_725c1a5850_o.jpg|height=480|alt=iPhone Menu|align=top|width=320|src=http://farm5.static.flickr.com/4023/4584782826_725c1a5850_o.jpg|border=1! !http://farm5.static.flickr.com/4034/4584155039_d0c9e37b02_o.jpg|height=480|alt=Queue graph|align=top|width=320|src=http://farm5.static.flickr.com/4034/4584155039_d0c9e37b02_o.jpg|border=0!
h4. ToolsSQLite command line shell.
iWebKit to package the website as an iPhone application.
Apache Tomcat or IIS to test your website locally.
Amazon S3 to host the website. (You could use something else).
h4. Preparing your environmentWe need a working Perl environment with all the modules. The instructions for this setup is in a seperate blog - Using Perl for SAP RFC - Part 1 - Installing PerlAlternatively see the next section on a QuickStart.You can download the SQLite command line shell to examine the SQLite database .To install Apache Tomcat, you'll need Java 1.5 or higher . Download Tomcat from the Apache site. If you are not permitted to install software, download the ZIP file and unzip it to c: omcat. The blog assumes you have tomcat installed in c: omcat.</p>h4. Quick Start
The entire Perl environment, perl scripts etc. can be downloaded from the PI_monitor project on Sourceforge.
- Download the *perl_with_sapnwrfc.zip *file and extract it to C:strawberry.
Download the pi_monitor.zip file and extract to c:strawberrypi_monitorCopy c:strawberrypi_monitorMTP.yml to your Edit c:strawberrypi_monitordownload.cmd. Change PXP/PP4 to your server schtasks /create /sc minute /mo 5 /tn "Download SAP Queues" /tr c:strawberrypi_monitordownload.cmd* This will start collecting data to c:strawberrypi_monitorQueueMonitoring.sqdb (SQLite database). The next steps are needed to adjust the HTML pages to show data of your <sapsids> instead of PXP,EPA and PP4.</p><ol><li>(webpage changes) -Modify c:strawberrypi_monitorwebmonitor.html. Replace EPA/PP4/PXP with the <sapsid> of your servers.</li><li>(iphone webapp changes)* Modify c:strawberrypi_monitorwebindex.html. Replace EPA/PP4/PXP with the The next part (Monitoring XI/PI queues on your iPhone -- Part 2 - Retrieving Queue Information from SAP PI with Per...) discusses how to collect queue data from SAP using Perl and RFC functions.
