MC Press Online

Tuesday, Jan 17th

Last updateTue, 17 Jan 2017 5pm

You are here: Home ARTICLES Analytics & Cognitive

Analytics & Cognitive

Big Data for Small Companies

Steve Pitcher

As a small company, how do we get value out of big data?

Written by Steve Pitcher

Big data. The tech world news surrounding big data is dominated by what the larger players are doing. They of course are flagship examples for big savings and big revenue.

A great example of a company using big data would be Kroger. The average return rate for coupons is 3.7 percent, according to the Direct Marketing Association. Kroger does 71 percent. They target each customer individually and market to them as such as part of a quarterly coupon mailer:

Read more ...

Six Key Drivers That Push Your Business Forward

Integration can be a competitive weapon that can positively impact the bottom line through encouraging revenue velocity, cost containment, risk mitigation, and long-term customer satisfaction.

mark denchyWritten by Mark Denchy


Business is moving faster and faster, as customers and business partners demand more automated interactions. IT is no longer supporting the business; it is becoming the core of the business. Digital transformation of businesses requires us to connect and interact with both customers and suppliers in new and unexpected ways.

Read more ...

TechTip: IFS Containers Part 3, Installing Open Source from the Internet

One of the core tenets of open source is freedom to obtain and use software. Now it's time to see that benefit in action.

aaron bartellWritten by Aaron Bartell

In the first article of this series, we learned about how IFS Containers could be manually created by copying things into a new directory and then running the chroot command against that directory. This was a laborious process that would cause the technology to not be used unless some amount of automation was introduced. In the second article, I introduced the IBM i Chroot (ibmichroot) project, which addresses the automation of creating IFS Containers in a matter of minutes and even more important, uniformity. In this article, we will navigate through the other core feature of the IBM i Chroot project: package installation.

Read more ...

TechTip: C# for RPGers - Introducing Lists

Lists are a special type of “thing” in C#; they have no parallel in RPG. This is most unfortunate, because lists are awesome!

rafael victoria preiraWritten by Rafael Victória-Pereira

The last couple of TechTips introduced Arrays and explained the foreach loop. This kind of sets the stage for the List data type. You can think of a List as an Array with all the bells and whistles and none of its limitations. For instance, when you define an Array, you have to define its size. That value is (more or less) definitive, because the memory will be statically allocated to store the variable. Lists, however, are dynamically allocated, which means that you don’t have to specify the size of the List. Actually, you can’t specify it. Instead, you’re able to specify the initial capacity, but even that is optional.

Read more ...

TechTip: DB2 for IBM i Services - The Practical

About six months ago, I talked about the relatively new DB2 for i Service tool and why it was pretty nifty. Now, let’s take a closer look at it and see how you actually use it.

david shireyWritten by David Shirey  

As I said in the previous tip on this topic, the DB2 for i Services developed by Scott Forstie’s team and being enhanced with every new technology refresh is another way to investigate what’s happening on your IBM i. Although we’re accustomed to doing this using a variety of very powerful system commands, the DB2 for i Service package provides a fresh, more flexible, and more sophisticated way of digging out this information.

Read more ...

TechTip: DB2 for i Optimization Strategies, Part 6

Avoid common SQL programming mistakes that can drag application performance.

Written by Michael Sansoterra

In this final installment of this DB2 for i coding series, I’ll discuss two items. First, I’ll examine a reason why a query that once performed well when it was first written might become lethargic as time passes. Second, I’ll discuss a way to potentially improve the performance of multi-row update statements. In the end, the lessons are how to avoid some common coding flaws that can take the wind out of your database sails.


Read more ...

Book Review: DB2 11 for z/OS Database Administration—Certification Study Guide

This is a well-written DB2 11 book that could easily stand on its own as a reference manual, not just a certification guide.

willie faveroReviewed by William (Willie) Favero

Are you thinking about taking the IBM certification test C2090-312—IBM Certified Database Administrator - DB2 11 DBA for z/OS? After all, it is being offered at no charge at the IBM World of Watson 2016 conference (formerly Insight) and IDUG EMEA 2016, both just around the corner, and at IDUG North America 2017 next spring, also only months away. If you are, you might be facing a bit of test anxiety, even if you know the exam topics well. For many people, the prospect of taking a test can cause them to start questioning their skills.

Read more ...

Partner TechTip: End the Scourge of Ugly Forms!

Modernizing your forms can have a positive impact on your company’s image.

mike schuettWritten by Mike Schuett

Are you one of the many programmers who cringes at the thought of creating or modifying forms on the IBM i? For programmers, working with forms ranks right up there with being mauled by a grizzly bear. Yet there is a value in generating great-looking forms. Your statements, invoices, and checks project an image of your company, and many forms produced today are, at best, difficult to read and, at worst, ugly. Great-looking forms are neither difficult nor expensive to implement. In fact, you can improve your company’s image, make producing forms more efficient, and save money while doing it!

Read more ...