QMF for z/OS V12
and QMF Enterprise Edition
V12 adds a new component called QMF Data Service. QMF for TSO and CICS users can use QMF Data
Service to access Db2 and non-Db2 data such as VSAM, IMS™, sequential files, SMF data, SYSLOG data
and more. See the Db2 QMF Data Service Solution Configuration Guide for a complete list of data
sources that can be accessed.
Before you begin
- Install, configure and run the installation verification procedure (IVP) for QMF Data Service.
See the Db2 QMF Data Service Customization Guide for more information.
- For QMF for TSO users, install, configure and run the installation verification procedure for
QMF for TSO V13.1 in at least one Db2 for z/OS requester.
- For QMF for CICS users, install, configure and run the installation verification procedure for
QMF for CICS V13.1.
Procedure
Customizing the QMF for TSO and CICS connection for QMF Data Service involves binding
an additional package, allocating load libraries (TSO implementations only) and adding the QMF Data
Service program definitions to an existing QMF for CICS region (CICS implementations
only).
-
Bind the database package required for QMF Data Service access. The package must be bound in
all Db2 for z/OS systems to which you want to connect to a QMF Data Service server through QMF for
TSO or QMF for CICS. Customize and submit the job found in QMF1310.SDSQSAPE(DSQ1BPKQ).
-
For QMF for TSO implementations only: Update an existing QMF for TSO environment to add
the QMF Data Service library, CQD.SCQDLOAD to either STEPLIB or ISPLLIB.
-
For QMF for CICS implementations only: The following steps for defining CICS program
definitions and updating DFHRPL should be added to an existing QMF for CICS region that has been
successfully installed and tested.
- Customize the job found in QMF1310.SDSQSAPE(DSQ1ECSQ) according to the comments found in the
beginning of the job. Submit the job to successful completion.
- Add the QMF Data Service library, CQD.SCQDCLOD, to the DFHRPL concatenation. For
example:
//DFHRPL DD ...
// DD DSN=QMF1310.SDSQEXIT,DISP=SHR
// DD DSN=QMF1310.SDSQLOAD,DISP=SHR
// DD DSN=GDDM.SADMMOD,DISP=SHR
// DD DSN=DSN1310.SDSNEXIT,DISP=SHR
// DD DSN=DSN1310.SDSNLOAD,DISP=SHR
// DD DSN=CQD.SCQDCLOD,DISP=SHR
-
Verify the QMF Data Service connection. To begin the verification, start QMF.
Note: Ensure that the sample virtual table staffvs exists in the QMF Data Service server.
Table staffvs would have been created during installation and verification of the QMF Data Service
server. See the Verifying the server installation section of the Db2 QMF Data
Service Customization Guide for more information on staffvs.
-
Enter the following command on the command line:
SET GLOBAL (DSQEC_DS_SUPPORT=1
-
Run the following SQL query where cdqs is the name of the QMF Data Service
server:
SELECT * FROM cqds.CQDSQL.STAFFVS
A report similar to the one below displays.
REPORT LINE 1 POS 1 159
STAFFVS
STAFFVS DATA STAFFVS STAFFVS STAFFVS STAFFVS
KEY NAME DATA DATA DATA DATA
ID L NAME DEPT JOB YRS
------- ------- --------- ------- ------- -------
10 7 SANDERS 20 MGR 7
20 6 PERNAL 20 SALES 8
30 8 MARENGHI 38 MGR 5
40 7 O'BRIEN 38 SALES 6
50 5 HANES 15 MGR 10
60 7 QUIGLEY 38 SALES 0
70 7 ROTHMAN 15 SALES 7
80 5 JAMES 20 CLERK 0
90 7 KOONITZ 42 SALES 6
100 5 PLOTZ 42 MGR 7
110 4 NGAN 15 CLERK 5
120 8 NAUGHTON 38 CLERK 0
130 9 YAMAGUCHI 42 CLERK 6
140 5 FRAYE 51 MGR 6
150 8 WILLIAMS 51 SALES 6
160 8 MOLINARE 10 MGR 7
170 8 KERMISCH 15 CLERK 4
180 8 ABRAHAMS 38 CLERK 3
190 7 SNEIDER 20 CLERK 8
200 8 SCOUTTEN 42 CLERK 0
210 2 LU 10 MGR 10
220 5 SMITH 51 SALES 7
230 9 LUNDQUIST 51 CLERK 3
240 7 DANIELS 10 MGR 5
250 7 WHEELER 51 CLERK 6
260 5 JONES 10 MGR 12
270 3 LEA 66 MGR 9
280 6 WILSON 66 SALES 9
290 5 QUILL 84 MGR 10
300 5 DAVIS 84 SALES 5
310 6 GRAHAM 66 SALES 13
320 8 GONZALES 66 SALES 4
330 5 BURKE 66 CLERK 1
340 7 EDWARDS 84 SALES 7
350 6 GAFNEY 84 CLERK 5
*** END ***
1=Help 2= 3=End 4=Print 5=Chart 6=Query
7=Backward 8=Forward 9=Form 10=Left 11=Right 12=
OK, this is the REPORT from your RUN command.
COMMAND ===>