Can any one tell me where Backup and restore information are store in DB2 UDB. My mean is to say, which system catalog tables are use to store such information.
If we are talking DB2 LUW, then the information is kept in the recovery history file: <database path>\NODE0000\SQLnnnnnn\rhist.asc. Can query this using the LIST HISTORY command.