Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007

    Unanswered: db2 on windows (v9.5) backup history

    We have a Datamart on DB2 on Windows. I was asked recently to print the last 2 weeks worth of backup history for one of the databases in the datamart.

    I used this command: list history backup all for proddm
    Buit this only returned the last 5 entries (5 days worth)

    I checked my config file for history retention and it is set like this:
    "Recovery","REC_HIS_RETENTN","60","Recovery history retention period"

    Luckily, I had logs from the .bat files that call the SQL we use to do the actual backups..

    Obviously my history retention is set appropriately ... is there another command I can use to generate backup history reports? Something does not see right..

  2. #2
    Join Date
    May 2003
    Did you look at this parm?

    Number of database backups to retain (NUM_DB_BACKUPS) = 12

    db2 get db cfg for sample
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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