Db2 Tools for z/OS

 View Only

LinkedIn Share on LinkedIn

QMF 13.1.1 new features and capabilities pack a punch!

By Poorva Abhyankar posted Mon August 21, 2023 03:38 AM

  

From supporting multiple data sources to enabling the import and export of data in new file formats, the latest release of IBM Db2 Query Management Facility (QMF 13.1.1) packs a punch. The new features and enhancements made in QMF for Workstation, QMF for WebSphere, and QMF Server further extend QMF’s capabilities and resilience. These features can be leveraged across all QMF offerings.


Here's what you can look forward to in QMF 13.1.1:

Simplified rollout

The configuration rollout of QMF for Workstation related to Repository Connections and the JDBC library has been simplified. Administrators can monitor the new configuration rollout on the QMF Server UI by using the Message Groups view.

Message Groups – With this new view, administrators can monitor the new configuration rollout on the QMF Server UI.

                               Message Groups – With this new view, administrators can monitor the new configuration rollout on the QMF Server UI.

Support for databases and data sources

QMF 13.1.1 adds to its already-comprehensive list of supported databases and data sources.

Newly supported databases and data sources                                Newly supported databases and data sources

  • Cloudant: You can perform all the CRUD operations on Cloudant documents and Cloudant indexes.
  • Spark: All the QMF objects are supported with Spark. The current JDBC interface for Spark supports running queries and fetching results.
  • Snowflake: All QMF objects are now supported by Snowflake, along with Amazon Athena and Amazon RedShift.
  • Avro and Parquet file formats: You can now import and export data in these file formats.

User productivity enhancements

Several user productivity enhancements have been made to boost the flexibility and capability of QMF for Workstation and QMF for WebSphere:

  • Both components can be installed on Windows 11 and Linux 8 operating systems and are supported with the Java 11 runtime environment.
  • Error messages for QMF procedures are enhanced with line numbers and the error cause to simplify troubleshooting.
  • A new view called JS Procedure log view is added to improve the error reporting of JavaScript procedures.
  • You can now see the application name of the current client when you run a query on the Db2 database by specifying the application name in the clientprogramName field on the JDBC Advanced Properties dialog box.
  • The global variables of QMF for TSO and CICS that begin with DSQ are now better handled in QMF for WebSphere.

To know more about these new features and enhancements, see What’s new in QMF 13.1.1.

Improvements in QMF documentation

The QMF 13.1.1 documentation site has been modified to help you easily access information. 

  • If you are new to QMF, read the Products in the QMF Family page to learn the various offerings that are available in the QMF solution.
  • To download the guides for installing, managing, and using the QMF components, use the QMF manuals (PDF format) page. 
As you work with this powerful new version of QMF, refer to the following page for additional information on QMF 13.1.1:


To try out these new features, upgrade now to QMF 13.1.1. 
0 comments
88 views

Permalink