SELECT COUNT(*), ICTYPE, CURRENT SERVER, CURRENT MEMBER 00001000
FROM SYSIBM.SYSCOPY 00002000
WHERE TIMESTAMP >= CURRENT TIMESTAMP - 1 DAY 00003000
GROUP BY ICTYPE ; 00004000
SELECT COUNT(*), ICTYPE, CURRENT SERVER, CURRENT MEMBER 00010000
FROM CHSKA000DBTF.SYSIBM.SYSCOPY 00011000
WHERE TIMESTAMP >= CURRENT TIMESTAMP - 1 DAY 00020000
GROUP BY ICTYPE; 00030000