Limit access to plans that require RR isolation level

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

After a recent issue with DSNESPRR obtaining numerous locks on an object, it was agreed to limit access to this plan and direct users too DSNESPUR or DSNESPCS plans. Is there any option in Sysview for DB2 to limit end users from executing the SYSVIEW plans that require RR isolation level?

Environment

z/os DB2

Resolution

The only option within Sysview/Db2 is probably the Exception system. Write an exception to flag any thread using the repeatable read (RR) isolation level (and optionally cancel it).

see documentation managing-exceptions