Tune SQL performance using the System i Navigator's GUI.

By Jarek Miszczyk

The graphical interface used to manage all aspects of System i operations has recently quite dramatically evolved. In addition to the traditional Windows client, you now have the ability to perform most of the tasks through a Web browser. Although System i Access for Web has quite impressive functionality, certain areas are still best served by the "traditional" Windows-based client. As of V6R1, professionals who are charged with DB2 administration will probably continue to rely on the rich functionality provided by the System i Navigator for Windows when it comes to DB2 management and performance tuning.

Data volumes grow constantly, even when business is slow. Keeping storage and processing optimized today can save your skin when business booms.

By Chris Thomas

Editor's note: This article provides a summary insight into the 12-page, 5000-word whitepaper System i Optimization Best Practices. The full white paper can be accessed for free by clicking here.

One of the most frustrating aspects of managing systems is the natural yet unfair lack of connection between business volumes and your workload. When economies drag and sales sag, businesses universally look for places to clip budgets.

By Andy Kowalski

Back in the early days of what was then called AS/400, when people said they had a 10 gigabyte machine, they were referring to DASD. Today, they are referring to system memory. The point is that this is not your father's AS/400 (or iSeries or System i), and the changes that have occurred have serious implications for system management and optimization.