IBM Systems magazine, Mainframe - November/December 2018 - 37

"Ä Ç!Ã$ÉÉÈÃ! Ã%!ÉÃ%"ÉÇ®ÇÃ
functions provided by the ISV utilities that weren't immediately available from IBM. To implement these
functions in IBM's utilities, Banco
submitted requests for enhancement and worked closely with IBM.
The bank also had a few other migration challenges. Various
development areas in Banco are
responsible for utility scheduling. However, these development
areas can't schedule JCL to execute
DSNUTILB directly. The Banco
$Æ?Ã%&ÄÃ %&ÄÉÈÃ"$ÉIÈÉ® ÉÈÃ
JCL procedures for their development areas to use. However, many
customizations and COBOL programs were developed by Banco
to perform the necessary runtime
conversions needed to resolve differences between the ISV and IBM
Db2 utilities.

"Despite the great risk of changing thousands
of routines automatically and the coding effort,
the migration of Db2 z/OS utilities to IBM has
brought great results for Banco do Brasil,
partially due to removing the dependency
of a single ISV and potentially allowing
improvements in our processes."
-Alessandro Schneider, head of data management infrastructure,
Banco do Brasil

The ISV LOAD utility allowed Banco
to choose the DISCARD > 0 behavior
they needed. One option was not
loading any rows and returning with
a customized return code. The second option was to load all the rows,
discarding the duplicates and returnThe LOAD Utility
ing with a customized return code.
Banco presented the details of the
To match this function, Banco
LOAD conversion at Think 2018. The
used IBM's LOAD RESUME with
bank's approach is being applied
BACKOUT YES or DIS=0. The
to all utility conversion work. It
bank also did a LOAD REPLACE
starts with the basic premise that
(SHRVLEVEL REFERENCE), and
Banco has a complete understandwrote a COBOL program to
ing of its utility needs and
read the SYSOUT to look
then matches or develops
for discarded rows and
workarounds to meet the
provide the return code.
bank's needs.
READ MORE
IBM's use of
Banco needed LOAD
about Banco's
FlashCopy* technology
REPLACE SHRLEVEL
migration at
bit.ly/2RiUVTp
was a performance adREFERENCE functionality
vantage that Banco impleto allow concurrent read
mented to save resources and
access to the target table while
improve availability. The bank was
new data is loaded into a set of shadable to perform an inline copy using
ow data sets. A SWITCH phase was
only FlashCopy technology, and a
introduced to the LOAD utility to
copy statement was used after loadswitch access between the original
ing smaller tables. For larger tables
and shadow data sets. IBM delivered
using inline copy, Banco created
this functionality via PI67793.
automation to detect the FlashCopy
The ISV LOAD utility used a
copies and start a COPYTOCOPY
two-phase process to validate data
job. Full support for inline copy was
prior to the actual LOAD operation.
delivered by IBM in PI81723.
For Banco, this capability avoided
The results from the IBM LOAD
leaving objects in a recovery pending
utility as of December 2017 are
situation when discarded records
as follows:
(DISCARD > 0) were encountered.

*

*
*

Approximately 93 percent
of Banco's LOAD utility jobs
were converted to IBM
CPU usage was reduced by
65 percent
Elapsed time was reduced by
25 percent

Delivering Performance,
Availability and Timely
Support
Performance, availability and
timely support of all Db2 functionality was important to Banco. The
bank's management provided the
key directive of reducing ISV costs
and overall maintenance of two
sets of utilities. Throughout the
entire project, IBM worked with
Banco to understand the bank's requirements and provide support.
"Ä Ç!ÃÄ%ÃÆÉ É®&&ÉÈÃ$!Ã&ÉÃ
migration, explains Alessandro
Schneider, head of data management infrastructure, Banco do
Brasil. "Despite the great risk of
changing thousands of routines
automatically and the coding
effort, the migration of Db2 z/OS
utilities to IBM has brought great
results for Banco do Brasil, partially due to removing the dependency of a single ISV and potentially
allowing improvements in our
processes."

IBMSYSTEMSMAG.COM NOVEMBER/DECEMBER 2018 | 37


http://www.bit.ly/2RiUVTp http://www.IBMSYSTEMSMAG.COM

IBM Systems magazine, Mainframe - November/December 2018

Table of Contents for the Digital Edition of IBM Systems magazine, Mainframe - November/December 2018

Table of Contents
Editor's Desk: Room for imporovement
Currents: The big redesign unveil
Currents: ExxonMobil and IBM improce the mobile app user experience
Currents: 8 emerging storage trends of 2018
Currents: Solutions
Currents: Remembering Dr. John Ehrman: The father of IBM High Level Assembler
Partner POV: DevOps requires quality, velocity and efficiency to transform software delivery life cycles
Cover Story: Enabling opportunity: Get the most out of IBM Z with Secure Service Containers and a consumption-based pricing model
Feature 1: Skilling up: How Russell Tobin, Per Scholas and IBM brought new talent into the mainframe workforce
TECH Showcase: How to reap the full benefits of virtual tape storage, properly measure its performance and choose the right strategy for your business
Techbits: Banco do Brasil improves processes after migrating to the IBM Db2 Utilities Suite for z/OS
Techbits: Multifactor authentication is a user-friendly upgrade to password-only systems
Beyond the Box: The mainframe Playground Education Initiative opens the mainframe to the next generation
Reference Point - Global Events, Education, Resources for Power Systems
2018 Mainframe Solutions Edition Product Index
IBM Systems magazine, Mainframe - November/December 2018 - Intro
IBM Systems magazine, Mainframe - November/December 2018 - Cover1
IBM Systems magazine, Mainframe - November/December 2018 - Cover2
IBM Systems magazine, Mainframe - November/December 2018 - 1
IBM Systems magazine, Mainframe - November/December 2018 - 2
IBM Systems magazine, Mainframe - November/December 2018 - 3
IBM Systems magazine, Mainframe - November/December 2018 - Table of Contents
IBM Systems magazine, Mainframe - November/December 2018 - 5
IBM Systems magazine, Mainframe - November/December 2018 - Editor's Desk: Room for imporovement
IBM Systems magazine, Mainframe - November/December 2018 - 7
IBM Systems magazine, Mainframe - November/December 2018 - Currents: The big redesign unveil
IBM Systems magazine, Mainframe - November/December 2018 - Currents: ExxonMobil and IBM improce the mobile app user experience
IBM Systems magazine, Mainframe - November/December 2018 - Beyond the Box: The mainframe Playground Education Initiative opens the mainframe to the next generation
IBM Systems magazine, Mainframe - November/December 2018 - 11
IBM Systems magazine, Mainframe - November/December 2018 - Currents: Solutions
IBM Systems magazine, Mainframe - November/December 2018 - Currents: Remembering Dr. John Ehrman: The father of IBM High Level Assembler
IBM Systems magazine, Mainframe - November/December 2018 - Partner POV: DevOps requires quality, velocity and efficiency to transform software delivery life cycles
IBM Systems magazine, Mainframe - November/December 2018 - 15
IBM Systems magazine, Mainframe - November/December 2018 - Cover Story: Enabling opportunity: Get the most out of IBM Z with Secure Service Containers and a consumption-based pricing model
IBM Systems magazine, Mainframe - November/December 2018 - 17
IBM Systems magazine, Mainframe - November/December 2018 - 18
IBM Systems magazine, Mainframe - November/December 2018 - 19
IBM Systems magazine, Mainframe - November/December 2018 - 20
IBM Systems magazine, Mainframe - November/December 2018 - 21
IBM Systems magazine, Mainframe - November/December 2018 - Feature 1: Skilling up: How Russell Tobin, Per Scholas and IBM brought new talent into the mainframe workforce
IBM Systems magazine, Mainframe - November/December 2018 - 23
IBM Systems magazine, Mainframe - November/December 2018 - 24
IBM Systems magazine, Mainframe - November/December 2018 - 25
IBM Systems magazine, Mainframe - November/December 2018 - 26
IBM Systems magazine, Mainframe - November/December 2018 - 27
IBM Systems magazine, Mainframe - November/December 2018 - 28
IBM Systems magazine, Mainframe - November/December 2018 - TECH Showcase: How to reap the full benefits of virtual tape storage, properly measure its performance and choose the right strategy for your business
IBM Systems magazine, Mainframe - November/December 2018 - 30
IBM Systems magazine, Mainframe - November/December 2018 - 31
IBM Systems magazine, Mainframe - November/December 2018 - 32
IBM Systems magazine, Mainframe - November/December 2018 - 33
IBM Systems magazine, Mainframe - November/December 2018 - 34
IBM Systems magazine, Mainframe - November/December 2018 - 35
IBM Systems magazine, Mainframe - November/December 2018 - Techbits: Banco do Brasil improves processes after migrating to the IBM Db2 Utilities Suite for z/OS
IBM Systems magazine, Mainframe - November/December 2018 - 37
IBM Systems magazine, Mainframe - November/December 2018 - Techbits: Multifactor authentication is a user-friendly upgrade to password-only systems
IBM Systems magazine, Mainframe - November/December 2018 - 39
IBM Systems magazine, Mainframe - November/December 2018 - 40
IBM Systems magazine, Mainframe - November/December 2018 - Cover3
IBM Systems magazine, Mainframe - November/December 2018 - Cover4
IBM Systems magazine, Mainframe - November/December 2018 - Reference Point - Global Events, Education, Resources for Power Systems
IBM Systems magazine, Mainframe - November/December 2018 - 2018 Mainframe Solutions Edition Product Index
IBM Systems magazine, Mainframe - November/December 2018 - SE2
IBM Systems magazine, Mainframe - November/December 2018 - SE3
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