MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

May 23, 2011 | Volume 6 Issue 10


TOP STORY: DB2 for i: Observing, Learning, Adapting, and Generating Faster Queries Automatically!
FEATURED ARTICLE: High Availability for IBM i
ADVERTORIAL: Partner TechTip: The Science Behind Analyzing Complex RPG Code
NEWS HIGHLIGHT: Minneapolis COMMON Attendance Tops in Three Years
WHITE PAPER: High Availability for IBM i: A Technical Review of Software and Hardware-Based Solutions
FORUM: New Print Features in Free HSSFCGI App
Manage Subscription | Contact Us

Feature Article - Database
DB2 for i: Observing, Learning, Adapting, and Generating Faster Queries Automatically!

Having AQP is like having "quality control" inside your query plans.

mike_cainWritten by Mike Cain

According to Wikipedia, "adaptive behavior" is a type of behavior that is used to adjust to another type of behavior or situation. This is often characterized by a kind of behavior that allows an individual to change an unconstructive or disruptive behavior to something more constructive.


DB2 for i, the powerful database management system integrated into IBM i, has the distinction of possessing this adaptive characteristic for SQL queries. Adaptive query processing, or AQP, has really come into its own in the latest version of IBM i. For years, DB2 for i has been known for ease of use, low total cost of ownership, and unique capabilities aimed at solving business problems.


Feature Article - System Administration
High Availability for IBM i

A technical review of software and hardware-based solutions.

Written by Vision Solutions

Editor's Note: This article is an extract of the white paper High Availability for IBM i available free from the MC White Paper Center. 


This article describes what you need to know in order to make an informed decision with regard to IBM i high availability strategies so that your business requirements for recovery time objective (RTO) and recovery point objective (RPO) are not compromised. With the advent of the unified Power Systems platform, common storage platforms, and virtualization, maintaining high availability protection for an IBM i environment requires careful thought and clear understanding of its underlying architecture and technologies.


Advertorial - Databorough
Partner TechTip: The Science Behind Analyzing Complex RPG Code

How do you deal with large, complex systems?

steve_kilnerWritten by Steve Kilner

The field of science that studies how programmers interpret programs is called Program Comprehension. With the world's ever-growing pile of software, it's an important subject.


Research has led to useful ways to understand what programmers do, especially those who work with legacy systems. This is particularly important in the RPG world, which exhibits persistent attrition of programmers with application knowledge.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor