WITH parent (TBNAME, REFTBNAME)
     AS (SELECT TBNAME, REFTBNAME
           FROM SYSIBM.SYSRELS
          WHERE     REFTBNAME = 'CTMTTRN'
                AND CREATOR = 'FCTMDT9'
                AND REFTBCREATOR = 'FCTMDT9'
         UNION ALL
         SELECT C.TBNAME, C.REFTBNAME
           FROM SYSIBM.SYSRELS C, parent P
          WHERE     C.REFTBNAME = P.TBNAME
                AND C.CREATOR = 'FCTMDT9'
                AND C.REFTBCREATOR = 'FCTMDT9')
SELECT DISTINCT TBNAME, REFTBNAME
  FROM parent
  WITH UR;