IBM Systems Magazine, Mainframe - March/April 2017 - 53


CPU and increasing IBM
z Systems* Integrated Information Processor offload for specific
utilities. RUNSTATS and UNLOAD
can be run with the REGISTER NO
option to eliminate data sharing
overhead. For FlashCopy*, managing the operation is improved
by allowing for multiple Data
Facility Storage Management
Subsystem copy pool support.
Messages related to the FlashCopy
feature can now be allocated
and reviewed in specific data
sets, rather than milling through
thousands or millions of lines of
hierarchical storage management
output. Storage and management
classes for system managed storage are now honored in the TEMPLATE statement for FlashCopy
image copy. RUNSTATS offers the
option to no longer invalidate
cache for dynamic statements.
The majority of DB2 performance-related problems reported
are caused by skewed statistics.
For example, column GENDER
for a table has a skew of 90
percent men and 10 percent
women. RUNSTATS TABLE(ALL)
INDEX(ALL), without additional
options for column GENDER, will
result in an index not being used
for GENDER. IBM Data Studio
and IBM InfoSphere* Optim*
Query Workload Tuner provide
the Workload Statistics Advisor,
which-based on an SQL-specific
statement(s) with data skew-will
display and, if requested, execute
a specific RUNSTATS statement
that will resolve the skew. DB2 12
allows this to be automated, so
additional tools aren't required;
rather, RUNSTATS can utilize the
USE PROFILE option to resolve
data skew.

database management systems
in the industry.
DB2 for z/OS consistently
provides best of breed for the
long-standing RAS and strength
of the IBM z* platform. Not
all of the rich and incredible

DB2 12 features are included
in this article. Learn where to
find other enhancements at
ibm.co/2ixOs5K. Because of continuous delivery, more will come
in the near future without having
to wait for a new DB2 version.

Ensure Your Company is
Not Fodder for Social Media
Wednesday, April 26  10 PT / Noon CT / 1 ET
Dynamic Mainframe Systems
Management to the Rescue!
Things are going well when suddenly your company
is the subject of unflattering press, pilloried in social
media for failing to meet customer expectations. Having digital customers ups the ante for the mainframe.
Existing thresholds and passive monitoring will not
help you meet digital engagement service expectations. A dynamic approach to mainframe systems
management is the answer.
Learn how:

% Analytics-guided analysis can spot
potential problems
% Dynamic automatic responses deliver
service quality at lowest cost
% Intelligent activity based thresholds ensure
you are alerted to issues that matter
% Alarm management and smart alarms
surfaces real problems
% Truly innovative systems management
keeps pace with digital business

FEATURING:

G. Jay Lipovich
Principal Product Manager,
BMC Software

Competitive Features
DB2 12 has kept up with great
advances in the industry, such
as cloud, mobile and analytics,
while providing one of the best

Register Today: webcasts.com/ibmsystemsmag
sponsored advertising content

ibmsystemsmag.com MARCH/APRIL 2017 // 53

pg 50-53.indd 5

2/7/17 2:12 PM


http://ibm.co/2ixOs5K https://event.webcasts.com/starthere.jsp?ei=1137751 http://www.webcasts.com/ibmsystemsmag http://www.ibmsystemsmag.com

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - March/April 2017

Table of Contents
Editor's Desk: Ahead of the Times
Techbits: Cognitive Customer Engagement
Partner PoV: Keep Data Out of Danger: Use the right tools to implement your large-object strategy
Currents: A Layered Approach: Using microservices on z Systems with CICS improves flexibility and reliability
IT Today: Choosing the Right Cloud: What to consider when using a managed service provider
R&D: Move Along: IBM Research and partners help traffic run smoothly in Madrid
Trends: How to Improve Your Sales Skills: Tips for techies on showing the value of their services
Feature: Strength in Collaboration: Linux on z Systems accelerates new and traditional workloads
Feature: Community Computing: The Open Mainframe Project expands educational opportunities for Linux on z Systems users
TECH Showcase: Shift-Left Testing Improves Success: Automated testing in the DevOps cycle improves quality and reduces risk
Tech Corner: Database Development: IBM DB2 V12 enhances and integrates data for cloud, mobile and analytics
Solutions: SMART TS XL V8.0, IN-COM Data Systems; Tubes, Macro 4; CleverView for TCP/IP on Linux V2.5, AES
Stop Run: A Global View: Computer science and astrophysics prove a natural fit
Reference Point - Global Events, Education, Resources for Mainframe
2017 Mainframe Solutions Edition
IBM Systems Magazine, Mainframe - March/April 2017 - Intro
IBM Systems Magazine, Mainframe - March/April 2017 - Cover1
IBM Systems Magazine, Mainframe - March/April 2017 - Cover2
IBM Systems Magazine, Mainframe - March/April 2017 - 1
IBM Systems Magazine, Mainframe - March/April 2017 - Table of Contents
IBM Systems Magazine, Mainframe - March/April 2017 - 3
IBM Systems Magazine, Mainframe - March/April 2017 - 4
IBM Systems Magazine, Mainframe - March/April 2017 - 5
IBM Systems Magazine, Mainframe - March/April 2017 - Editor's Desk: Ahead of the Times
IBM Systems Magazine, Mainframe - March/April 2017 - 7
IBM Systems Magazine, Mainframe - March/April 2017 - Techbits: Cognitive Customer Engagement
IBM Systems Magazine, Mainframe - March/April 2017 - 9
IBM Systems Magazine, Mainframe - March/April 2017 - 10
IBM Systems Magazine, Mainframe - March/April 2017 - 11
IBM Systems Magazine, Mainframe - March/April 2017 - Partner PoV: Keep Data Out of Danger: Use the right tools to implement your large-object strategy
IBM Systems Magazine, Mainframe - March/April 2017 - 13
IBM Systems Magazine, Mainframe - March/April 2017 - Currents: A Layered Approach: Using microservices on z Systems with CICS improves flexibility and reliability
IBM Systems Magazine, Mainframe - March/April 2017 - 15
IBM Systems Magazine, Mainframe - March/April 2017 - 16
IBM Systems Magazine, Mainframe - March/April 2017 - 17
IBM Systems Magazine, Mainframe - March/April 2017 - IT Today: Choosing the Right Cloud: What to consider when using a managed service provider
IBM Systems Magazine, Mainframe - March/April 2017 - 19
IBM Systems Magazine, Mainframe - March/April 2017 - 20
IBM Systems Magazine, Mainframe - March/April 2017 - 21
IBM Systems Magazine, Mainframe - March/April 2017 - R&D: Move Along: IBM Research and partners help traffic run smoothly in Madrid
IBM Systems Magazine, Mainframe - March/April 2017 - 23
IBM Systems Magazine, Mainframe - March/April 2017 - Trends: How to Improve Your Sales Skills: Tips for techies on showing the value of their services
IBM Systems Magazine, Mainframe - March/April 2017 - 25
IBM Systems Magazine, Mainframe - March/April 2017 - 26
IBM Systems Magazine, Mainframe - March/April 2017 - 27
IBM Systems Magazine, Mainframe - March/April 2017 - Feature: Strength in Collaboration: Linux on z Systems accelerates new and traditional workloads
IBM Systems Magazine, Mainframe - March/April 2017 - 29
IBM Systems Magazine, Mainframe - March/April 2017 - 30
IBM Systems Magazine, Mainframe - March/April 2017 - 31
IBM Systems Magazine, Mainframe - March/April 2017 - 32
IBM Systems Magazine, Mainframe - March/April 2017 - 33
IBM Systems Magazine, Mainframe - March/April 2017 - Feature: Community Computing: The Open Mainframe Project expands educational opportunities for Linux on z Systems users
IBM Systems Magazine, Mainframe - March/April 2017 - 35
IBM Systems Magazine, Mainframe - March/April 2017 - 36
IBM Systems Magazine, Mainframe - March/April 2017 - 37
IBM Systems Magazine, Mainframe - March/April 2017 - 38
IBM Systems Magazine, Mainframe - March/April 2017 - 39
IBM Systems Magazine, Mainframe - March/April 2017 - 40
IBM Systems Magazine, Mainframe - March/April 2017 - 41
IBM Systems Magazine, Mainframe - March/April 2017 - 42
IBM Systems Magazine, Mainframe - March/April 2017 - 43
IBM Systems Magazine, Mainframe - March/April 2017 - 44
IBM Systems Magazine, Mainframe - March/April 2017 - TECH Showcase: Shift-Left Testing Improves Success: Automated testing in the DevOps cycle improves quality and reduces risk
IBM Systems Magazine, Mainframe - March/April 2017 - 46
IBM Systems Magazine, Mainframe - March/April 2017 - 47
IBM Systems Magazine, Mainframe - March/April 2017 - 48
IBM Systems Magazine, Mainframe - March/April 2017 - 49
IBM Systems Magazine, Mainframe - March/April 2017 - Tech Corner: Database Development: IBM DB2 V12 enhances and integrates data for cloud, mobile and analytics
IBM Systems Magazine, Mainframe - March/April 2017 - 51
IBM Systems Magazine, Mainframe - March/April 2017 - 52
IBM Systems Magazine, Mainframe - March/April 2017 - 53
IBM Systems Magazine, Mainframe - March/April 2017 - 54
IBM Systems Magazine, Mainframe - March/April 2017 - Solutions: SMART TS XL V8.0, IN-COM Data Systems; Tubes, Macro 4; CleverView for TCP/IP on Linux V2.5, AES
IBM Systems Magazine, Mainframe - March/April 2017 - Stop Run: A Global View: Computer science and astrophysics prove a natural fit
IBM Systems Magazine, Mainframe - March/April 2017 - Cover3
IBM Systems Magazine, Mainframe - March/April 2017 - Cover4
IBM Systems Magazine, Mainframe - March/April 2017 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - March/April 2017 - 2017 Mainframe Solutions Edition
IBM Systems Magazine, Mainframe - March/April 2017 - SE2
IBM Systems Magazine, Mainframe - March/April 2017 - SE3
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20191112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/relevantz_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2019mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20181112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2018mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20171112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_sesupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_linuxsupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20161112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/MainframeSecurity
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20151112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910_se
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910
http://www.ibmsystemsmagmainframedigital.com/MFSkills
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506_supp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20141112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_gt_201405
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/BigData
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20131112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20121112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/buyersguide2013
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/ibmsystems_mainframe_2012bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20111112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20101112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910_bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20091112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090506
http://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
http://www.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
http://www.nxtbookMEDIA.com