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

TECH CORNER

and allow for a consistent copy of
the DB2 log copy pool whereby a
conditional restart isn't required.
Integrated Coupling Facility
(ICF) catalogs are an essential
part of the DB2 environment.
One of the most commonly
missed availability and
performance inhibiters for DB2
is the placement and type of ICF
catalog. Record-level sharing
(RLS) for ICF catalogs should
reduce most contention issues
and is expected to remove most
size and performance-related
reasons for splitting ICF catalogs
in a Parallel Sysplex*. At times,
RLS will provide better batch job
performance as well as reduce
the amount of time for REORGs
during the switch phase when
many data sets are involved. RLS
is a replacement for other ICF
catalog performance features
such as the Enhanced Catalog
Sharing (ECS) or virtual lookaside
facility/in-storage cache caching.
One major requirement is a
coupling facility-even for a
standalone, non-data sharing
DB2 subsystem. While on the
subject of ICF catalogs, CA
RECLAIM (introduced with z/OS
V1.12) is another option that
should be added for your DB2
technology-related ICF catalogs.
I can't remember how many
times I wished I had multiple
copies of a member (e.g., I have
member image copies (IC) and want
to make a change). I might create
IC1, IC2, etc. With partitioned
data set extended (PDSE) V2, I can
now have a PDSE with member
level recovery similar to using a
generation data group (GDG) data
set. The number of generations to
keep is specified in the ISPF, as is
the MAXGENS_LIMIT keyword in
IGDSMSxx and job control language
(JCL). Saving member IC will save a
generation for member IC.
If I have five generations
for member IC and want to go

More Resources
IBM Redbooks publication "z/OS
Version 2 Release 1 Technical Updates,
SG24-8140-00": ibm.co/1NUrNL1
IBM Redbooks publication "Summary
of Key Functions in z/OS V2.1, TIPS1217":
ibm.co/1Oz53DB

back to the -3 generation, this
is easily accomplished by using
either DSLIST or IBM Data Set
Commander for z/OS V8.1
(formerly known as IBM ISPF
Productivity Tool for z/OS), which
will show members as generations.
Some limitations exist: The data set
must be a PDSE V2 data set, and
command TSO EDIT cannot be used
for PDSEs. For this reason, the DB2
data set SDSNSAMP must remain a
partitioned data set (PDS) and can't
use this feature. Unfortunately,
this feature can't be used at this
time for such things as navigating
between versions of DSNTIJUZ
(ZPARMs). Another benefit of
PDSE V2 is freeing unused space,
which allows you to consolidate
directory pages when possible,
improve read performance and
reduce virtual storage utilization for
PDSE processing.

More Features
Your z/OS systems programmer
might talk to the DB2 teams
about zEnterprise* Data
Compression (zEDC), which
allows for many compression
advancements and requires z/OS
V2.1. Unfortunately, at the time
of the writing of this article, DB2
can't use most zEDC features.
DB2 tables and indexes aren't
compressed using zEDC, and DB2
tools and utilities can't use zEDC.
Although zEDC allows System
Management Facility (SMF)
data for log stream to have a 4:1
compression, the OMEGAMON*

44 // MARCH/APRIL 2016 ibmsystemsmag.com

product for DB2 can't decompress
the records and should be avoided
for DB2 data. ZPARM SMFCOMP
can still be used for standard
compression, allowing for almost
2:1 compression.
The only thing DB2 can
take advantage of at this time
using zEDC is compressing the
archive log data sets. Storage
Management Subsystem (SMS)
data class compression of
the archive log data sets is
still an alternative to zEDC
when using the attribute
COMPACT. Performance could
be a problem if the compressed
archive log data sets are being
read in any way other than
forward sequential. DB2 image
copies can take advantage of
standard compression as well,
but not zEDC. As a statement
of direction, DB2 12 (not yet
GA) should allow for zEDC to
compress Lob data sets.
At times, the GDG order is
important. By default, when
not specifying a number, the
0 generation is processed and
goes backward in order. As an
example, we want to process SMF
data to run a report for DB2 that is
date-sensitive. We believe the data
we need was generated a month
ago, and that's around the time of
the oldest GDG data set. You could
use a JCL concatenated list from
oldest to newest, but that would
be cumbersome and might miss
some data sets. You can now use
the GDGORDER JCL DD statement
keyword to change the order from
the oldest to the newest.
In z/OS V1.12, you could
delete members of a PDS or PDSE
but keep the actual data set by
executing IDCAMS. Members to
delete can be masked by using
a **, * or % (e.g., to delete all
members starting with DB29
followed by any character and
ending in TST from a PDS called
MY.DATASET, use DELETE


http://ibm.co/1NUrNL1 http://ibm.co/1Oz53DB 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