O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

In-Place Analytics with Live Enterprise Data with IBM DB2 Query Management Facility

Book Description

IBM® DB2® Query Management Facility™ for z/OS® provides a zero-footprint, mobile-enabled, highly secure business analytics solution. IBM QMF™ V11.2.1 offers many significant new features and functions in keeping with the ongoing effort to broaden its usage and value to a wider set of users and business areas. In this IBM Redbooks® publication, we explore several of the new features and options that are available within this new release.

This publication introduces TSO enhancements for QMF Analytics for TSO and QMF Enhanced Editor. A chapter describes how the QMF Data Service component connects to multiple mainframe data sources to accomplish the consolidation and delivery of data.

This publication describes how self-service business intelligence can be achieved by using QMF Vision to enable self-service dashboards and data exploration. A chapter is dedicated to JavaScript support, demonstrating how application developers can use JavaScript to extend the capabilities of QMF. Additionally, this book describes methods to take advantage of caching for reduced CPU consumption, wider access to information, and faster performance.

This publication is of interest to anyone who wants to better understand how QMF can enable in-place analytics with live enterprise data.

Table of Contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. IBM Redbooks promotions
  4. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  5. Chapter 1. Introducing IBM DB2 Query Management Facility for z/OS
    1. 1.1 What is new in IBM Query Management facility for z/OS and why do I care?
    2. 1.2 Setting the stage for data access
    3. 1.3 Self-service business analytics, what and why?
    4. 1.4 Caching in QMF and the use of JavaScript
    5. 1.5 TSO enhancements
      1. 1.5.1 QMF Analytics for TSO: New business charts and analytics
      2. 1.5.2 QMF Enhanced Editor
  6. Chapter 2. Virtualizing data by using QMF Data Service
    1. 2.1 Overview of QMF Data Service
      1. 2.1.1 Why is QMF Data Service useful?
    2. 2.2 Configuring access to the data
      1. 2.2.1 Time guidance
      2. 2.2.2 Configuring access to DB2
      3. 2.2.3 Configuring access to IMS data
      4. 2.2.4 Configuring access to VSAM data
    3. 2.3 Using QMF Data Service Studio to create virtual tables
      1. 2.3.1 Initial setup
      2. 2.3.2 Virtualize the DB2 data
      3. 2.3.3 Virtualize IMS data
      4. 2.3.4 Virtualize the VSAM data
    4. 2.4 Accessing the QMF Data Service data
      1. 2.4.1 Creating a QMF Data Service data source in QMF
    5. 2.5 Additional considerations
    6. 2.6 Summary
  7. Chapter 3. Using self-service business intelligence
    1. 3.1 QMF Vision installation summary
      1. 3.1.1 Time guidance
      2. 3.1.2 Recommended personnel
      3. 3.1.3 Back-end activities
      4. 3.1.4 Architecture
    2. 3.2 Interface
      1. 3.2.1 User access
      2. 3.2.2 User administration
    3. 3.3 Accessing data
      1. 3.3.1 Using QMF WebSphere
      2. 3.3.2 Connecting to QMF Data Service
    4. 3.4 Creating your visualizations
      1. 3.4.1 Understanding the initial home window
      2. 3.4.2 Building a dashboard
      3. 3.4.3 Reports and working with data
      4. 3.4.4 Editing or replacing a query
      5. 3.4.5 Coordinated highlighting and associations
    5. 3.5 Collaboration
      1. 3.5.1 Sharing data sources, queries, and dashboards
      2. 3.5.2 Built-in messaging
  8. Chapter 4. Using JavaScript in QMF
    1. 4.1 Using JavaScript tables to access data on the web
      1. 4.1.1 Overview of JavaScript tables
      2. 4.1.2 Creating a JavaScript table
      3. 4.1.3 Populating the JavaScript table
      4. 4.1.4 Using the JavaScript table
    2. 4.2 Using JavaScript functions in calculations, visual dashboards, and visual reports
      1. 4.2.1 Creating a JavaScript module
      2. 4.2.2 Using a JavaScript module in a calculated column
      3. 4.2.3 Using a JavaScript module in a visual application
    3. 4.3 JavaScript procedures
  9. Chapter 5. Caching
    1. 5.1 Query caching
      1. 5.1.1 User experience: QMF for Workstation
      2. 5.1.2 User experience: QMF for WebSphere
      3. 5.1.3 Cache use case 1
      4. 5.1.4 Cache use case 2
      5. 5.1.5 Cache use case 3
      6. 5.1.6 Cache use case 4
    2. 5.2 Dynamarts
      1. 5.2.1 User experience: QMF for Workstation dynamarts
      2. 5.2.2 User experience: QMF for WebSphere dynamarts
      3. 5.2.3 Dynamart use case 1
      4. 5.2.4 Dynamart use case 2
    3. 5.3 Virtual data sources
      1. 5.3.1 Setting up a virtual data source
      2. 5.3.2 User experience: Virtual Data sources
    4. 5.4 Summary of caching types
  10. Chapter 6. Key TSO enhancements
    1. 6.1 QMF Analytics for TSO
      1. 6.1.1 Chart options
      2. 6.1.2 Statistical analyses options
    2. 6.2 QMF Enhanced Editor
      1. 6.2.1 Invoking editing options in QMF
  11. Appendix A. Additional material
    1. Locating the web material
    2. Downloading and extracting the web material
  12. Related publications
    1. IBM support and publications
    2. Help from IBM
  13. Back cover