Which system catalog view contains the backup information

[ifxtechie]

Hi,
Can anybody pls tell me which system catalog view contains the backup information. I know by using the file-structure or file name this can be evaluated, but I want to extract from system catalog tables.
thanks in advance
Ifxtechie

 

[stevexff]

Assume you mean the one that has details of all the image copies taken?

SYSIBM.SYSCOPY

 

[shaf1945]

My experience is DB2 v.7 OS390/ZOS. SYSIBM.SYSCOPY contains Image Copy rows. I use the following to list image copies.

SELECT DBNAME, TSNAME, DSNUM, ICTYPE, "TIMESTAMP", ICBACKUP
, DSNAME, HEX(START_RBA), SHRLEVEL, OTYPE
WHERE DBNAME LIKE '????????%'
AND TSNAME LIKE '????????%'
AND ICTYPE IN('F','I')
ORDER BY DBNAME, TSNAME, DSNUM, "TIMESTAMP" DESC
;