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

enable tracking, governing and
more. Security may be defined
by users, groups, etc., using
enterprise standards such as
Resource Access Control Facility,
Lightweight Directory Access
Protocol or Active Directory.
The strong affiliation with
DB2 for z/OS is maintained
with QMF-including support
for temporal data and the IBM
DB2 Analytics Accelerator.
QMF has the capability to
switch the accelerator on or
off, depending on the refresh
rate of the information the end
user requires. IBM testing with
the accelerator has shown that
queries run, on average, 1,000
times faster. Much of the work
assigned to batch processing
may now be considered for
immediate, interactive execution.
The highly successful DB2 V11
beta program included QMF as
part of its success. Demonstrable
performance improvements
as a result of the beta have
encouraged a rapid uptake of the
new version.

QMF 10 provided many new features, including
the capability to populate an Excel sheet with
one click and transfer query results, charts
and summaries. With QMF 11, free-form text
analytics is provided as well as numerous user
enhancements such as new wizards that walk
users through the steps required in various
processes. Dashboards are easier to construct
in QMF 11, thus allowing less-technical users
to create and maintain their own versions.
Scheduling of tasks has been enhanced for those
wishing to asynchronously execute tasks.

Metadata, Caching and More
QMF offers a new metadata layer with the
capability to isolate and insulate business users
from complex data definitions. It's possible to
define one set of metadata for different user
groups such that one query can be used against
different tables in the enterprise without changing
any of the query syntax.
Virtual data tables can be defined also, and
calculated values may appear as real elements in
results. Queries themselves may be considered
data sources. Thus, any potential source that
QMF can touch can be defined, managed and
controlled. Power users who don't need or want
this level of insulation can directly access data
sources without waiting for metadata definitions
to be created and tested.

Figure 1: QMF Dashboard Example

QMF
Analytics
for TSO
QMF 11 Enterprise Edition
provides new charting
and statistical analysis
capabilities directly on
TSO-all menu-driven for
ease of use. These include:
s .EW CHARTING
capabilities, including
geospatial maps,
histograms, and pie,
plot and tower charts
s %NHANCED STATISTICAL
analysis, such as curve
fitting, discounted cash
flow, linear trending and
forecasting
s !N EASY
TO
USE
interface with self-guided,
menu-driven, parameterselection panels
s 3EAMLESS INTEGRATION
with existing QMF for
TSO environments, which
is easily invoked with
THE 3(/7 !.!,94)#3
command

ibmsystemsmag.com NOVEMBER/DECEMBER 2013 // 37


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