IBM Systems Magazine, Mainframe - November/December 2013 - 36

ADMINISTRATOR

TURNED UP to 11
QMF extends its analytics capabilities to help meet the demands of big data and mobile
BM DB2* Query Management Facility* (QMF*) Enterprise Edition V11 has extended
the reach of its predecessors by adding new and sophisticated analytics capabilities
to the enhancements provided by QMF 10. These include graphical queries and
reports, highly interactive dashboards (see Figure 1, page 37), new analytics functions,
and extensions to the user interface, such as mobile device support.

I

Mike Biere
is a senior
product specialist
for Rocket
Software and
a former IBM
marketing
manager for BI.

Over the years, QMF has been
a mainstay query and reporting
solution for many clients.
The emergence of numerous
business intelligence (BI)
and analytics solutions from
various sources has driven QMF
development to significantly
enhance the product.

QMF 11 Highlights
In light of big data initiatives,
QMF 11 offers enhanced text
analytics as well as extensions
for graphical and statistical
analysis for the host timesharing option (TSO) user. It now
supports access to numerous
data sources heretofore
unavailable, including JDBC
access to relational data (e.g.,
Oracle, Sybase, Informix*,
SQL Server) and non-relational
data such as IMS*; and online
analytical processing access
via XML for Analysis (XMLA)
to sources like Oracle Essbase,
Microsoft* Analysis Services
and SAP Business Information
Warehouse. QMF now

reaches into the business user
community with new functions
and a dramatically enhanced
user interface. Some of its
benefits are:

as a Web service or integrated
with other applications, such
as a corporate portal. QMF can
be easily integrated with other
business analytics offerings.

Ā *
à à à UDSKLFDOÃTXHULHVÃDQGÃUHSRUWVÃÃ
Ā (
à ÃÃà QKDQFHGÃVXSSRUWÃIRUÃWKHÃ
business user
Ā '
à ÃÃà DVKERDUGVÃDQGÃNH\Ã
performance indicators
Ā $
à ÃÃà GYDQFHGÃDQDO\WLFÃIXQFWLRQVÃ
and analysis
Ā Ã ÃÃÃ '%&ÃDFFHVVÃWRÃDQ\ÃUHODWLRQDOÃ
database management system
ĀÃÃÃ XOWLGLPHQVLRQDOÃDQDO\VLVÃGDWDÃ
à 0
support via XMLA
à ÃÃà SHUDWLRQDOÃ%,ÃHJÃ,06Ã
Ā 2
Adabas, etc.)
Ā +
à ÃÃà HWHURJHQHRXVÃGDWDEDVHÃDFFHVV
Ā
à ÃÃ)HGHUDWHGÃGDWDÃ
Ā
à ÃÃ0RELOHÃGHYLFHÃVXSSRUW

QMF in an Enterprise
Architecture

The workstation and Webbased components fit well within
an enterprise's architecture. The
workstation component is written
in the Java* language based on
the Eclipse platform. The Web
component may be embedded

36 // NOVEMBER/DECEMBER 2013 ibmsystemsmag.com

IT managers are keenly interested
in delivering low-cost, highvalue business analytics to
users throughout the enterprise.
However, the solutions they
promote must adhere to corporate
technology standards and be
deployable to a wider range
of end users than ever before.
QMF may be deployed under
System z*, CICS*, TSO, Linux*
on all platforms, Microsoft
Windows*, and Mac OS X. Its
costs are based on a known
metric as a feature of DB2 for
z/OS* but may be deployed on
any supported platform at no
additional cost.
Both System z technology
and new workstation/Web
components contain a deep set
of administration functions that


http://www.ibmsystemsmag.com

IBM Systems Magazine, Mainframe - November/December 2013

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

Table of Contents
Editor's Desk: On the road with analytics
IBM Perspective: Extending IBM's commitment to big data and analytics
Trends: IBM Capacity Management Analytics for zEnterprise cost-effectively ensures optimal performance
IT Today: IBM DB2 Analytics Accelerator V4.1 expands the value of high-performance analytics
Case Study: The State of Consolidation: Oklahoma improves service levels by consolidating its IT on zEC12
Cover Story: Big Data's Big Impact: zEnterprise hybrid technology helps redefine business analytics
Feature: The System z Crystal Ball?: Teach the mainframe to predict the future using analytics and automation
Tech Corner: Alternative metrics deliver a more complete view of hardware for server RFPs
Administrator: QMF extends its analytics capabilities to help meet the demands of big data and mobile
Solutions: TestBase; Vanguard Offline
Stop Run: Historic property has much to teach retired IBMer
Reference Point - Global Events, Education, Resources for Mainframe
2014 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2013 - Intro
IBM Systems Magazine, Mainframe - November/December 2013 - Cover1
IBM Systems Magazine, Mainframe - November/December 2013 - Cover2
IBM Systems Magazine, Mainframe - November/December 2013 - 1
IBM Systems Magazine, Mainframe - November/December 2013 - Table of Contents
IBM Systems Magazine, Mainframe - November/December 2013 - 3
IBM Systems Magazine, Mainframe - November/December 2013 - 4
IBM Systems Magazine, Mainframe - November/December 2013 - 5
IBM Systems Magazine, Mainframe - November/December 2013 - Editor's Desk: On the road with analytics
IBM Systems Magazine, Mainframe - November/December 2013 - 7
IBM Systems Magazine, Mainframe - November/December 2013 - IBM Perspective: Extending IBM's commitment to big data and analytics
IBM Systems Magazine, Mainframe - November/December 2013 - 9
IBM Systems Magazine, Mainframe - November/December 2013 - Trends: IBM Capacity Management Analytics for zEnterprise cost-effectively ensures optimal performance
IBM Systems Magazine, Mainframe - November/December 2013 - 11
IBM Systems Magazine, Mainframe - November/December 2013 - 12
IBM Systems Magazine, Mainframe - November/December 2013 - 13
IBM Systems Magazine, Mainframe - November/December 2013 - IT Today: IBM DB2 Analytics Accelerator V4.1 expands the value of high-performance analytics
IBM Systems Magazine, Mainframe - November/December 2013 - 15
IBM Systems Magazine, Mainframe - November/December 2013 - 16
IBM Systems Magazine, Mainframe - November/December 2013 - 17
IBM Systems Magazine, Mainframe - November/December 2013 - Case Study: The State of Consolidation: Oklahoma improves service levels by consolidating its IT on zEC12
IBM Systems Magazine, Mainframe - November/December 2013 - 19
IBM Systems Magazine, Mainframe - November/December 2013 - 20
IBM Systems Magazine, Mainframe - November/December 2013 - 21
IBM Systems Magazine, Mainframe - November/December 2013 - Cover Story: Big Data's Big Impact: zEnterprise hybrid technology helps redefine business analytics
IBM Systems Magazine, Mainframe - November/December 2013 - 23
IBM Systems Magazine, Mainframe - November/December 2013 - 24
IBM Systems Magazine, Mainframe - November/December 2013 - 25
IBM Systems Magazine, Mainframe - November/December 2013 - 26
IBM Systems Magazine, Mainframe - November/December 2013 - 27
IBM Systems Magazine, Mainframe - November/December 2013 - Feature: The System z Crystal Ball?: Teach the mainframe to predict the future using analytics and automation
IBM Systems Magazine, Mainframe - November/December 2013 - 29
IBM Systems Magazine, Mainframe - November/December 2013 - 30
IBM Systems Magazine, Mainframe - November/December 2013 - 31
IBM Systems Magazine, Mainframe - November/December 2013 - Tech Corner: Alternative metrics deliver a more complete view of hardware for server RFPs
IBM Systems Magazine, Mainframe - November/December 2013 - 33
IBM Systems Magazine, Mainframe - November/December 2013 - 34
IBM Systems Magazine, Mainframe - November/December 2013 - 35
IBM Systems Magazine, Mainframe - November/December 2013 - Administrator: QMF extends its analytics capabilities to help meet the demands of big data and mobile
IBM Systems Magazine, Mainframe - November/December 2013 - 37
IBM Systems Magazine, Mainframe - November/December 2013 - 38
IBM Systems Magazine, Mainframe - November/December 2013 - Solutions: TestBase; Vanguard Offline
IBM Systems Magazine, Mainframe - November/December 2013 - Stop Run: Historic property has much to teach retired IBMer
IBM Systems Magazine, Mainframe - November/December 2013 - Cover3
IBM Systems Magazine, Mainframe - November/December 2013 - Cover4
IBM Systems Magazine, Mainframe - November/December 2013 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - November/December 2013 - 2014 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2013 - SE2
IBM Systems Magazine, Mainframe - November/December 2013 - 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