WHICH DSQ REQUESTS ARE NEEDED FOR SYSVIEW PM INTEGRATION?

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

In STARTUP member, which DSQ* requests (if any) are required for SYSVIEW PM integration? 

SOURCE(STARTUP) ...
#IF XNETAGT INCLUDE 'DSQALERT'
INCLUDE 'DSQAPMAS'
#IF DATASHR INCLUDE 'DSQAPMGS'
#IFEND
INCLUDE 'DSQAPMSS'
INCLUDE 'DSQCONN '
INCLUDE 'DSQCONT '
INCLUDE 'DSQDLTO '
INCLUDE 'DSQDSETS'
INCLUDE 'DSQDYNSQ'
INCLUDE 'DSQDYNSL'
INCLUDE 'DSQDYNTX'
INCLUDE 'DSQERRM'
INCLUDE 'DSQLOCKS'
INCLUDE 'DSQLOGAL'
INCLUDE 'DSQLOGST'
INCLUDE 'DSQPARMS'
INCLUDE 'DSQPLNSS'
INCLUDE 'DSQPRGBP'
INCLUDE 'DSQPRMBP'
INCLUDE 'DSQSTATS'
INCLUDE 'DSQSTBP'
INCLUDE 'DSQSTG'
INCLUDE 'DSQSTGBP'
INCLUDE 'DSQSTIFC'
INCLUDE 'DSQSTIFI'
INCLUDE 'DSQSTLOC'
INCLUDE 'DSQSYSOA'
INCLUDE 'DSQSYSOD'
INCLUDE 'DSQTACT '
INCLUDE 'DSQTHD '
INCLUDE 'DSQTHDBP'
INCLUDE 'DSQTHDGB'
INCLUDE 'DSQTHDLK'
INCLUDE 'DSQTHDPK'
INCLUDE 'DSQTHDRL'
INCLUDE 'DSQTHDSQ'
INCLUDE 'DSQTHDSL'
#IFEND 

Environment

Release:
Component: CIDB

Resolution

The requests inside the #IF SYSVIEW and #IFEND statements are the ones needed to have active for metrics to be passed to Sysview.

#IF XNETAGT INCLUDE 'DSQALERT'
INCLUDE 'DSQAPMAS'
#IF DATASHR INCLUDE 'DSQAPMGS'
#IFEND
#IF SYSVIEW
INCLUDE 'DSQDSETS'
INCLUDE 'DSQDYNSQ'
INCLUDE 'DSQERRM'
INCLUDE 'DSQLOGAL'
INCLUDE 'DSQLOGST'
INCLUDE 'DSQPARMS'
INCLUDE 'DSQPRGBP'
INCLUDE 'DSQPRMBP'
INCLUDE 'DSQSTBP'
INCLUDE 'DSQSTG'
INCLUDE 'DSQTACT '
INCLUDE 'DSQTHD '
#ELSE
INCLUDE 'DSQAPMSS'
INCLUDE 'DSQCONN '
INCLUDE 'DSQCONT '
INCLUDE 'DSQDLTO '
INCLUDE 'DSQDSETS'
INCLUDE 'DSQDYNSQ'
INCLUDE 'DSQDYNSL'
INCLUDE 'DSQDYNTX'
INCLUDE 'DSQERRM'
INCLUDE 'DSQLOCKS'
INCLUDE 'DSQLOGAL'
INCLUDE 'DSQLOGST'
INCLUDE 'DSQPARMS'
INCLUDE 'DSQPLNSS'
INCLUDE 'DSQPRGBP'
INCLUDE 'DSQPRMBP'
INCLUDE 'DSQSTATS'
INCLUDE 'DSQSTBP'
INCLUDE 'DSQSTG'
INCLUDE 'DSQSTGBP'
INCLUDE 'DSQSTIFC'
INCLUDE 'DSQSTIFI'
INCLUDE 'DSQSTLOC'
INCLUDE 'DSQSYSOA'
INCLUDE 'DSQSYSOD'
INCLUDE 'DSQTACT '
INCLUDE 'DSQTHD '
INCLUDE 'DSQTHDBP'
INCLUDE 'DSQTHDGB'
INCLUDE 'DSQTHDLK'
INCLUDE 'DSQTHDPK'
INCLUDE 'DSQTHDRL'
INCLUDE 'DSQTHDSQ'
INCLUDE 'DSQTHDSL'
#IFEND
#IFEND .