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

Your Roadmap for Proactive System Monitoring


Without visibility, your IBM i could be on a collision course with downtime. Stay ahead of what's going on in your system so it won't spin out of control.


Download this exclusive toolkit to build a customized roadmap of requirements for the ultimate proactively monitored environment.


Download your Proactive IBM i Monitoring Toolkit today.

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

The Case Of The IBM Systems Director And RBAC
by Jeff Waldbillig

It was a dark night on a network that knew how to keep its secrets. Actually, that was last night. Today was going to be a busy day working on the network that knew how to keep its secrets. I'd been temporarily moved from my nightshift role at the help desk to the daylight hours to cover for a coworker who was out with an extended illness, but I was beginning to wonder if my late-night auction surfing had attracted some attention I did not need. READ MORE >

The ADO Client Side Of Default Parameters And Named Arguments In DB2 For i
by Michael Sansoterra

In Stored Procedure Parameter Defaults And Named Arguments In DB2 For i, I covered two new related features in DB2 for i 7.1 that were implemented in Technology Refresh 5 (DB2 for i Group PTF Level 18 or higher). In this tip, I'm going to cover a surprising limitation of this feature when coding in an ActiveX Data Objects (ADO) environment, whether using an IBM DB2 OLE DB provider or the iSeries Access ODBC provider. 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

Auto-Answering Record Lock Errors And More On Returning An IBM i Box
Hey, Joe:

My Power i system is driving me crazy with RPG1218 record lock messages. Because of the way one of our applications was written, we receive RPG1218 messages several times a day. The record lock only lasts a minute. When we enter a retry on the locked record, the system is always able to update the record. Is there any way to auto-answer these record locks? 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

LANSA:  Webinar: Preserving your IBM i investment. February 27, 11 am CT / 12 pm ET
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
Intel's Xeon E7 Brings The Fight To IBM's Power8

Fear Or Freedom: IBM i ERP Upgrades

Oracle To Make JDE More Agile, Less Painful To Upgrade

As I See It: Peeking Under the Hood

IBM Slashes On-Demand CPU And Memory Prices

Four Hundred Stuff
Inuendo: An Associative Database Model for IBM i

CIOs Not Feeling the Green (Screen), Survey Says

Midrange Dynamics' Change Management Enhancements a Matter of Perspective

Enforcive Gives Security Policy Checks a Graphical Makeover

BCD Lets the Mobile Flow with WebSmart 10.1

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

System i PTF Guide
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

January 18, 2014: Volume 16, Number 03

TPM at EnterpriseTech
SAP HANA Wrings Performance From New Intel Xeons

Intel Aims Xeon E7 v2 At Big Memory Workloads

The Math On Big NUMA Versus Clusters

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

Servers Slow And Switches Stall At Cisco

Google Tests Homegrown Power8 Servers

Big Banks Discover Atlantis Storage Virtualization

Netflix Speeds Machine Learning With Amazon GPUs

IBM Jumpgate: An OpenStack Translator For Proprietary Clouds
Startup Slashes Latencies With Server-Switch Hybrid
Canonical To Kick Ubuntu Server Into Hyperscale

Hardware Matters, But Software Also Drives Switch Choices


WorksRight Software
Northeast User Groups Conference

The Case Of The IBM Systems Director And RBAC

The ADO Client Side Of Default Parameters And Named Arguments In DB2 For i

Auto-Answering Record Lock Errors And More On Returning An IBM i Box

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