Can each user have their own CA Sysview Performance Monitor for DB2 profile data set?

book

Article ID: 39448

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Question:

Is it possible for each user to have their own CA Sysview Performance Monitor for DB2 for z/OS (IDB2) profile data set so external security update authority is not required to the single profile data set by each user?

 

Answer:

The IDB2 profile data set is typically a global profile:

* Every user must have authority (through their user ID or a group ID) to update the CA Sysview for DB2 user profile data set.

The PROFILE data set is allocated to the TSO session via the INSIGHT clist INSPROF DD.

For example see CLIST member:
hlq.CDBACLS0(INSIGHT)

FREE FI(INSPROF)
ALLOC DDNAME(INSPROF) DA('hlq.IDB2.PROFILE') SHR

One suggestion would be to try the following with each user having their own allocated PROFILE data set:
ALLOC DDNAME(INSPROF) DA('&SYSUID..IDB2.PROFILE') SHR

Environment

Release:
Component: IDB2