IBM Systems Magazine, Mainframe - May/June 2016 - 40

TECH CORNER

ENVIRONMENT Integration
IBM DB2 on z/OS V2.2 features space and storage enhancements

T

his article outlines IBM DB2* enhanced capabilities with z/OS* V2.2,
including easier movement and updates, more data set functions, and
space and storage improvements. Part I of this article, "Database System
Synergy" in the March/April issue (bit.ly/1Vif75W), highlights some of the
features z/OS 2.1 provides to DB2 for z/OS.

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.

Easier Movement
There was a time-long ago, when
an IPL was required to add or
delete an entry-when incorrectly
updating the SYS1.PARMLIB
subsystem name (SSN) table
would require an IPL. Most
customers perform IPLs with
much less frequency, so it can
take a while for an opportunity to
occur to add a new DB2 subsystem
or fix an entry for one in the SSN
table. Entries can now be added
dynamically, but with z/OS V2.2
you can also delete an entry using
the SETSSI command.
Customers using FlashCopy*
probably notice that dumping
a large copy pool can take a
considerable amount of time
because all work is done from
one LPAR. This includes dump
(command, auto and fast
replication) processing. z/OS
V2.2 now has a new SETSYS
command to distribute dump
work across all hosts in a
Sysplex-wide common dump

40 // MAY/JUNE 2016 ibmsystemsmag.com

queue. This allows hierarchical
storage management (HSM) to
distribute workloads across host
members in an HSMplex, and
the new architecture allows for
flexible configurations. The end
result is the potential for the
dump process to complete faster
and possibly allow for FlashCopy
to be executed more often.
The class transition function
in the management class
debuted in z/OS V2.1, allowing
transition of data between tiers
and even down to the HSM
migration level. For example,
a DB2 partition that won't be
used frequently after 100 days
is transitioned from SSD/Flash
or HDD to a cheaper Serial
ATA device. After 365 days,
transition the data set to an
HSM migration level 2 tape.
This enhancement allows for
cheaper, more efficient use of
disk and tape. With z/OS 2.1,
the class transition function
is limited to automatic space

management processing. With
z/OS V2.2, the various MIGRATE
commands are enhanced to
support class transitions at the
data set, volume and storage
group level.
Along with this change, the
MIGRATE command can be used
with the new STORAGEGROUP
keyword to initiate migration
for all volumes within a storage
group in parallel. Up to 30
storage groups may be specified.
This is significant for DB2
because it allows for such things
as data sets in storage groups
that contain image copy or
archive log data sets to be created
on disk and then migrated
to tape via the MIGRATE
STORAGEGROUP command.

Data Set Improvements
The Data Facility Storage
Management Subsystem class
transition function can now
move data laterally in the same
tier of storage in addition to


http://www.bit.ly/1Vif75W http://www.ibmsystemsmag.com

IBM Systems Magazine, Mainframe - May/June 2016

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - May/June 2016

Table of Contents
Editor's Desk: Flexible and agile environment
IBM Perspective: Elevating open source for the enterprise
Partner PoV: New information about threats in the z/OS system improves performance
The new IBM z13 can consolidate Linux workloads at a lower cost
Focus on Storage: IBM Spectrum Storage Suite offers a new way of licensing storage software
Cover Story: Achieving An Advantage: Linux on z Systems enables the API economy and microservices while enhancing hybrid cloud solutions
Feature: A Better Option: Businesses see an advantage to using Linux on z Systems over scale-out servers
Tech Showcase: CISOs can mitigate mobile security fears and prevent issues in the workplace
Tech Corner: IBM DB2 on z/OS V2.2 features space and storage ehancements
Administrator: IBM Multi-Factor Authentication fo z/OS helps maintain a secure infrastructure
Solutions: Universal Data Manager; OpenLegacy V3.0
Stop Run: 19-year-old mainframe enthusiast installs a z890 in his parents' basement
Reference Point - Global Events, Education, Resources for Mainframe
2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - May/June 2016 - Intro
IBM Systems Magazine, Mainframe - May/June 2016 - Cover1
IBM Systems Magazine, Mainframe - May/June 2016 - Cover2
IBM Systems Magazine, Mainframe - May/June 2016 - 1
IBM Systems Magazine, Mainframe - May/June 2016 - Table of Contents
IBM Systems Magazine, Mainframe - May/June 2016 - 3
IBM Systems Magazine, Mainframe - May/June 2016 - 4
IBM Systems Magazine, Mainframe - May/June 2016 - 5
IBM Systems Magazine, Mainframe - May/June 2016 - Editor's Desk: Flexible and agile environment
IBM Systems Magazine, Mainframe - May/June 2016 - 7
IBM Systems Magazine, Mainframe - May/June 2016 - IBM Perspective: Elevating open source for the enterprise
IBM Systems Magazine, Mainframe - May/June 2016 - Partner PoV: New information about threats in the z/OS system improves performance
IBM Systems Magazine, Mainframe - May/June 2016 - 10
IBM Systems Magazine, Mainframe - May/June 2016 - The new IBM z13 can consolidate Linux workloads at a lower cost
IBM Systems Magazine, Mainframe - May/June 2016 - 12
IBM Systems Magazine, Mainframe - May/June 2016 - 13
IBM Systems Magazine, Mainframe - May/June 2016 - 14
IBM Systems Magazine, Mainframe - May/June 2016 - Focus on Storage: IBM Spectrum Storage Suite offers a new way of licensing storage software
IBM Systems Magazine, Mainframe - May/June 2016 - 16
IBM Systems Magazine, Mainframe - May/June 2016 - 17
IBM Systems Magazine, Mainframe - May/June 2016 - Cover Story: Achieving An Advantage: Linux on z Systems enables the API economy and microservices while enhancing hybrid cloud solutions
IBM Systems Magazine, Mainframe - May/June 2016 - 19
IBM Systems Magazine, Mainframe - May/June 2016 - 20
IBM Systems Magazine, Mainframe - May/June 2016 - 21
IBM Systems Magazine, Mainframe - May/June 2016 - Feature: A Better Option: Businesses see an advantage to using Linux on z Systems over scale-out servers
IBM Systems Magazine, Mainframe - May/June 2016 - 23
IBM Systems Magazine, Mainframe - May/June 2016 - 24
IBM Systems Magazine, Mainframe - May/June 2016 - 25
IBM Systems Magazine, Mainframe - May/June 2016 - 26
IBM Systems Magazine, Mainframe - May/June 2016 - Tech Showcase: CISOs can mitigate mobile security fears and prevent issues in the workplace
IBM Systems Magazine, Mainframe - May/June 2016 - 28
IBM Systems Magazine, Mainframe - May/June 2016 - 29
IBM Systems Magazine, Mainframe - May/June 2016 - 30
IBM Systems Magazine, Mainframe - May/June 2016 - 31
IBM Systems Magazine, Mainframe - May/June 2016 - 32
IBM Systems Magazine, Mainframe - May/June 2016 - 33
IBM Systems Magazine, Mainframe - May/June 2016 - 34
IBM Systems Magazine, Mainframe - May/June 2016 - 35
IBM Systems Magazine, Mainframe - May/June 2016 - 36
IBM Systems Magazine, Mainframe - May/June 2016 - 37
IBM Systems Magazine, Mainframe - May/June 2016 - 38
IBM Systems Magazine, Mainframe - May/June 2016 - 39
IBM Systems Magazine, Mainframe - May/June 2016 - Tech Corner: IBM DB2 on z/OS V2.2 features space and storage ehancements
IBM Systems Magazine, Mainframe - May/June 2016 - 41
IBM Systems Magazine, Mainframe - May/June 2016 - 42
IBM Systems Magazine, Mainframe - May/June 2016 - 43
IBM Systems Magazine, Mainframe - May/June 2016 - Administrator: IBM Multi-Factor Authentication fo z/OS helps maintain a secure infrastructure
IBM Systems Magazine, Mainframe - May/June 2016 - 45
IBM Systems Magazine, Mainframe - May/June 2016 - 46
IBM Systems Magazine, Mainframe - May/June 2016 - Solutions: Universal Data Manager; OpenLegacy V3.0
IBM Systems Magazine, Mainframe - May/June 2016 - Stop Run: 19-year-old mainframe enthusiast installs a z890 in his parents' basement
IBM Systems Magazine, Mainframe - May/June 2016 - Cover3
IBM Systems Magazine, Mainframe - May/June 2016 - Cover4
IBM Systems Magazine, Mainframe - May/June 2016 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - May/June 2016 - 2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - May/June 2016 - SE2
IBM Systems Magazine, Mainframe - May/June 2016 - SE3
IBM Systems Magazine, Mainframe - May/June 2016 - SE4
IBM Systems Magazine, Mainframe - May/June 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