QMF activity at remote locations is recorded in the HPO Activity Log data sets. For example, suppose a QMF CONNECT command is followed by a RUN QUERY command. This RUN QUERY command will be tracked with an indicator that it was executed at the remote DB2 location (the target of the CONNECT statement). When processing the log records through the batch job, the Process data at remote locations? parameter determines whether or not the records should be processed at that remote location. An internal connection to the remote location is attempted and the DB2 activity log tables at that remote location will be updated as appropriate. The local DB2 activity log tables are not affected, regardless of the setting of the parameter, for this particular record.
Additional granularity is provided with two optional input DD cards. An INCLUDE DD * or EXCLUDE DD * card can be specified on the job step LOAD2 explicitly naming the locations to include or omit from processing. The Process data at remote locations? parameter must be set to Y; otherwise, the location DDs will be ignored. When it is set to Y, and neither DD is present, all remote locations will be processed.
The following sample JCL will process all records for DB2A, as well as all remote activity at DB2B and DB2C (assume LOCATION_ DB2A is location name for subsystem DB2A, etc.) Any other location records found in the file will be bypassed.
//... //LOAD2 EXEC PGM=RAAOMLD,PARM='DB2A,YYY' //STEPLIB DD DSN=QMFHPO.LOADLIB,DISP=SHR // DD DSN=DB2.LOADLIB,DISP=SHR //LOADMSGS DD SYSOUT=* //RAALOG DD DSN=SORTED.LOG,DISP=SHR //RAALOG2 DD DSN=SQL.LOG,DISP=SHR //INCLUDE DD * LOCATION_DB2A LOCATION_DB2B LOCATION_DB2C /* //...
The following JCL will process all records for DB2A, as well as all remote activity at any location except DB2B, which will be bypassed.
//... //LOAD2 EXEC PGM=RAAOMLD,PARM='DB2A,YYY' //STEPLIB DD DSN=QMFHPO.LOADLIB,DISP=SHR // DD DSN=DB2.LOADLIB,DISP=SHR //LOADMSGS DD SYSOUT=* //RAALOG DD DSN=SORTED.LOG,DISP=SHR //RAALOG2 DD DSN=SQL.LOG,DISP=SHR //EXCLUDE DD * LOCATION_DB2B /* //...