IBM Systems Magazine, Mainframe - March/April 2016 - 43

TECH CORNER

Database System SYNERGY
With z/OS V2.1, IBM DB2 features include automation and copy improvements

T

he incredible power and synergy of z/OS* processors and IBM storage
allow DB2* to be one of the best database systems in the industry. z/OS
V2 ushers in the modern era of computing for mobile, cloud, security,
and data and analytics.
John Iczkovits
is a senior IT
specialist with
IBM Advanced
Technical Support.
He provides
DB2 for z/OS
technical support
and consulting
services. His areas
of expertise include
DB2 data sharing,
performance
and availability.

Beginning with z/OS V2, new
releases typically come out every
two years. GA of z/OS 2.1 occurred
in September 2013, and V2.2
became available in September
2015. Although z/OS has many
great features, DB2 can't use all of
them at GA. Sometimes a PTF is
required, it's on the next version of
DB2 or it can't be used.
Careful analysis must be
completed before trying to use
a new feature. z/OS features
cross many products; this article
describes the V2.1 release
features specific to DB2 for z/OS,
and an article in the next issue
will outline features for z/OS
V2.2. Some changes have been
retrofitted into z/OS 1.13. Some
features won't be outlined in this
article (see "More Resources,"
page 44), such as a large number
of beneficial Interactive System
Productivity Facility (ISPF)
changes.

Install and Move Data
DB2 installations and migrations
can now be automated using
z/OS Management Facility.

This process isn't new to z/OS
systems programmers, and
there's a default workflow for
DB2. Setting up install/migration
of a subsystem can be done
once (e.g., with DB2A and, after
successful completion, using the
same process for DB2B, etc.),
thereby reducing the time it takes
to move through each subsystem.
DB2 data can be moved
between tiers using the Storage
Management Subsystem
management class's new
class transition accomplished
through Hierarchical Storage
Management's (HSM) space
management function. What's
new is that instead of HSM
moving DB2 data from disk
(Level 0) to HSM-owned ML1 or
ML2, data can be transitioned
to a lower tier before moving it
to ML2. This process interfaces
with both IBM's Easy Tier* disk
product and DB2.
If a data set resides on an SSD
but you want to transition it to a
nearline drive (i.e., demote the
data set) and eventually migrate
the data set to ML2, if not used

in a period of time, the transition
can occur in several ways. In this
example, use the class transition
to move the data from the SSD to
a slower tier after 100 days and
to ML2 if not used in 250 days:
1. Exits can be set up to
interface with DB2, and data
can be dynamically moved.
2. If the data set is open, go
through global resource
serialization (GRS) and
determine which DB2 owns
the data set.
3. Issue DB2 command STOP
to that data set.
4. Move the data set and issue
a START after successful
completion.
This process can reduce ROI by
leveraging lower-cost technology
while keeping the data available
to DB2.

Copy Improvements
Consistency groups are a new
feature that will help customers
using FlashCopy* technology.
These are intended for the DB2 logs

ibmsystemsmag.com MARCH/APRIL 2016 // 43


http://www.ibmsystemsmag.com

IBM Systems Magazine, Mainframe - March/April 2016

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

Table of Contents
Editor's Desk: A secure connection
Techbits: Sphere of influence
Infographic: Hybrid integration: Can you keep up?
Partner PoV: RACF needs complementary applications for total enterprise protection
R&D: IBM explores how affective computing can benefit society
IT Today: OpenStack solutions help address compliance needs and audit standards
Currents: Ponemon data breach study should encourage you to be proactive
Cover Story: The Future of Business: New IBM z13s and its growing ecosystem help clients unleash digital innovation with cloud agility and cybersecurity
Feature: The Mobile App Advantage: Real-world cases show how to maximize information to achieve results in the cognitive era
Tech Showcase: DevOps helps transform development practices to meet today's business demands
Tech Corner: With z/OS V2.1, IBM DB2 features include automation and copy improvements
Solutions: (E)JES V5.5; EasySMF; JE; Offline Access Recovery; SIEM Agent for IBM z/OS with IND$defender; SMA_RT V3.3
Stop Run: The Web's mainframe past isn't gone; it's archived on various sites
Reference Point - Global Events, Education, Resources for Mainframe
2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - March/April 2016 - Intro
IBM Systems Magazine, Mainframe - March/April 2016 - Cover1
IBM Systems Magazine, Mainframe - March/April 2016 - Cover2
IBM Systems Magazine, Mainframe - March/April 2016 - 1
IBM Systems Magazine, Mainframe - March/April 2016 - Table of Contents
IBM Systems Magazine, Mainframe - March/April 2016 - 3
IBM Systems Magazine, Mainframe - March/April 2016 - 4
IBM Systems Magazine, Mainframe - March/April 2016 - 5
IBM Systems Magazine, Mainframe - March/April 2016 - Editor's Desk: A secure connection
IBM Systems Magazine, Mainframe - March/April 2016 - 7
IBM Systems Magazine, Mainframe - March/April 2016 - Techbits: Sphere of influence
IBM Systems Magazine, Mainframe - March/April 2016 - Infographic: Hybrid integration: Can you keep up?
IBM Systems Magazine, Mainframe - March/April 2016 - Partner PoV: RACF needs complementary applications for total enterprise protection
IBM Systems Magazine, Mainframe - March/April 2016 - 11
IBM Systems Magazine, Mainframe - March/April 2016 - 12
IBM Systems Magazine, Mainframe - March/April 2016 - R&D: IBM explores how affective computing can benefit society
IBM Systems Magazine, Mainframe - March/April 2016 - 14
IBM Systems Magazine, Mainframe - March/April 2016 - 15
IBM Systems Magazine, Mainframe - March/April 2016 - IT Today: OpenStack solutions help address compliance needs and audit standards
IBM Systems Magazine, Mainframe - March/April 2016 - 17
IBM Systems Magazine, Mainframe - March/April 2016 - 18
IBM Systems Magazine, Mainframe - March/April 2016 - 19
IBM Systems Magazine, Mainframe - March/April 2016 - Currents: Ponemon data breach study should encourage you to be proactive
IBM Systems Magazine, Mainframe - March/April 2016 - 21
IBM Systems Magazine, Mainframe - March/April 2016 - 22
IBM Systems Magazine, Mainframe - March/April 2016 - 23
IBM Systems Magazine, Mainframe - March/April 2016 - Cover Story: The Future of Business: New IBM z13s and its growing ecosystem help clients unleash digital innovation with cloud agility and cybersecurity
IBM Systems Magazine, Mainframe - March/April 2016 - 25
IBM Systems Magazine, Mainframe - March/April 2016 - 26
IBM Systems Magazine, Mainframe - March/April 2016 - 27
IBM Systems Magazine, Mainframe - March/April 2016 - 28
IBM Systems Magazine, Mainframe - March/April 2016 - 29
IBM Systems Magazine, Mainframe - March/April 2016 - Feature: The Mobile App Advantage: Real-world cases show how to maximize information to achieve results in the cognitive era
IBM Systems Magazine, Mainframe - March/April 2016 - 31
IBM Systems Magazine, Mainframe - March/April 2016 - 32
IBM Systems Magazine, Mainframe - March/April 2016 - 33
IBM Systems Magazine, Mainframe - March/April 2016 - 34
IBM Systems Magazine, Mainframe - March/April 2016 - Tech Showcase: DevOps helps transform development practices to meet today's business demands
IBM Systems Magazine, Mainframe - March/April 2016 - 36
IBM Systems Magazine, Mainframe - March/April 2016 - 37
IBM Systems Magazine, Mainframe - March/April 2016 - 38
IBM Systems Magazine, Mainframe - March/April 2016 - 39
IBM Systems Magazine, Mainframe - March/April 2016 - 40
IBM Systems Magazine, Mainframe - March/April 2016 - 41
IBM Systems Magazine, Mainframe - March/April 2016 - 42
IBM Systems Magazine, Mainframe - March/April 2016 - Tech Corner: With z/OS V2.1, IBM DB2 features include automation and copy improvements
IBM Systems Magazine, Mainframe - March/April 2016 - 44
IBM Systems Magazine, Mainframe - March/April 2016 - 45
IBM Systems Magazine, Mainframe - March/April 2016 - Solutions: (E)JES V5.5; EasySMF; JE; Offline Access Recovery; SIEM Agent for IBM z/OS with IND$defender; SMA_RT V3.3
IBM Systems Magazine, Mainframe - March/April 2016 - 47
IBM Systems Magazine, Mainframe - March/April 2016 - Stop Run: The Web's mainframe past isn't gone; it's archived on various sites
IBM Systems Magazine, Mainframe - March/April 2016 - Cover3
IBM Systems Magazine, Mainframe - March/April 2016 - Cover4
IBM Systems Magazine, Mainframe - March/April 2016 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - March/April 2016 - 2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - March/April 2016 - SE2
IBM Systems Magazine, Mainframe - March/April 2016 - SE3
IBM Systems Magazine, Mainframe - March/April 2016 - SE4
IBM Systems Magazine, Mainframe - March/April 2016 - SE5
http://www.ibmsystemsmagmainframedigital.com/mspcomm/ibmsystemsmag/ibmsystems_mainframe_20200708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2020mfse
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
https://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
https://www.nxtbookmedia.com