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

book

Article ID: 223692

calendar_today

Updated On:

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.