Is it possible to query through PRF, Objects/Reports to see if a specific db2 table is used in them?
Also to find out which PRF Objects/Reports are using a specific db2 table in them?
Release : 20.0
query the PTPRF_STR_vvrr Db2 table of PRF and filter rows for PRF_TYPE = 'QERY' AND PRF_STRUC_TYPE = 'QTBL----'.
On obtaining the SELECT results, you can then find the PRF query name under the PRF_NAME column, and the corresponding Db2 tables under the PRF_DATA column.
The PRF_DATA column has some additional data too.