IBM Systems magazine, IBM Z July/Aug 2020 - SD18

ARTICLE

DATABASE

SPO NSO RED ADVERTISING CONT ENT

Improving Database Processes on z/OS
By Shirley S. Savage

T

he IBM Db2* Analytics
Accelerator (IDAA) v7.1 was
launched in 2019. This latest
offering features IDAA v7.1 as a
Docker container with new hardware,
new database engine and two
deployment options. Both options
give users the same functionality,
implementation and API.
Clients can choose a physical
appliance or a software appliance
called IBM Db2 Analytics Accelerator
for z/OS* (zIDAA), which runs on
IBM Z* on Integrated Facility for
Linux*. zIDAA runs on a new LPAR
type-a Secure Service Container
with the software stack packed into
it. This Docker container is a fully
self-managed appliance that can be
deployed in minutes. zIDAA provides
seamless integration into the IBM Z
environment.
Used in conjunction with IDAA, the
Db2 Analytics Accelerator Loader for
z/OS, which is a separate licensed
tool, allows loaded non-Db2 and
non-Z data into IDAA. By employing
data virtualization, users can access
relational and non-relational data
through SQL queries.
The capabilities of IDAA and Db2
Analytics Accelerator Loader can
be used to load and store SMF data
for capacity planning, forecasting,
trending, dashboarding and
troubleshooting. Extract-Transfer

and Load (ETL) data can be processed
on the accelerator and sent to
downstream systems. The accelerator
also can be loaded from registered
Db2 image copies. Finally, users can
load multiple accelerators in parallel
with the HA LOAD.
IDAA is more than a way
to accelerate queries. "It has
tremendous potential and can be
leveraged as a data server to retain
system logs or SMF data or to enhance
ETL processes while reducing MIP
consumption, enhancing speed or
complimenting an existing data
warehouse," says Sandro Ramirez, a
technical specialist at IBM ("IDAA v7.1
Enhances Performance, Scalability
and More," bit.ly/2IMhcGs).

Database Migration Delivers Results
Banco do Brasil, the oldest and
second largest bank in Brazil, made
a decision to migrate back to IBM
Db2 after experiencing difficulties
with an outside ISV. The bank's
Db2 staff created a comprehensive
migration plan and worked with IBM
to implement it.
For instance, the bank relied on
certain utilities functions of the ISV
version that weren't immediately
available on IBM Db2. IBM worked
closely with the bank to make those
enhancements possible.
Banco faced several other

18 2020 ibmsystemsmag.com/solutions-directory

migration challenges. One was
translating the JCL DDNAMEs from
the ISV to IBM's method of using
TEMPLATES. Because a number of
development areas in Banco couldn't
schedule JCL to execute DSNTILB
directly, the bank's Db2 staff
installed pre-defined JCL procedures
for these areas to use. Additional
customization of the JCL procedures
was necessary.
IBM and the bank also worked to
resolve several IBM LOAD issues.
As the migration proceeded, the
number of IBM LOAD jobs increased.
By December 2017, Banco said that
about 93% of its LOAD utility jobs had
been converted to IBM. The bank also
had to add more than 20,000 lines of
COBOL to support the migration to
IBM Db2.
Banco do Brasil was pleased with
the final result of the massive migration effort. "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," says Alessandro
Schneider, head of data management infrastructure, at the bank ("A
Db2 Utilities Migration Project," bit.
ly/33F8bHt).


http://bit.ly/2IMhcGs http://bit.ly/33F8bHt http://bit.ly/33F8bHt http://www.ibmsystemsmag.com/solutions-directory

IBM Systems magazine, IBM Z July/Aug 2020

Table of Contents for the Digital Edition of IBM Systems magazine, IBM Z July/Aug 2020

Table of Contents
From the editor
Currents: IBMer Megan Hampton helps teach African refugees how to code
Currents: Introducing 2020 first-time IBM Z Champions
Currents: Solutions
Partner POV: How to build a modern mainframe computing workforce
Cover Story: Enhancing Cloud Computing: IBM and Red Hat combination provides advances to help IBM Z clients embrace open computing environments
Feature: Cloud Native Development Packaged in a Self-Service Platform: IBM Wazi for Red Hat CodeReady Workspaces helps close the skills gap, improve productivity and speed time to market
TECH Showcase: Learn about the winners of the 2019 Master the Mainframe competition
Hot Topics: IBM's ServerPac installation using IBM z/OSMF streamlines software management
Tech Bits: Why applications should drive your infrastructure requirements
Tech Bits: Ask the expert: The IBM z/OS Container Extension trial feature
Beyond the Box: Megan Hampton advocates STEM education
IBM Systems magazine, IBM Z July/Aug 2020 - Intro
IBM Systems magazine, IBM Z July/Aug 2020 - Cover1
IBM Systems magazine, IBM Z July/Aug 2020 - Cover2
IBM Systems magazine, IBM Z July/Aug 2020 - 1
IBM Systems magazine, IBM Z July/Aug 2020 - 2
IBM Systems magazine, IBM Z July/Aug 2020 - 3
IBM Systems magazine, IBM Z July/Aug 2020 - Table of Contents
IBM Systems magazine, IBM Z July/Aug 2020 - 5
IBM Systems magazine, IBM Z July/Aug 2020 - From the editor
IBM Systems magazine, IBM Z July/Aug 2020 - 7
IBM Systems magazine, IBM Z July/Aug 2020 - Currents: IBMer Megan Hampton helps teach African refugees how to code
IBM Systems magazine, IBM Z July/Aug 2020 - 9
IBM Systems magazine, IBM Z July/Aug 2020 - Currents: Introducing 2020 first-time IBM Z Champions
IBM Systems magazine, IBM Z July/Aug 2020 - 11
IBM Systems magazine, IBM Z July/Aug 2020 - 12
IBM Systems magazine, IBM Z July/Aug 2020 - 13
IBM Systems magazine, IBM Z July/Aug 2020 - Currents: Solutions
IBM Systems magazine, IBM Z July/Aug 2020 - 15
IBM Systems magazine, IBM Z July/Aug 2020 - 16
IBM Systems magazine, IBM Z July/Aug 2020 - 17
IBM Systems magazine, IBM Z July/Aug 2020 - Partner POV: How to build a modern mainframe computing workforce
IBM Systems magazine, IBM Z July/Aug 2020 - 19
IBM Systems magazine, IBM Z July/Aug 2020 - Cover Story: Enhancing Cloud Computing: IBM and Red Hat combination provides advances to help IBM Z clients embrace open computing environments
IBM Systems magazine, IBM Z July/Aug 2020 - 21
IBM Systems magazine, IBM Z July/Aug 2020 - 22
IBM Systems magazine, IBM Z July/Aug 2020 - 23
IBM Systems magazine, IBM Z July/Aug 2020 - 24
IBM Systems magazine, IBM Z July/Aug 2020 - 25
IBM Systems magazine, IBM Z July/Aug 2020 - Feature: Cloud Native Development Packaged in a Self-Service Platform: IBM Wazi for Red Hat CodeReady Workspaces helps close the skills gap, improve productivity and speed time to market
IBM Systems magazine, IBM Z July/Aug 2020 - 27
IBM Systems magazine, IBM Z July/Aug 2020 - 28
IBM Systems magazine, IBM Z July/Aug 2020 - 29
IBM Systems magazine, IBM Z July/Aug 2020 - 30
IBM Systems magazine, IBM Z July/Aug 2020 - TECH Showcase: Learn about the winners of the 2019 Master the Mainframe competition
IBM Systems magazine, IBM Z July/Aug 2020 - 32
IBM Systems magazine, IBM Z July/Aug 2020 - 33
IBM Systems magazine, IBM Z July/Aug 2020 - Hot Topics: IBM's ServerPac installation using IBM z/OSMF streamlines software management
IBM Systems magazine, IBM Z July/Aug 2020 - 35
IBM Systems magazine, IBM Z July/Aug 2020 - Tech Bits: Why applications should drive your infrastructure requirements
IBM Systems magazine, IBM Z July/Aug 2020 - 37
IBM Systems magazine, IBM Z July/Aug 2020 - 38
IBM Systems magazine, IBM Z July/Aug 2020 - Tech Bits: Ask the expert: The IBM z/OS Container Extension trial feature
IBM Systems magazine, IBM Z July/Aug 2020 - Beyond the Box: Megan Hampton advocates STEM education
IBM Systems magazine, IBM Z July/Aug 2020 - Cover3
IBM Systems magazine, IBM Z July/Aug 2020 - Cover4
IBM Systems magazine, IBM Z July/Aug 2020 - CoverSD1
IBM Systems magazine, IBM Z July/Aug 2020 - CoverSD2
IBM Systems magazine, IBM Z July/Aug 2020 - SD1
IBM Systems magazine, IBM Z July/Aug 2020 - SD2
IBM Systems magazine, IBM Z July/Aug 2020 - SD3
IBM Systems magazine, IBM Z July/Aug 2020 - SD4
IBM Systems magazine, IBM Z July/Aug 2020 - SD5
IBM Systems magazine, IBM Z July/Aug 2020 - SD6
IBM Systems magazine, IBM Z July/Aug 2020 - SD7
IBM Systems magazine, IBM Z July/Aug 2020 - SD8
IBM Systems magazine, IBM Z July/Aug 2020 - SD9
IBM Systems magazine, IBM Z July/Aug 2020 - SD10
IBM Systems magazine, IBM Z July/Aug 2020 - SD11
IBM Systems magazine, IBM Z July/Aug 2020 - SD12
IBM Systems magazine, IBM Z July/Aug 2020 - SD13
IBM Systems magazine, IBM Z July/Aug 2020 - SD14
IBM Systems magazine, IBM Z July/Aug 2020 - SD15
IBM Systems magazine, IBM Z July/Aug 2020 - SD16
IBM Systems magazine, IBM Z July/Aug 2020 - SD17
IBM Systems magazine, IBM Z July/Aug 2020 - SD18
IBM Systems magazine, IBM Z July/Aug 2020 - SD19
IBM Systems magazine, IBM Z July/Aug 2020 - SD20
IBM Systems magazine, IBM Z July/Aug 2020 - SD21
IBM Systems magazine, IBM Z July/Aug 2020 - SD22
IBM Systems magazine, IBM Z July/Aug 2020 - SD23
IBM Systems magazine, IBM Z July/Aug 2020 - SD24
IBM Systems magazine, IBM Z July/Aug 2020 - SD25
IBM Systems magazine, IBM Z July/Aug 2020 - SD26
IBM Systems magazine, IBM Z July/Aug 2020 - SD27
IBM Systems magazine, IBM Z July/Aug 2020 - SD28
IBM Systems magazine, IBM Z July/Aug 2020 - SD29
IBM Systems magazine, IBM Z July/Aug 2020 - SD30
IBM Systems magazine, IBM Z July/Aug 2020 - SD31
IBM Systems magazine, IBM Z July/Aug 2020 - SD32
IBM Systems magazine, IBM Z July/Aug 2020 - SD33
IBM Systems magazine, IBM Z July/Aug 2020 - SD34
IBM Systems magazine, IBM Z July/Aug 2020 - SD35
IBM Systems magazine, IBM Z July/Aug 2020 - SD36
IBM Systems magazine, IBM Z July/Aug 2020 - SD39
IBM Systems magazine, IBM Z July/Aug 2020 - SD40
IBM Systems magazine, IBM Z July/Aug 2020 - SD41
IBM Systems magazine, IBM Z July/Aug 2020 - SD42
IBM Systems magazine, IBM Z July/Aug 2020 - SD43
IBM Systems magazine, IBM Z July/Aug 2020 - SD44
IBM Systems magazine, IBM Z July/Aug 2020 - SD45
IBM Systems magazine, IBM Z July/Aug 2020 - SD46
IBM Systems magazine, IBM Z July/Aug 2020 - SD47
IBM Systems magazine, IBM Z July/Aug 2020 - SD48
IBM Systems magazine, IBM Z July/Aug 2020 - SD49
IBM Systems magazine, IBM Z July/Aug 2020 - SD50
IBM Systems magazine, IBM Z July/Aug 2020 - SD51
IBM Systems magazine, IBM Z July/Aug 2020 - SD52
IBM Systems magazine, IBM Z July/Aug 2020 - SD53
IBM Systems magazine, IBM Z July/Aug 2020 - SD54
IBM Systems magazine, IBM Z July/Aug 2020 - SD55
IBM Systems magazine, IBM Z July/Aug 2020 - SD56
IBM Systems magazine, IBM Z July/Aug 2020 - CoverSD3
IBM Systems magazine, IBM Z July/Aug 2020 - CoverSD4
IBM Systems magazine, IBM Z July/Aug 2020 - CT1
IBM Systems magazine, IBM Z July/Aug 2020 - CT2
IBM Systems magazine, IBM Z July/Aug 2020 - SD
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