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


TECH CORNER

pages increased to 280 trillion.
Increasing DSSIZE is supported at
the partition level and no longer requires a REORG, however
decreasing DSSIZE does. A new
DSSIZE support exists for indexes.
Attribute modifications by partition and schema changes are
externalized using REORG PART.
Online schema improvements
are always a DBA's favorite for
each DB2 release. DBAs can now
insert a new partition between
existing partitions. ALTER INDEX
COMPRESS YES, which allows
the user to alter an index to use
compression, will no longer
cause an outage by putting the
index in rebuild pending. This
statement is now online deferred.
Another enhancement allows
multiple conflicting deferred

ALTER statements at the column level, which are materialized through online REORG to
be mixed without issue. Also,
the TRANSFER OWNERSHIP
statement now allows you to
transfer ownership to a new
AUTHID or role without having
to first unload, drop or recreate
the object.

Migration and
Delivery Improvements
Migration to DB2 12 has
changed considerably. The
enabling-new-function mode
stage has been eliminated,
and new-function mode is now
activated by new command
-ACTIVATE FUNCTION LEVEL.
APPLCOMPAT and fallback rules
continue to apply. In DB2 11,

D
DB2 12 offers

2x
speedup for
query workload
and

100x
more speed for
targeted queries

conversion of the bootstrap data
set from a 6-byte to a 10-byte
relative byte address was voluntary but is mandatory for DB2 12.
Basic row format is deprecated
with the ZPARM and REORG
options removed. Temporal realtime statistics (RTS) are integrated
into the DB2 catalog, although the
enablement is optional. This will
allow clients to trend information,
such as data set size, in the RTS.
DB2 direction also aligns with
the mainframe software direction
of continuous delivery. DB2 12
provides continuous delivery,
whereby clients can apply new
enhancements without waiting
for the traditional DB2 three-year
software cycle for a new version.
DB2 utilities benefit from
improved efficiency by reducing

Featuring content from

On-demand enterprise IT education
hand-picked by experts.

Now
featuring
video
recordings!

SHARE.org/SHARElive

52 // MARCH/APRIL 2017 ibmsystemsmag.com

pg 50-53.indd 4

2/7/17 2:12 PM


http://www.SHARE.org/SHARElive 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