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

ADMINISTRATOR

It can also deliver new data
caching capabilities, such
as within objects held on a
dashboard. Dashboard objects
may be defined as "refresh
always" so the underlying
query always goes back to the
database. Or, should the data be
relatively static, query results
can be cached for subsequent
sharing and reduced overhead on
the underlying database.

Flip the Switch
With the accelerator, IBM
testing shows that queries
run, on average,

The new features have very
sophisticated analytics
capabilities. However, many
clients have an inventory of
QMF objects-queries, forms,
procedures-that have been
around for a long time. These
objects may be leveraged with the
new features. For example, a query
stored under TSO can be invoked
with the workstation or Web

Take Another Look

1,000x
faster

Interoperability
Among Components

(screen combination) is available
to present and mimic the look
and feel of TSO and CICS. In the
case of extensive host-based
functions embedded within QMF
objects-stored procedures, userdefined functions, REXX, etc.-a
new TSO command allows the
user to tell QMF to execute this
on the server rather than on the
workstation or the Web.

component and used to feed a new
graphical report or dashboard.
This can ensure investment
protection and asset reuse for longstanding QMF customers.
For end users who don't wish
to learn the newly available
interface styles, a perspective

This discussion only touches
on some of the interesting new
capabilities with QMF Enterprise
Edition. Those who haven't
examined QMF in a while should
take a second look; this isn't the
QMF you might remember. It
provides the business analytics
features, functions and options
required in any enterprise. It's a
low-cost and high-performance
solution geared toward today's
analytics market.

QMF Enterprise Edition Components
QMF Enterprise
consists of
four main
components:

ONLINE

1
QMF Classic
Edition for TSO
and CICS-the
3270 interface
running under z/OS

2

3

4

QMF High
Performance
Option-offering
administration
and management
functions as well
as the capability
to compile QMF
objects into highly
efficient COBOL
applications

QMF for
Workstation-
a rich client GUI
based on Eclipse
with a multitude
of new analytic
functions

QMF for
WebSphere-the
thin client version
running under a
Web application
server, such as
WebSphere or
Apache Tomcat

For more information, visit:

➜ IBM DB2 Query Management Facility at ibm.com/software/products/us/en/qmf ➜ QMF on The World of DB2 at http://bit.ly/19xvNwj

38 // NOVEMBER/DECEMBER 2013 ibmsystemsmag.com


http://www.ibm.com/software/products/us/en/qmf http://bit.ly/19xvNwj 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