Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unanswered: which system catalog view contains the backup information.

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •