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
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.