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

January 12, 2015 | Volume 10 Issue 1


TOP STORY: DB2 11: The Ultimate Database for Cloud Analytics & Mobile on IBM i
FEATURED ARTICLE: Data Access on IBM i: Is It Time to Upgrade from Query/400?
NEWS HIGHLIGHT: TL Ashford Introduces TLA Forms
WHITE PAPER: DR Strategy Guide from Maxava
MC PRESS BOOKSTORE: New Year's Sale: EXTRA 15% OFF the Top 15 Bestsellers for 2014
EVENT: Discover Modernized Data with SEQUEL
MC VIDEO PORTAL: The 12 Sections of PCI DSS and How each Relates to the IBM i Community

Sponsor - The MC Press Bookstore

Get the latest and greatest advice from the DB2 for z/OS gurus! DB2 11: The Ultimate Database for Cloud, Analytics, and Mobile provides essential advice and explanations to ensure a successful upgrade--including feedback from early customer experiences. This book describes new DB2 11 features that can help you respond cost-effectively to the data explosion resulting from mobile applications, cloud computing, social media, and smart devices. Understand the new functions in DB2 11, plan your migration strategy, and learn about important new support for application compatibility. Get your copy today!


Feature Article - Database
DB2 11: The Ultimate Database for Cloud, Analytics, and Mobile on IBM z Systems

IBM database experts delineate the analytics improvements in DB2 11 for z/OS.

john campbellWritten by John Campbell, Gareth Jones, and Surekha Parekh

Editor's Note: This article is an excerpt from the new book DB2 11: The Ultimate Database for Cloud, Analytics, and Mobile (MC Press, 2014).


In Version 11, IBM DB2 for z/OS makes it easier to bring analytic components closer to the core operational data—reducing latency, complexity, and costs while improving data quality and governance. Improved query, fast analytics, and reporting facilities can improve competitiveness, reduce risks, and aid confident decision-making with real-time data.


Feature Article - Database
Data Access on IBM i: Is It Time to Upgrade from Query/400?

Modern demands are placing greater pressure on organizations to develop their data-centric capabilities even further.

Written by SEQUEL Software

Editor's note: This article introduces the white paper "Transform Your Data Into Insight" available free at the MC White Paper Center.


For over 30 years, Query/400 has been the data access tool to generate reports easily from DB2 data—allowing access to insight like never before. While it continues to be sufficient for basic reporting functionality, most organizations are beginning to be challenged with the need to access and report on larger volumes of data. With business users asking for easy-to-access dashboards and reports to gain insight more easily, you might need to consider if it's time to upgrade from Query/400.


Sponsor - The MC Press Bookstore

Don't miss out! This is the hands-on guide to IBM's strategic language for IBM i. Database Design and SQL for DB2 delivers everything you need to know about database design and SQL. Author Jim Cooper gives you all the tips and techniques you need in one convenient place, whether you’re a beginner or an advanced developer. Includes real-life examples to help you hone your skills. The bonus companion website explains embedded SQL and explores client-side technologies.


MC White Paper Center

Don't miss these great Featured White Papers:

DR Strategy Guide from Maxava

Download your free copy of our DR Strategy Guide for IBM i before it’s too late.
Learn more about the evolution of disaster recovery, how disasters of various types can impact business and the strategies you can employ to minimize the risk of impact to your business by downloading our latest e-book today.
Your free copy of the DR Strategy Guide for IBM i will help uncover the secrets to ensuring your IBM i and your business is able to weather any storm – be it caused by human interruption or natural disaster.

  • How to best implement a disaster recovery strategy
  • The importance of testing your Disaster Recovery Plan and keeping it up to date
  • How to perform scheduled back-ups without bringing down your business
  • The benefits of the Cloud and how it can work for you
  • What to look for in a Disaster Recovery Provider

Element Break

10 Facts You Need To Know About Laser Check Printing On Your IBM i

This whitepaper is a must read for anyone that is considering moving to Laser Check printing or anyone that has considered moving to laser check printing in the past and thought it was too expensive or too much trouble. Included in this white paper:

  • A supply List What to look for in laser check software
  • 6 Steps to Getting Bank Approval of your checks
  • 10 myths about laser check printing, find out if they are fact or fiction

Laser check printing is secure and easier to maintain than traditional pre-printed check printing. With a few quick steps, set-up is simple. You do not need to purchase any special equipment and it is very easy to maintain. Laser check printing can save thousands, potentially hundreds of thousands of dollars in supplies and labor, depending on the size of your company. Let this Free whitepaper by DRV Tech answer your questions about laser check printing on the IBM i.

Element Break

PCI and What it means to IBM i

While one may think that PCI is a thing of the past and that it’s already been implemented, major breaches (most notably of the Target PoS systems) have brought it back into focus. Some retailers are just now understanding how PCI applies to them and other organizations have started to accept credit cards when they didn’t in the past. To refresh everyone’s memory, here’s an overview of what PCI means to the IBM i community and what organizations that use an IBM i to store, process or access cardholder data need to be aware of.

Element Break

Virus Got You Down?

Does a virus have your server down? Perhaps it’s the latest worm, Trojan horse, buffer overflow or denial of service attack that’s got you or one of your servers down. While one of these bugs may be affecting one or more of your servers in your enterprise, it is highly unlikely that the server affected is a Power server running IBM i. IBM i may be running your core business applications or it may be hosting your web site or running Domino. Whatever its function within your enterprise IBM i has remained unaffected by virus and malware attacks. Why is that? Viruses and other ailments spread by infecting a host that is vulnerable. Let’s take a look at how IBM i and the applications running on it can remain unscathed by the viruses and malware that are so prevalent today. In this white paper, Carol Woodbury of SkyView Partners defines each “ailment” and then describe the defenses and protection mechanisms provided by IBM i to ward off the attack.

Element Break

How to Build a Requirements Roadmap for Proactive IBM i System Monitoring

Implementing proactive system monitoring in your IBM i environment begins with planning. The effectiveness of automated monitoring solutions should be evaluated based on the degree of visibility they can offer to potential problems, the time they save, and the flexibility they offer in meeting the specific views and requirements of your existing and developing network.
Your proactive monitoring solution should be able to anticipate repeat issues based on your system demands, applications, throughput, and configuration, as well as provide fast access to information that will pinpoint the cause of unforeseen issues and those that are otherwise difficult to isolate.
For system administrators and managers who are looking for a practical guide to help maximize a new or existing proactive approach to system and message monitoring.
Download this white paper to learn:

  • Information on must-have monitors
  • Shortcuts to greater efficiency
  • Checklists of requirements for a customized roadmap

Element Break

Plus Choose From The Full Selection in the MC Press White Paper Center


*Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.

The MC Resource Centers bring you the widest selection of white papers, software, webcasts and more for you to choose from and at MC Press we’re all about choice. We’re even giving one lucky person the opportunity to choose their own prize in our “It’s All About Choice” contest for a $250 Best Buy gift card.  Visit the MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security,  and MC Disaster Recovery Centers today and select as many of the FREE offerings you would like to receive. While there, enter the contest and you may just win a $250 Best Buy gift card!

Have a White Paper you would like to list? click here or call (208) 629-7275 Ext.504 for information.


In the News

Vendors:  Have a press release to share?  send it to MC Press

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor



MC Video Portal

MC Video Portal

The 12 Sections of PCI DSS and How each Relates to the IBM i Community


In this session, Carol Woodbury draws on her experience consulting with SkyView Partners' clients and helping them with their PCI DSS implementation and compliance requirements. Carol explains each of the 12 sections of the Payment Card Industry's Data Security Standards (PCI DSS) and describes specifically how each relates to the IBM i community.