IBM Systems magazine, IBM Z - March/April 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 - March/April 2020

Table of Contents for the Digital Edition of IBM Systems magazine, IBM Z - March/April 2020

Table of Contents
Editor's Desk: Securing a data-driven world
Currents: Learn how to provide customers with data privacy and security at Think 2020
Currents: On the web
Currents: Closing the COBOL programming skills gap
Currents: Hyundai and Uber announce aerial ride-hailing partnership
Partner POV: 3 requirements for enterprise-level digital transformation
Cover Story: Dynamic Data Protection: IBM Data Privacy Passports gives IBM Z users data privacy control, no matter where it is or where it's going
Feature 1: Sealing up Privacy: Continuous IBM Z innovations offer a roadmap designed to stay ahead of clients' changing security needs
Feature 2: Unlocking Quantum Security: Quantum-safe cryptography is key to protecting data as quantum computing systems evolve
TECH Showcase: Collaboration, communication and cooperation are crucial for developing a successful data management strategy
Techbits: z/OS data migration: Helping clients avoid risk and downtime
Techbits: Ask the expert: What is Fibre Channel over IP?
Beyond the Box: Homer Ahr reflects on working mission control for the NASA Apollo space program
Reference Point - Global Events, Education, Resources for Power Systems
2020 IBM Z Solutions Directory
IBM Systems magazine, IBM Z - March/April 2020 - Intro
IBM Systems magazine, IBM Z - March/April 2020 - Cover1
IBM Systems magazine, IBM Z - March/April 2020 - Cover2
IBM Systems magazine, IBM Z - March/April 2020 - 1
IBM Systems magazine, IBM Z - March/April 2020 - 2
IBM Systems magazine, IBM Z - March/April 2020 - 3
IBM Systems magazine, IBM Z - March/April 2020 - Table of Contents
IBM Systems magazine, IBM Z - March/April 2020 - 5
IBM Systems magazine, IBM Z - March/April 2020 - Editor's Desk: Securing a data-driven world
IBM Systems magazine, IBM Z - March/April 2020 - 7
IBM Systems magazine, IBM Z - March/April 2020 - Currents: Learn how to provide customers with data privacy and security at Think 2020
IBM Systems magazine, IBM Z - March/April 2020 - Currents: On the web
IBM Systems magazine, IBM Z - March/April 2020 - Currents: Closing the COBOL programming skills gap
IBM Systems magazine, IBM Z - March/April 2020 - Currents: Hyundai and Uber announce aerial ride-hailing partnership
IBM Systems magazine, IBM Z - March/April 2020 - Partner POV: 3 requirements for enterprise-level digital transformation
IBM Systems magazine, IBM Z - March/April 2020 - 13
IBM Systems magazine, IBM Z - March/April 2020 - Cover Story: Dynamic Data Protection: IBM Data Privacy Passports gives IBM Z users data privacy control, no matter where it is or where it's going
IBM Systems magazine, IBM Z - March/April 2020 - 15
IBM Systems magazine, IBM Z - March/April 2020 - 16
IBM Systems magazine, IBM Z - March/April 2020 - 17
IBM Systems magazine, IBM Z - March/April 2020 - 18
IBM Systems magazine, IBM Z - March/April 2020 - 19
IBM Systems magazine, IBM Z - March/April 2020 - 20
IBM Systems magazine, IBM Z - March/April 2020 - Feature 1: Sealing up Privacy: Continuous IBM Z innovations offer a roadmap designed to stay ahead of clients' changing security needs
IBM Systems magazine, IBM Z - March/April 2020 - 22
IBM Systems magazine, IBM Z - March/April 2020 - 23
IBM Systems magazine, IBM Z - March/April 2020 - Feature 2: Unlocking Quantum Security: Quantum-safe cryptography is key to protecting data as quantum computing systems evolve
IBM Systems magazine, IBM Z - March/April 2020 - 25
IBM Systems magazine, IBM Z - March/April 2020 - 26
IBM Systems magazine, IBM Z - March/April 2020 - 27
IBM Systems magazine, IBM Z - March/April 2020 - 28
IBM Systems magazine, IBM Z - March/April 2020 - 29
IBM Systems magazine, IBM Z - March/April 2020 - 30
IBM Systems magazine, IBM Z - March/April 2020 - TECH Showcase: Collaboration, communication and cooperation are crucial for developing a successful data management strategy
IBM Systems magazine, IBM Z - March/April 2020 - 32
IBM Systems magazine, IBM Z - March/April 2020 - 33
IBM Systems magazine, IBM Z - March/April 2020 - 34
IBM Systems magazine, IBM Z - March/April 2020 - 35
IBM Systems magazine, IBM Z - March/April 2020 - Techbits: z/OS data migration: Helping clients avoid risk and downtime
IBM Systems magazine, IBM Z - March/April 2020 - 37
IBM Systems magazine, IBM Z - March/April 2020 - Techbits: Ask the expert: What is Fibre Channel over IP?
IBM Systems magazine, IBM Z - March/April 2020 - 39
IBM Systems magazine, IBM Z - March/April 2020 - Beyond the Box: Homer Ahr reflects on working mission control for the NASA Apollo space program
IBM Systems magazine, IBM Z - March/April 2020 - Cover3
IBM Systems magazine, IBM Z - March/April 2020 - Cover4
IBM Systems magazine, IBM Z - March/April 2020 - Reference Point - Global Events, Education, Resources for Power Systems
IBM Systems magazine, IBM Z - March/April 2020 - SD
IBM Systems magazine, IBM Z - March/April 2020 - 2020 IBM Z Solutions Directory
IBM Systems magazine, IBM Z - March/April 2020 - CoverSD2
IBM Systems magazine, IBM Z - March/April 2020 - SD1
IBM Systems magazine, IBM Z - March/April 2020 - SD2
IBM Systems magazine, IBM Z - March/April 2020 - SD3
IBM Systems magazine, IBM Z - March/April 2020 - SD4
IBM Systems magazine, IBM Z - March/April 2020 - CT1
IBM Systems magazine, IBM Z - March/April 2020 - CT2
IBM Systems magazine, IBM Z - March/April 2020 - SD5
IBM Systems magazine, IBM Z - March/April 2020 - SD6
IBM Systems magazine, IBM Z - March/April 2020 - SD7
IBM Systems magazine, IBM Z - March/April 2020 - SD8
IBM Systems magazine, IBM Z - March/April 2020 - SD9
IBM Systems magazine, IBM Z - March/April 2020 - SD10
IBM Systems magazine, IBM Z - March/April 2020 - SD11
IBM Systems magazine, IBM Z - March/April 2020 - SD12
IBM Systems magazine, IBM Z - March/April 2020 - SD13
IBM Systems magazine, IBM Z - March/April 2020 - SD14
IBM Systems magazine, IBM Z - March/April 2020 - SD15
IBM Systems magazine, IBM Z - March/April 2020 - SD16
IBM Systems magazine, IBM Z - March/April 2020 - SD17
IBM Systems magazine, IBM Z - March/April 2020 - SD18
IBM Systems magazine, IBM Z - March/April 2020 - SD19
IBM Systems magazine, IBM Z - March/April 2020 - SD20
IBM Systems magazine, IBM Z - March/April 2020 - SD21
IBM Systems magazine, IBM Z - March/April 2020 - SD22
IBM Systems magazine, IBM Z - March/April 2020 - SD23
IBM Systems magazine, IBM Z - March/April 2020 - SD24
IBM Systems magazine, IBM Z - March/April 2020 - SD25
IBM Systems magazine, IBM Z - March/April 2020 - SD26
IBM Systems magazine, IBM Z - March/April 2020 - SD27
IBM Systems magazine, IBM Z - March/April 2020 - SD28
IBM Systems magazine, IBM Z - March/April 2020 - SD29
IBM Systems magazine, IBM Z - March/April 2020 - SD30
IBM Systems magazine, IBM Z - March/April 2020 - SD31
IBM Systems magazine, IBM Z - March/April 2020 - SD32
IBM Systems magazine, IBM Z - March/April 2020 - SD33
IBM Systems magazine, IBM Z - March/April 2020 - SD34
IBM Systems magazine, IBM Z - March/April 2020 - SD35
IBM Systems magazine, IBM Z - March/April 2020 - SD36
IBM Systems magazine, IBM Z - March/April 2020 - SD39
IBM Systems magazine, IBM Z - March/April 2020 - SD40
IBM Systems magazine, IBM Z - March/April 2020 - SD41
IBM Systems magazine, IBM Z - March/April 2020 - SD42
IBM Systems magazine, IBM Z - March/April 2020 - SD43
IBM Systems magazine, IBM Z - March/April 2020 - SD44
IBM Systems magazine, IBM Z - March/April 2020 - SD45
IBM Systems magazine, IBM Z - March/April 2020 - SD46
IBM Systems magazine, IBM Z - March/April 2020 - SD47
IBM Systems magazine, IBM Z - March/April 2020 - SD48
IBM Systems magazine, IBM Z - March/April 2020 - SD49
IBM Systems magazine, IBM Z - March/April 2020 - SD50
IBM Systems magazine, IBM Z - March/April 2020 - SD51
IBM Systems magazine, IBM Z - March/April 2020 - SD52
IBM Systems magazine, IBM Z - March/April 2020 - SD53
IBM Systems magazine, IBM Z - March/April 2020 - SD54
IBM Systems magazine, IBM Z - March/April 2020 - SD55
IBM Systems magazine, IBM Z - March/April 2020 - SD56
IBM Systems magazine, IBM Z - March/April 2020 - CoverSD3
IBM Systems magazine, IBM Z - March/April 2020 - CoverSD4
http://www.ibmsystemsmagmainframedigital.com/mspcomm/ibmsystemsmag/ibmsystems_mainframe_20201112
http://www.ibmsystemsmagmainframedigital.com/mspcomm/ibmsystemsmag/ibmsystems_mainframe_20200910
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