on Z/OS
SELECT COLTYPE, COUNT (*)
  FROM SYSIBM.SYSCOLUMNS
 WHERE TBCREATOR = 'FCTMDT9'
GROUP BY COLTYPE
  WITH UR;

on LUW
SELECT TYPENAME,COUNT(*)
FROM SYSCAT.COLUMNS
WHERE TABSCHEMA='FCTMDT9'
GROUP BY TYPENAME
WITH UR;