IBM Systems Magazine, Mainframe - November/December 2016 - L23


store, online and catalog), where
transactions from each channel are stored in separate fact
tables of a star schema-based
data model. The test involves 40
concurrent users, 28 running 70
short-running dashboard kind
of simple reports, 10 running 25
intermediate sales reports and
two users running five complex
data mining types of complex
reports. Running this mixed
workload for two hours and
measuring concurrent throughput for simple, intermediate and
complex reports provide 5.5x,
20x and 1.3x higher throughput
for the data mart running on DB2
11.1 BLU on Linux on IBM z13*
versus running on pre-integrated
competitor V5 eighth unit.
Further using list prices to
compute three-year total cost of
acquisition (including hardware,
software, maintenance, and
support and subscription costs),
it's 6 percent cheaper to run
the data mart on Linux on z13
than on the competitive system.
DB2 BLU is based on dynamic
in-memory columnar technology
that optimizes CPU and I/O for
ultimate throughput of mixed
analytics workload using some
unique capabilities such as
actionable compression, where
query computations can be
done on compressed data and
data skipping, where min and
max values of certain fields are
pre-computed in a synopsis table
and used to skip chunks of data
blocks that don't have the data
values in the where clause.

for operational analytics and
IBM DB2 Analytics Accelerator
seamlessly connected to DB2 for
z/OS for deep analytics.
However, for data that resides
on Linux on z Systems, it
makes the most sense to keep

1

data in place and run operational and deep analytics on
the same platform benefitting
from co-location advantages
and best-of-breed in-memory
technologies supported on the
platform.

HOUR

SESSIONS

40

WEBINARS

ON-DEMAND

24/7
ACCESS ANYWHERE

Analytics in the
Right Place

These two studies demonstrate
the value of running end-to-end
analytics on Linux on z Systems.
When the OLTP data originates
on z/OS*, it makes the most
sense to co-locate analytics
on z/OS using Spark on z/OS

Webcast Event Center
View upcoming and on-demand webinars at: https://ibmsystemsmag.webex.com

Linux on z Systems NOVEMBER 2016 // 23

Linux_on_z_1116.indd 23

9/29/16 1:15 PM


https://ibmsystemsmag.webex.com

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - November/December 2016

Editor's Desk: Mastering their craft
IBM Perspective: Expanding mainframe ecosystem creates opportunities for Gen Z
Partner PoV: Workplace Diversity: Attract the best talent by encouraging more options for women
IT Today: Financial Feasibility: IBM Global Financing designs customized solutions for technology investments
Currents: Giving Data Structure: Find the right database management systems to maximize information
Case Study: Investing in a Difference: Primerica Life Insurance Co. improves processing and performance
Cover Story: Sparking Student Interest: IBM Master the Mainframe World Championship exposes top students to analytics and data storage
Feature: The Modern Mainframer: The IBM z platform attracts recent grads to its orbit
Women in Tech: Taking a Seat at the IT Table: Women meet challenges, savor successes in the IT field
Tech Corner: Get in the Cloud: z/OS solutions can connect to the cloud through REST interfaces
Solutions: API Integration Platform 3.0, OpenLegacy; Ivory Service Architect V5.1, GT Software
Stop Run: Code Your Own Way: High school girls take charge of their futures
Reference Point - Global Events, Education, Resources for Mainframe
Linux on z Systems E-book
2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2016 - Intro
IBM Systems Magazine, Mainframe - November/December 2016 - Cover1
IBM Systems Magazine, Mainframe - November/December 2016 - Cover2
IBM Systems Magazine, Mainframe - November/December 2016 - 1
IBM Systems Magazine, Mainframe - November/December 2016 - 2
IBM Systems Magazine, Mainframe - November/December 2016 - 3
IBM Systems Magazine, Mainframe - November/December 2016 - 4
IBM Systems Magazine, Mainframe - November/December 2016 - 5
IBM Systems Magazine, Mainframe - November/December 2016 - Editor's Desk: Mastering their craft
IBM Systems Magazine, Mainframe - November/December 2016 - 7
IBM Systems Magazine, Mainframe - November/December 2016 - IBM Perspective: Expanding mainframe ecosystem creates opportunities for Gen Z
IBM Systems Magazine, Mainframe - November/December 2016 - Partner PoV: Workplace Diversity: Attract the best talent by encouraging more options for women
IBM Systems Magazine, Mainframe - November/December 2016 - 10
IBM Systems Magazine, Mainframe - November/December 2016 - IT Today: Financial Feasibility: IBM Global Financing designs customized solutions for technology investments
IBM Systems Magazine, Mainframe - November/December 2016 - 12
IBM Systems Magazine, Mainframe - November/December 2016 - 13
IBM Systems Magazine, Mainframe - November/December 2016 - Currents: Giving Data Structure: Find the right database management systems to maximize information
IBM Systems Magazine, Mainframe - November/December 2016 - 15
IBM Systems Magazine, Mainframe - November/December 2016 - 16
IBM Systems Magazine, Mainframe - November/December 2016 - 17
IBM Systems Magazine, Mainframe - November/December 2016 - Case Study: Investing in a Difference: Primerica Life Insurance Co. improves processing and performance
IBM Systems Magazine, Mainframe - November/December 2016 - 19
IBM Systems Magazine, Mainframe - November/December 2016 - 20
IBM Systems Magazine, Mainframe - November/December 2016 - 21
IBM Systems Magazine, Mainframe - November/December 2016 - 22
IBM Systems Magazine, Mainframe - November/December 2016 - 23
IBM Systems Magazine, Mainframe - November/December 2016 - Cover Story: Sparking Student Interest: IBM Master the Mainframe World Championship exposes top students to analytics and data storage
IBM Systems Magazine, Mainframe - November/December 2016 - 25
IBM Systems Magazine, Mainframe - November/December 2016 - 26
IBM Systems Magazine, Mainframe - November/December 2016 - 27
IBM Systems Magazine, Mainframe - November/December 2016 - Feature: The Modern Mainframer: The IBM z platform attracts recent grads to its orbit
IBM Systems Magazine, Mainframe - November/December 2016 - 29
IBM Systems Magazine, Mainframe - November/December 2016 - 30
IBM Systems Magazine, Mainframe - November/December 2016 - 31
IBM Systems Magazine, Mainframe - November/December 2016 - 32
IBM Systems Magazine, Mainframe - November/December 2016 - Women in Tech: Taking a Seat at the IT Table: Women meet challenges, savor successes in the IT field
IBM Systems Magazine, Mainframe - November/December 2016 - 34
IBM Systems Magazine, Mainframe - November/December 2016 - 35
IBM Systems Magazine, Mainframe - November/December 2016 - 36
IBM Systems Magazine, Mainframe - November/December 2016 - 37
IBM Systems Magazine, Mainframe - November/December 2016 - 38
IBM Systems Magazine, Mainframe - November/December 2016 - 39
IBM Systems Magazine, Mainframe - November/December 2016 - 40
IBM Systems Magazine, Mainframe - November/December 2016 - 41
IBM Systems Magazine, Mainframe - November/December 2016 - 42
IBM Systems Magazine, Mainframe - November/December 2016 - 43
IBM Systems Magazine, Mainframe - November/December 2016 - Tech Corner: Get in the Cloud: z/OS solutions can connect to the cloud through REST interfaces
IBM Systems Magazine, Mainframe - November/December 2016 - 45
IBM Systems Magazine, Mainframe - November/December 2016 - 46
IBM Systems Magazine, Mainframe - November/December 2016 - Solutions: API Integration Platform 3.0, OpenLegacy; Ivory Service Architect V5.1, GT Software
IBM Systems Magazine, Mainframe - November/December 2016 - Stop Run: Code Your Own Way: High school girls take charge of their futures
IBM Systems Magazine, Mainframe - November/December 2016 - Cover3
IBM Systems Magazine, Mainframe - November/December 2016 - Cover4
IBM Systems Magazine, Mainframe - November/December 2016 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - November/December 2016 - RF2
IBM Systems Magazine, Mainframe - November/December 2016 - Linux on z Systems E-book
IBM Systems Magazine, Mainframe - November/December 2016 - L2
IBM Systems Magazine, Mainframe - November/December 2016 - L3
IBM Systems Magazine, Mainframe - November/December 2016 - L4
IBM Systems Magazine, Mainframe - November/December 2016 - L5
IBM Systems Magazine, Mainframe - November/December 2016 - L6
IBM Systems Magazine, Mainframe - November/December 2016 - L7
IBM Systems Magazine, Mainframe - November/December 2016 - L8
IBM Systems Magazine, Mainframe - November/December 2016 - L9
IBM Systems Magazine, Mainframe - November/December 2016 - L10
IBM Systems Magazine, Mainframe - November/December 2016 - L11
IBM Systems Magazine, Mainframe - November/December 2016 - L12
IBM Systems Magazine, Mainframe - November/December 2016 - L13
IBM Systems Magazine, Mainframe - November/December 2016 - L14
IBM Systems Magazine, Mainframe - November/December 2016 - L15
IBM Systems Magazine, Mainframe - November/December 2016 - L16
IBM Systems Magazine, Mainframe - November/December 2016 - L17
IBM Systems Magazine, Mainframe - November/December 2016 - L18
IBM Systems Magazine, Mainframe - November/December 2016 - L19
IBM Systems Magazine, Mainframe - November/December 2016 - L20
IBM Systems Magazine, Mainframe - November/December 2016 - L21
IBM Systems Magazine, Mainframe - November/December 2016 - L22
IBM Systems Magazine, Mainframe - November/December 2016 - L23
IBM Systems Magazine, Mainframe - November/December 2016 - 2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2016 - SE2
IBM Systems Magazine, Mainframe - November/December 2016 - SE3
IBM Systems Magazine, Mainframe - November/December 2016 - SE4
IBM Systems Magazine, Mainframe - November/December 2016 - SE5
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
http://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
http://www.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
http://www.nxtbookMEDIA.com