IBM Systems magazine, IBM Z - May/June 2020 - 17

they to be found?
Which packages or versions
are really still required on the
Db2 side?
How can I be sure I still have
the correct DBRM member to
match my package version and
load module?

searched for within the application
module, which was an easy way to
match packages to modules. Unfortunately, today, there are various
ways of storing CONTOKENs, and
linking packages to corresponding
modules is not so easy.
So why check at all? Here's why:

To answer these questions,
developers must either start developing their own utilities or license
powerful vendor utilities to secure
an Agile way to be integrated in the
DevOps cycles.

Application Integrity and Cost
When migrating an application's set
of modules into productive systems, DBRMs and load modules are
involved. If they don't match, the
application will not function in your
production system. Depending on
the frequency of execution and importance of this application, the out
times could cause considerable cost.
The lower the number of package versions found in your catalog,
the easier you can steer your Db2
and reorganize vital parts of the
catalog. This leads to faster Db2
utilities.

*

*

Navigating Package Concerns
It's important to know which
packages are needed and which are
cluttering your database, affecting performance and availability.
To navigate package concerns,
build cross references of all module CSECTs and DBRM or package
names. This is the initial task for
checking which modules should
be checked at all. LOAD and DBRM
libraries can be located in various
ways. The fastest is via z/OS® Catalog
Search Interface (CSI) facilities.
These may be partitioned data
set (PDS) or partitioned data set
extended (PDSE) organized and require rapid processing, especially
when the PDSE libraries hold tens
of thousands of modules. IEWBUFF
facilities can be utilized to de-block
the load modules and then scan
24-, 31- and 64-bit applications to
ensure consistency. Some modules,
especially Java® technology-based
ones, can be extremely large and
require smart scanning routines.

Why Scan Packages
and Modules?
Why should we scan them and
what are we looking for? The magic
phrase is "consistency token"
(CONTOKEN). At the very beginning
of Db2, this was simply an 8-byte
character string representing a
timestamp similar value. It could be
1
2

Performance Reasons and Cost
BIND execution times, affected by
very large common Explain-type
tables full of data no longer required
compromise performance. The trick
is to identify the correct data and
keep it. Typically, one SQL statement,
when explained, could produce
between two and 200 rows, just in the
associated PLAN_TABLE. When we
consider all available Explain-type tables, one explained statement could
result in inserting more than 1,000
lines in up to 25 different tables.

Resolving Concerns and
Using Best Practices
Reducing the size and scope of the
Explain tables will help BIND steps
use less CPU and improve elapse
times and in turn, reduce cost.
Why BIND packages, when
the SQL was unchanged? If it is
because RUNSTATS values have
changed, then explicit BINDs will
also have the required effect and
change the access path strategy

https://www.itpro.co.uk/server/29990/why-the-mainframe-is-still-going-strong
https://dzone.com/articles/new-forrester-consulting-kpi-study-is-a-must-read

as required by Db2. Saving superfluous BIND steps can return vital
CPU capacities previously lost to
"runaway" package management.
When developing a package
management strategy, implement
the following best practices:
1. Analyze and perform inconsistency checks on all
CONTOKENs-regardless of
whether it originates from the
Db2 Catalog, a DBRM or within
a LOADLIB module
2. Locate all relevant LOADLIBs
and DBRMs, building the base
resources to check
3. Resolve all specified LOADLIBs
into module and related CSECT
names, together with all BINDer
timestamp information
4. Resolve all DBRM modules and
keep all header options for
comparison reasons-identifying empty and invalid contents
along the way
5. Build cross reference data
sets where package names
or Plan-DBRM names match
counter-parting LOADLIB and
DBRM names
6. Check inconsistencies and
optionally build reports, FREE
PACKAGE job input and set
condition codes as required
7. Include a cleanup utility to remove inconsistent
or non-required entries in
all PLAN_TABLEs and other Explain-type tables
8. Regenerate DBRM member(s)
from the catalog
9. Determine whether PACKAGE
BINDs can be avoided or
should be enforced when access paths improve
DevOps on the IBM Z platform is here. There are a lot of
fast-moving pieces, but if you
keep these nine things in mind
when developing applications,
you'll thank yourself down the
road for maintaining a cleaner
database environment for better-performing applications.
IBMSYSTEMSMAG.COM MAY/JUNE 2020 | 17


https://www.itpro.co.uk/server/29990/why-the-mainframe-is-still-going-strong https://www.dzone.com/articles/new-forrester-consulting-kpi-study-is-a-must-read http://www.IBMSYSTEMSMAG.COM

IBM Systems magazine, IBM Z - May/June 2020

Table of Contents for the Digital Edition of IBM Systems magazine, IBM Z - May/June 2020

Table of Contents
Editor's Desk: Enabling your success in a hybrid multicloud world
Currents: Arvind Krishna elected IBM CEO, James Whitehurst elected president
Currents: Solutions
Currents: Sustainable battery composition
Currents: The next generation of IBMers on why IBM Z is relevant
Currents: Women in IT value community and mentorship
Currents: A call to all Canadian mainframers
Partner POV: Develop an effective package management strategy to streamline DevOps
Cover Story: Meet the New IBM z15 and IBM LinuxONE III Models: The latest air-cooled systems can help enhance resiliency, security and availability in a hybrid cloud world
The Business Value of the Transformative IBM Z Platform How Feature 1: The Business Value of the Transformative IBM Z Platform: How IBM Z provides tools and capabilities for digital transformation
TECH Showcase: The IBM DS8900F family of flash storage systems provides improved encryption, disaster recovery, uptime and scalability
Techbits: Linux on IBM Z and IBM LinuxONE: When to use SCSI versus DASD storage
Techbits: Application tier considerations for moving to the cloud or x86
Techbits: Ask the expert: How can I reduce risk when performing an IBM Z hardware upgrade?
Beyond the Box: IBMer David Hilliard on his role as a locomotive engineer for the Catskill Mountain Railroad
IBM Systems magazine, IBM Z - May/June 2020 - Intro
IBM Systems magazine, IBM Z - May/June 2020 - Table of Contents
IBM Systems magazine, IBM Z - May/June 2020 - Cover2
IBM Systems magazine, IBM Z - May/June 2020 - 1
IBM Systems magazine, IBM Z - May/June 2020 - 2
IBM Systems magazine, IBM Z - May/June 2020 - 3
IBM Systems magazine, IBM Z - May/June 2020 - 4
IBM Systems magazine, IBM Z - May/June 2020 - 5
IBM Systems magazine, IBM Z - May/June 2020 - Editor's Desk: Enabling your success in a hybrid multicloud world
IBM Systems magazine, IBM Z - May/June 2020 - 7
IBM Systems magazine, IBM Z - May/June 2020 - Currents: Solutions
IBM Systems magazine, IBM Z - May/June 2020 - Currents: The next generation of IBMers on why IBM Z is relevant
IBM Systems magazine, IBM Z - May/June 2020 - Currents: Women in IT value community and mentorship
IBM Systems magazine, IBM Z - May/June 2020 - 11
IBM Systems magazine, IBM Z - May/June 2020 - 12
IBM Systems magazine, IBM Z - May/June 2020 - 13
IBM Systems magazine, IBM Z - May/June 2020 - Currents: A call to all Canadian mainframers
IBM Systems magazine, IBM Z - May/June 2020 - 15
IBM Systems magazine, IBM Z - May/June 2020 - Partner POV: Develop an effective package management strategy to streamline DevOps
IBM Systems magazine, IBM Z - May/June 2020 - 17
IBM Systems magazine, IBM Z - May/June 2020 - Cover Story: Meet the New IBM z15 and IBM LinuxONE III Models: The latest air-cooled systems can help enhance resiliency, security and availability in a hybrid cloud world
IBM Systems magazine, IBM Z - May/June 2020 - 19
IBM Systems magazine, IBM Z - May/June 2020 - 20
IBM Systems magazine, IBM Z - May/June 2020 - 21
IBM Systems magazine, IBM Z - May/June 2020 - 22
IBM Systems magazine, IBM Z - May/June 2020 - 23
IBM Systems magazine, IBM Z - May/June 2020 - The Business Value of the Transformative IBM Z Platform How Feature 1: The Business Value of the Transformative IBM Z Platform: How IBM Z provides tools and capabilities for digital transformation
IBM Systems magazine, IBM Z - May/June 2020 - 25
IBM Systems magazine, IBM Z - May/June 2020 - 26
IBM Systems magazine, IBM Z - May/June 2020 - 27
IBM Systems magazine, IBM Z - May/June 2020 - 28
IBM Systems magazine, IBM Z - May/June 2020 - TECH Showcase: The IBM DS8900F family of flash storage systems provides improved encryption, disaster recovery, uptime and scalability
IBM Systems magazine, IBM Z - May/June 2020 - 30
IBM Systems magazine, IBM Z - May/June 2020 - 31
IBM Systems magazine, IBM Z - May/June 2020 - 32
IBM Systems magazine, IBM Z - May/June 2020 - 33
IBM Systems magazine, IBM Z - May/June 2020 - 34
IBM Systems magazine, IBM Z - May/June 2020 - Techbits: Linux on IBM Z and IBM LinuxONE: When to use SCSI versus DASD storage
IBM Systems magazine, IBM Z - May/June 2020 - 36
IBM Systems magazine, IBM Z - May/June 2020 - Techbits: Application tier considerations for moving to the cloud or x86
IBM Systems magazine, IBM Z - May/June 2020 - 38
IBM Systems magazine, IBM Z - May/June 2020 - Techbits: Ask the expert: How can I reduce risk when performing an IBM Z hardware upgrade?
IBM Systems magazine, IBM Z - May/June 2020 - Beyond the Box: IBMer David Hilliard on his role as a locomotive engineer for the Catskill Mountain Railroad
IBM Systems magazine, IBM Z - May/June 2020 - Cover3
IBM Systems magazine, IBM Z - May/June 2020 - Cover4
IBM Systems magazine, IBM Z - May/June 2020 - SD
IBM Systems magazine, IBM Z - May/June 2020 - CoverSD1
IBM Systems magazine, IBM Z - May/June 2020 - CoverSD2
IBM Systems magazine, IBM Z - May/June 2020 - SD1
IBM Systems magazine, IBM Z - May/June 2020 - SD2
IBM Systems magazine, IBM Z - May/June 2020 - SD3
IBM Systems magazine, IBM Z - May/June 2020 - SD4
IBM Systems magazine, IBM Z - May/June 2020 - CT1
IBM Systems magazine, IBM Z - May/June 2020 - CT2
IBM Systems magazine, IBM Z - May/June 2020 - SD5
IBM Systems magazine, IBM Z - May/June 2020 - SD6
IBM Systems magazine, IBM Z - May/June 2020 - SD7
IBM Systems magazine, IBM Z - May/June 2020 - SD8
IBM Systems magazine, IBM Z - May/June 2020 - SD9
IBM Systems magazine, IBM Z - May/June 2020 - SD10
IBM Systems magazine, IBM Z - May/June 2020 - SD11
IBM Systems magazine, IBM Z - May/June 2020 - SD12
IBM Systems magazine, IBM Z - May/June 2020 - SD13
IBM Systems magazine, IBM Z - May/June 2020 - SD14
IBM Systems magazine, IBM Z - May/June 2020 - SD15
IBM Systems magazine, IBM Z - May/June 2020 - SD16
IBM Systems magazine, IBM Z - May/June 2020 - SD17
IBM Systems magazine, IBM Z - May/June 2020 - SD18
IBM Systems magazine, IBM Z - May/June 2020 - SD19
IBM Systems magazine, IBM Z - May/June 2020 - SD20
IBM Systems magazine, IBM Z - May/June 2020 - SD21
IBM Systems magazine, IBM Z - May/June 2020 - SD22
IBM Systems magazine, IBM Z - May/June 2020 - SD23
IBM Systems magazine, IBM Z - May/June 2020 - SD24
IBM Systems magazine, IBM Z - May/June 2020 - SD25
IBM Systems magazine, IBM Z - May/June 2020 - SD26
IBM Systems magazine, IBM Z - May/June 2020 - SD27
IBM Systems magazine, IBM Z - May/June 2020 - SD28
IBM Systems magazine, IBM Z - May/June 2020 - SD29
IBM Systems magazine, IBM Z - May/June 2020 - SD30
IBM Systems magazine, IBM Z - May/June 2020 - SD31
IBM Systems magazine, IBM Z - May/June 2020 - SD32
IBM Systems magazine, IBM Z - May/June 2020 - SD33
IBM Systems magazine, IBM Z - May/June 2020 - SD34
IBM Systems magazine, IBM Z - May/June 2020 - SD35
IBM Systems magazine, IBM Z - May/June 2020 - SD36
IBM Systems magazine, IBM Z - May/June 2020 - SD39
IBM Systems magazine, IBM Z - May/June 2020 - SD40
IBM Systems magazine, IBM Z - May/June 2020 - SD41
IBM Systems magazine, IBM Z - May/June 2020 - SD42
IBM Systems magazine, IBM Z - May/June 2020 - SD43
IBM Systems magazine, IBM Z - May/June 2020 - SD44
IBM Systems magazine, IBM Z - May/June 2020 - SD45
IBM Systems magazine, IBM Z - May/June 2020 - SD46
IBM Systems magazine, IBM Z - May/June 2020 - SD47
IBM Systems magazine, IBM Z - May/June 2020 - SD48
IBM Systems magazine, IBM Z - May/June 2020 - SD49
IBM Systems magazine, IBM Z - May/June 2020 - SD50
IBM Systems magazine, IBM Z - May/June 2020 - SD51
IBM Systems magazine, IBM Z - May/June 2020 - SD52
IBM Systems magazine, IBM Z - May/June 2020 - SD53
IBM Systems magazine, IBM Z - May/June 2020 - SD54
IBM Systems magazine, IBM Z - May/June 2020 - SD55
IBM Systems magazine, IBM Z - May/June 2020 - SD56
IBM Systems magazine, IBM Z - May/June 2020 - CoverSD3
IBM Systems magazine, IBM Z - May/June 2020 - CoverSD4
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.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
https://www.nxtbookmedia.com