Configuring QMF Data Service (QDS)

QMF for z/OS® and QMF Enterprise Edition users can use the QMF Data Service feature to access non-Db2 data such as VSAM, IMS, sequential files, SMF data, SYSLOG data and more.

Before you begin

The QMF Data Services component, available to QMF for z/OS and QMF Enterprise Edition users, must be installed and available to the QMF for TSO and CICS® environment. Data sources must be defined to QMF Data Service. The QMF for TSO and CICS global variable DSQEC_DS_SUPPORT must be set to a value of 1. See the IBM Db2 QMF Data Service Getting Started Guide for more complete instructions on installing the QDS component and configurations including binding packages and allocating proper QDS libraries. These tasks must be performed for the QDS and QMF for TSO and CICS configuration to be complete.

About this task

Through QMF for TSO/CICS SQL queries, Prompted queries, or Query-by-example queries, you can access QMF Data Service defined data sources using three part names; QMF Data Service data sources are accessed through three part table names in the query.

For example, you might access a VSAM data set defined to a QMF Data Service server named CQDR by issuing the following query:

SELECT * FROM  CQDR.CQDSQL.VSAM_IMITMTRN

QMF Data Service might join one or more sources that exist at the server. SQL accepted by QMF Data Service is a subset of SQL accepted by Db2® for z/OS. Refer to the QMF Data Service SQL guide for accepted SQL syntax.

To use QMF Data Service, you must set the QMF for TSO and CICS global variable DSQEC_DS_SUPPORT to 1. The default value is 0, which indicates that you do not want to allow access to QMF Data Service.

The DISPLAY TABLE, DRAW, EXPORT TABLE and PRINT TABLE commands may also be used to access QMF Data Service data sources. As with queries, the command must use a three part table name.

For example, you might access a VSAM data set defined to the QMF Data Service server CQDR by issuing the following command:

DISPLAY TABLE CQDR.CQDSQL.VSAM_IMITMTRN

When you set the DSQEC_DS_SUPPORT global variable to a value of '1', the QMF Data Service component analyzes the command. If an object that is referenced in the command is defined to the QMF Data Service component, then the entire command is executed by QMF Data Service. If none of the objects referenced in the command access an object defined to the QMF Data Service, then the command is executed by the current DB2 connection.