SELECT TSNAME, COUNT(DISTINCT NAME) FROM SYSIBM.SYSTABLES WHERE TYPE='T' AND CREATOR='XXXX' GROUP BY TSNAME WITH UR;

SELECT  SUM(4*NACTIVE) FROM SYSIBM.SYSTABLESPACE WHERE NAME IN
(SELECT TSNAME FROM SYSIBM.SYSTABLES WHERE TYPE='T' AND CREATOR='XXXX' AND NAME IN
 ('XXXCAP','XXXXTUH', 'XXXXTUS')
) WITH UR;