Volume 14, Number 5 -- March 5, 2014
The next issue of Four Hundred Guru will publish on March 12.
Sponsored By

Automate IBM i Dependency Processing


Tired of wasting time in between jobs? Eliminate the guesswork in your schedule. Optimize your workload with event-driven scheduling and use your time efficiently, every time.


With Robot/SCHEDULE, you can create a time-based schedule, an event-driven schedule, or a combination of the two. With automated batch job management, everyone is more productive.


Start your free, 30-day trial now.

Sponsored By

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?


We can HELP!
We have affordable AS/400 software
and data to do all of the above.
Call us for 30 days FREE.


WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com

DB2 For i Scalar Function Performance Considerations
by Michael Sansoterra

I love using user-defined functions (UDFs) in DB2 for i. They encapsulate business logic, provide for code modularity and improve code reusability. But they can also flush performance down the drain. So in this tip, I'd like to use a sample UDF to analyze how it can affect the performance of an SQL statement. READ MORE >

Use Wireshark To Diagnose IBM i Communications Problems
by Ted Holt

Troubleshooting communications problems is akin to dealing with teenagers. There's plenty of room for blame and finger-pointing, and resolving a problem sometimes seems impossible. I don't have anything to help you with teenagers, but I can recommend a free tool for communications problems. It's called Wireshark, and here's how to use it with IBM i communications traces. READ MORE >

Sponsored By

24th Annual Northeast
IBM i User Groups Conference
April 7 - 9, Framingham, MA


Get Connected with i
Connect with mobile devices
Connect to DB2/400 data
Connect to LANs, SANs & the Internet
Connect with your peers


70+ sessions; NEW topics for 2014;
top industry speakers; in-depth seminars;
vendor expo


Register before March 7 and save
Only $550 WITH Monday seminar!


View Conference Brochure

Admin Alert: Setting Up IBM i TCP/IP Host Routes
by Joe Hertvik

On an IBM i partition, you may need to route IP traffic for a particular server over a specific IP address. You could be doing this to segment network traffic or because you can only reach a host server through a specific interface (say an interface that has access to a firewall). Here's the drill for modifying your IBM i TCP/IP routing entries to set up host routing. READ MORE >

Reader Feedback and Insights

We value your feedback and insights.  Feel free to send a letter to the editor.  Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

Senior Technical Editor: Ted Holt
Technical Editor: Joe Hertvik
Contributing Technical Editors: Edwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.


Sponsored Links

Maxava:  Don't wait for a disaster. Start planning today. DR Strategy Guide for IBM i FREE eBook.
System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Dallas, March 18-20.
Northeast User Groups Conference:  24th Annual Conference, April 7 - 9, Framingham, MA



More IT Jungle Resources:

System i PTF Guide: Weekly PTF Updates
IBM i Events Calendar: National Conferences, Local Events, and Webinars
Breaking News: News Hot Off The Press
TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

The Four Hundred
Power Systems Coming To The SoftLayer Cloud

The Most Talked About IBM i Trends And Technology

Buy One XIV Array, Get Another For A Buck

Mad Dog 21/21: Will You Still Need Me When ARM's 64?

IBM Layoffs Begin In The U.S. And Canada

Four Hundred Stuff
SAP HANA: Just a Sidecar to IBM i, For Now

Alaska Telecom Ditches Tape for LaserVault UBD

Google's New Login Is 'Slick,' But Will It Fly in the Enterprise?

Halcyon Gives IBM i Shops an Edge in MQ Management

IBM Aims to Smooth DevOps with RTC Update

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
March 1, 2014: Volume 16, Number 09

February 22, 2014: Volume 16, Number 08

February 15, 2014: Volume 16, Number 07

February 8, 2014: Volume 16, Number 06

February 1, 2014: Volume 16, Number 05

January 25, 2014: Volume 16, Number 04

TPM at EnterpriseTech
Shared Memory Clusters Accelerate Databases

How Priceline.com Rid In-Memory Cache Of Java Jitters

X86 System Sales Grow, Everything Else Shrinks

Adaptive Computing Spans The DigitalGlobe

High Frequency Traders Hedge Bets With IBM Power

Quanta Pushes Foot Inside Enterprise Datacenter Doors

HP Will Chase IBM Accounts To Grow Datacenter Biz

Stacking Up Xeon E7 v2 Chips Against The Competition

Why Amazon Can't Catch Lucera Financial Cloud

Dell Takes A Long View On Datacenters

SAP HANA Wrings Performance From New Intel Xeons

Intel Aims Xeon E7 v2 At Big Memory Workloads


WorksRight Software
Northeast User Groups Conference

DB2 For i Scalar Function Performance Considerations

Use Wireshark To Diagnose IBM i Communications Problems

Admin Alert: Setting Up IBM i TCP/IP Host Routes

Four Hundred Guru


Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2014 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement