SQL: Find Source

In situations where we are seeking a specific source but lack its identification or location, this tool can assist. It will locate all copies of a source member on a box. While its speed may be moderate, its thoroughness is assured.

SELECT                                                   

CAST(system_table_schema AS CHAR(10)) AS SRCLIB,        

CAST(system_table_name AS   CHAR(10)) AS SRCFILE ,       

CAST(TABLE_PARTITION AS     CHAR(10)) AS SRCMBR,         

CAST(source_type AS         CHAR(10)) AS type,           

CAST(partition_text AS      CHAR(50)) AS text            

FROM                                                     

   QSYS2.SYSPARTITIONSTAT                               

WHERE                                                    

  TABLE_PARTITION  LIKE 'Member_Name';