Query PRF Reports/Objects for DB2 tables

Products

• Compile/PRF for TSO

Issue/Introduction

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?

 

Environment

Release : 20.0

Component :

Resolution

You can

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.