Unable to add repositories to users - 12.1.6.223 Web Viewer - RHEL

Products

• Output Management Web Viewer

Issue/Introduction

Getting an error when trying to save a changed parameter value. After some research, we found that some of DB2 tables (actually the underlining VSAM files had gotten deleted). 

So I had our DB2 recreate everything that was missing. However, that apparently removed the repositories from all users. When I try to add any of them back in I am getting an error message.

Maybe a DB2 subsystem problem?  

Environment

Release : 12.1

Component : OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

Resolution

Demonstrated a DB2 DB issue was causing the problem, Applied new (Broadcom Support provided) DB2 DDL for Web Viewer. The DBA found that the "foreign keys" were missing in DB2, and since they were created, there's been no further problem adding/maintaining repositories.