SELECT CURRENT TIMESTAMP - 3 MINUTES, 00010002
CHAR(' A000Y001 OA1P.TADM62A1 ' , 50) 00020002
FROM SYSIBM.SYSDUMMY1 00030000
; 00040000
SELECT C.DBNAME, C.TSNAME, C.DSNUM, C.TIMESTAMP, C.ICTYPE, C.DSNAME, 00050000
CHAR(C.COPYPAGESF * 1024 * S.PGSIZE) COPIED 00060000
FROM SYSIBM.SYSCOPY C, SYSIBM.SYSTABLESPACE S 00070000
WHERE C.ICTYPE IN ('F', 'I') 00080000
AND S.DBNAME = C.DBNAME 00090000
AND S.NAME = C.TSNAME 00100000
ORDER BY 1, 2, 3, 4 DESC 00110000
WITH UR 00120000
; 00130000