fhg
Volume 7, Number 40 -- November 14, 2007
Four Hundred Guru is taking a vacation next week and will resume publishing on November 28.
Sponsored By
PRODATA COMPUTER SERVICES

Push-Pull-Synchronize Data TODAY!

 

RDB Connect gives you easy access to remote databases from your System i programs.

 

Share real time data across platforms NOW!

 

Use Remote Database Connect today.....download a free trial today.

 

Order today and SAVE $$$!

 

800.228.6318

 

sales@prodatacomputer.com

 

www.prodatacomputer.com


Sponsored By
COMMON

Customize your System i education in 2008 with COMMON's 2008 Annual Meeting & Exposition

 

March 30 - April 3, 2008
Nashville, Tennessee

 

The premier System i education and networking event provides invaluable learning and networking opportunities. It will feature over 500 educational sessions, more in-depth education, user-driven sessions, a greater emphasis on networking, and an extensive Expo.

 

Don't miss it!

 

www.common.org


ON vs. WHERE
Hey, Ted:

I need your help with an SQL query. I have two database files: a header file and a detail file. There may be many detail records for each header record, but I only want to see certain detail records. Here's the rub. I want to retrieve all header records, even the headers for which I don't select any corresponding detail. It seems to me this should be an easy query to write, but my efforts so far produce only the header records for the selected details. READ MORE >

Odds and Ends
Hey, Professional:

It's been a while since we ran an article of odds and ends. Here are several short tips for working with the Integrated File System (IFS). I hope you find something useful. READ MORE >



Sponsored By
WORKSRIGHT SOFTWARE

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




Admin Alert: How Big is My IFS?
by Joe Hertvik

I recently had to quickly determine the size of my production box's AS/400 Integrated File System (IFS) when its DASD usage zoomed past its ASP threshold value and was threatening to crash the system. Since I didn't have a good technique handy, I evaluated several different IFS evaluation methods on the fly. Here's what I learned and how to use these methods to locate where your big IFS folders live. 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

ARCAD Software:  Dynamic, world-class ALM on and around the System i
COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

 

 

IT Jungle Store Top Book Picks

The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
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
Power6 Blades Finally Come to Market from IBM

Power Systems Division: A New Unit, i5/OS and iCluster Included

System i VIP Initiative Boosts Sales, Says IBM

As I See It: The Paradox

The Linux Beacon
Red Hat to Use Automation, Virtualization to Eat the Server Space

Red Hat Puts Out Fedora 8 Rev of Development Linux

Intel Announces First "Penryn" Xeon Processors

Mad Dog 21/21: Symphony for the Devil

Four Hundred Stuff
PowerTech Ships i5/OS Syslog Connector for SIEM

Change Management Software Gets Boost from Mighty Ant

Attachmate Ships Emulator, Touts Tolly Report

BCD Delivers Major Update of WebSmart ILE

Big Iron
Neuwing, IBM to Quantify and Monetize IT Energy Savings

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
November 10, 2007: Volume 9, Number 45

November 3, 2007: Volume 9, Number 44

October 27, 2007: Volume 9, Number 43

October 20, 2007: Volume 9, Number 42

October 13, 2007: Volume 9, Number 41

October 6, 2007: Volume 9, Number 40

The Windows Observer
Visual Studio 2008 to Ship By End of November

Intel Quietly Releases 'Montvale' Itanium Kickers

Microsoft Unveils Free Enterprise Search Product

Windows Home Server Now Available

The Unix Guardian
Sun Wrings Profits from a Flat Fiscal First Quarter

Power6 Blades Finally Come to Market from IBM

Intel Quietly Releases 'Montvale' Itanium Kickers

IBM Brags About Its Power6 Server Shipments

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

THIS ISSUE SPONSORED BY:

ProData Computer Services
COMMON
WorksRight Software



TABLE OF CONTENTS
ON vs. WHERE

Odds and Ends

Admin Alert: How Big is My IFS?

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
IBM 6400 on LPT1 prints junk

Reallocate disk space from one LPAR to another

How to retrieve a workstation ID

Finding *OUTFILE Template Files

i5/OS V5R4 Release Notes





 
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