DB2 graphic QMF Version 8

Location Processing of HPO Activity Log Records

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.

Note:
If the parameter is set to Y, and the INCLUDE DD * card is present, the local location must be defined in the list of locations in order to process the local DB2 records.

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

Note:
Had the Process data at remote locations? parameter for either example above specified N for location processing (such as PARM='DB2A,YYN') the INCLUDE and EXCLUDE DD cards would have been ignored and only DB2A location records would have been processed.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004