Sysview PMO for Db2 (IDB2) experiencing severe degradation for Db2 data sharing groups (option 1, and option 5)

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

In Sysview Performance Management Option for Db2 for z/OS (IDB2) selecting active threads using wildcard Db* for ssid
encounters severe degradation, and when finally resolved only shows the primary ssid. This also applies when in
option 1 system statistics when selecting data sharing group.

Cause

The cause of the degradation is unknown.  However, the IDB2 data collector tasks had not been cycled for a while.

Resolution

Cycling the IDB2 Data Collector tasks corrected the degradation condition.