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

April 13, 2012 | Volume 9 Issue 15


TOP STORY: TechTip: DB2's CONNECT BY Simplifies Recursive Processing
FEATURED ARTICLE: DB-Gate Simplifies Access to Remote Databases from IBM i
ADVERTORIAL: Partner TechTip: Is Your IBM i "House" Built on a Solid Foundation?
NEWS HIGHLIGHT: IBM Announces PureSystems Family of Solutions
BUYER'S GUIDE: Maxava HA Enterprise +
EVENT: LANSA 2012 International User Conference
Manage Subscription | Contact Us

Feature Article - TechTip
TechTip: DB2's CONNECT BY Simplifies Recursive Processing

At first glance, recursion appears to be a computer science method that's relevant only in the world of academia.

kent_milligan_117x117Written by Kent Milligan

Recursion is a great for traversing linked lists or generating the numbers of a Fibonacci sequence, but recursion can't be applied to business problems…or can it? 

In reality, there are several industries where data elements have inherent relationships with other elements, and the best way to connect these data elements is with recursive (or hierarchical) processing. The classic example is the generation of a bill of materials explosion in the manufacturing industry. A bill of materials explosion breaks apart each assembly or sub-assembly into its component parts.


Feature Article - Database
DB-Gate Simplifies Access to Remote Databases from IBM i

Raz-Lee Security appears to have broken the code on remote data access, making it simple enough for any user to seamlessly access data on any remote data store.

chris_smithWritten by Chris Smith

Raz-Lee Security is now offering, for a limited time, a free trial of its remote database access product DB-Gate. The new product, announced two weeks ago, appears to solve one of the longstanding impediments to companies keeping the IBM i at the center of their computing universe—access to non-DB2 databases.


Advertorial - PowerTech
Partner TechTip: Is Your IBM i "House" Built on a Solid Foundation?

PowerTech Compliance Monitor 3 lets you preview the effect of security level changes.

robin_tatamWritten by Robin Tatam

Each year, PowerTech's popular "State of IBM i Security" study reports on the assigned value of the IBM security system value, QSECURITY. While many systems now are running at the IBM recommended minimum level of 40, there are still numerous organizations that are running at level 30 and even (gasp!) level 20.


MC SCBG - Featured Product

Maxava HA Enterprise+ offers comprehensive High Availability and Disaster Recovery readiness for an IBM i application. Designed for complex environments and organizations serious about their business continuity. Real-time data replication and unlimited concurrent apply processes means no backlog of changes in a disaster and the ability to do a recovery in minutes. Advanced features including maxView Manager, provide enhanced control and visibility over your environment – wherever you are.


  • Remote role swap capability – The new maxView Manager tool enables remote monitoring, management and the ability to perform a role swap on command from a mobile device by utilizing our powerful and proprietary Command Scripting functionality remotely. So in the event of a failure, activating a switch to the back-up server is within your control.
  • Replication across QDLS, data, objects, IFS, and MQ Series.
  • Command Scripting Function – This flexible, smart and simple free format command scripting tool supports all native IBM i commands. Object list sets can be defined and run from a single command - no compiling required. So whether for a migration, one-off event, application specific, role swap or other activities, the scripting function provides simple management with logging and error handling capabilities.
  • Easy administration of the HA solution from a green screen, superior GUI or from a remote web ready device such as a PC or smartphone.
  • Flexibility and functionality - Maxava HA Enterprise+ is fully spec’d with an extensive range of functionality that includes enhanced auditing, autonomics, spool file replication, extensive configuration and management tools – yet still runs extremely quickly and efficiently.

Learn more about Maxava and its high availability and disaster recovery software solutions for IBM i systems here.



In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor