IBM Systems Magazine, Mainframe - November/December 2013 - (Page 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

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

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