SELECT JOBNAME, ICTYPE, COUNT(*), MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY C WHERE DBNAME $DBIN GROUP BY JOBNAME, ICTYPE ORDER BY 1, 2 ;