Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2013
    Location
    Toronto, Canada
    Posts
    23

    Exclamation Unanswered: v10.5 How to look at config history for the DB to see when it changed

    Hello, in db2 10.5 I need to look at the DB CFG config history for a database and find out when a particular DB cfg changed and to what it changed to. Is there a way to do this? thanks

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    you could parse the diagnostic log file(s), depending on your retention policies for them, and the historic-period of interest.
    Changes that happen automatically , such as STMM related settings, may have separate log files to be parsed. I think the dbm by itself does not persist change-historic-detail inside tables.

  3. #3
    Join Date
    Oct 2013
    Location
    Toronto, Canada
    Posts
    23
    Thanks for your response.. Is it this file? SQLDBCONF .. even though I've parsed it how do I know how much value is changed? How do we understand the meaning?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The diagnostic log is usually called db2diag.log
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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