ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Query PRF Reports/Objects for DB2 tables


Article ID: 223692


Updated On:


Compile/PRF for TSO


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

Component :


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.