Mainframe, MVS and zOS Discussion

Posted: **Fri Oct 02, 2015 11:26 pm**

Hi all,

What is the way to find all the views that are created for a particular DB2 Table? Can you please help me to know how can I identify that?

Posted: **Sat Oct 03, 2015 12:36 am**

1.Check SYSIBM.SYSVIEWS
2.If you have access to ADMIN TOOL/PLATINUM/BMC the information can be retrieved as well

Find all VIEWS for a table in DB2.