fhg
Volume 7, Number 27 -- July 25, 2007
Sponsored By
HELP/SYSTEMS


SEQUEL can be used for
virtually ALL business intelligence functions
on the System i, including:

 

            · Executive Dashboards
            · Graphical Query & Reporting
            · Drill-Down Data Analysis
            · Multi-Platform Database Support
            · E-Mail Report and File Distribution
            · Secure Web Access

 

SEQUEL is the single solution for all
your business intelligence needs.

 

www.helpsystems.com



Sponsored By
PRODATA COMPUTER SERVICES

Join us for our next webinar,
DBU Remote Database (DBU RDB).
DBU RDB allows you to connect via green screen to the following databases:

 

                            · Oracle
                            · MySQL
                            · Microsoft SQL
                            · DB2
                            · and more!

 

Deploy the powerful DBU functionality for cross-platform access to data. Get your FREE 30 day license today and start working outside the box!

 

ProData Computer Services  ·  800.228.6318
www.DoDBU.com


Avoid Large Local Variables in Modules
by Ted Holt

In two previous articles, I dealt with some program design practices that can cause performance problems. Today, I deal with another area where large variables can have a derogatory impact on performance, and I show you a couple of ways to get around the problem. I use RPG for my examples, but the principle applies to any language. READ MORE >

Memory Management: It's Your Fault, Now Fix It
by Doug Mewmaw

This year, I will be on the AS/400 platform for 19 years. Wow--where did that time go? All those years working with peers, customers and the like, I'm convinced that the performance component that is the most misunderstood, is memory. In a previous article, I explained about the importance of the machine pool and we looked at the Performance Adjuster feature of i5/OS as well. The feedback I received from that article proved to me that we need more articles on managing memory. READ MORE >



Sponsored By
GUILD COMPANIES

Top Titles Available at IT Jungle Bookstore

 

Our most popular titles are available for immediate order
now at the IT Jungle Bookstore.

 

Browse through our top book picks including
the iSeries Pocket and WebSphere series, and
other books by Brian Kelly.

 

Visit the IT Jungle bookstore today!
store.itjstore.com/os400.html




Admin Alert: Getting Around System i Default Passwords, Part 1
by Joe Hertvik

Since processing time immemorial, i5/OS and OS/400 computers have had problems with default passwords. Default passwords occur when a user password is equal to its corresponding user profile name. They are mostly created by the system's user creation commands, and i5/OS administrators can spend a lot of time finding and changing these hacker magnets. This week, I'll examine the dynamics of System i default passwords and how they are created. 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 Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

 

Sponsored Links

Maximum Availabilty:  The Ultimate System i Replication for Business of All Sizes
COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
New Generation Software:  Leading provider of iSeries BI and financial management software

 

IT Jungle Store Top Book Picks

The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95

 

The Four Hundred
IBM Creates New Power, SMB Server Divisions

Rumor Du Jour: i5/OS on Other Platforms? Not!

IBM Turns In Its Best Second Quarter in Six Years

As I See It: Lawyers, Lies, and Statistics

The Linux Beacon
Linux Distro Xandros Buys Email Specialist Scalix

HP Buys System Management Tool Maker Opsware for $1.6 Billion

IBM Creates New Power, SMB Server Divisions

As I See It: Lawyers, Lies, and Statistics

Four Hundred Stuff
IBM Upgrades High-End System i Server with Power6

IBM Previews i5/OS V6R1, Due in 2008

EMC Offers Hardware-Based HA Alternative

SugarCRM Now Available for i5/OS

Big Iron
Three-Digit z Boxes Head for History

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
July 21, 2007: Volume 9, Number 29

July 14, 2007: Volume 9, Number 28

July 7, 2007: Volume 9, Number 27

June 30, 2007: Volume 9, Number 26

June 23, 2007: Volume 9, Number 25

June 16, 2007: Volume 9, Number 24

The Windows Observer
Ballmer Talks Up 'Cloud Computing'

Opsware Locks Down Server Changes with SolidCore

Microsoft Ships Windows Home Server

Oracle Says 11g Database Is Better, Cheaper, and Faster

The Unix Guardian
IBM Creates New Power, SMB Server Divisions

IBM Turns In Its Best Second Quarter in Six Years

Intel Certifies Solaris on Its Carrier-Grade Servers

Mad Dog 21/21: To Avatar and Avatar Not

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

THIS ISSUE SPONSORED BY:

Help/Systems
ProData Computer Services
Guild Companies



TABLE OF CONTENTS
Avoid Large Local Variables in Modules

Memory Management: It's Your Fault, Now Fix It

Admin Alert: Getting Around System i Default Passwords, Part 1

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
What's coalesce good for?

Duplicated printer files

Urgent Help Needed--Limit the result set in SQL stored procedure

Problem with "cpyfrmimpf"

FNDSTRPDM Output Member Name to *OUTFILE





 
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-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement