Just Programing!

select c.tabschema as schema_name,c.tabname as table_name
from syscat.columns c
    inner join syscat.tables t on
    t.tabschema = c.tabschema and t.tabname = c.tabname
where c.colname = 'XXXXXX'
    and t.type = 'T'
order by schema_name,
table_name;