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
Gbag

On DB2 for z/OS that would be sysibm.syscopy. However on DB2 for Unix, Linux, and Windows only the syscat views are documented and there is no syscat.syscopy view (or equivalent). I am not sure where that information is stored, such as in an undocumented sysibm table (without a syscat view) or somewhere else.

You can of course use the "list history backup" command to get a list of backups taken.

The recovery history is stored in a file named db2rhist.asc dot something under the database path

./NODE0000/SQL00001/db2rhist.asc
./NODE0000/SQL00001/db2rhist.bak

There is a backup file also, in case , one gets corrupt ..

As an additional bit of info, whenever a backup is done, the recovery history information is also backed up and it is possible to restore only the recovery history file from the backup image (of course, the history will not be current, but still you have the option)

HTH

Sathyaram