Find out if index was dropped in Db2 LUW

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pjbr34
    New Member
    • Feb 2006
    • 4

    #1

    Find out if index was dropped in Db2 LUW

    Hi, when you drop a table in DB2 LUW it is at least logged in the history file so you can find out if and when was it dropped.

    But if anybody drops an index, where is it logged (if it is)? How can I keep track of dropped indexes?

    Thanks in advance,
    Raul
    Last edited by pjbr34; Dec 19 '18, 10:57 AM. Reason: Missed thank you statement.
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    After googling for "DB2 LUW log of dropped index" I was able to find a promising result real quick. I cannot test because I do not have a DB2 database here.

    Comment

    • pjbr34
      New Member
      • Feb 2006
      • 4

      #3
      Hi Luuk, thanks for your answer. Can you please share the link you found?

      Comment

      • Luuk
        Recognized Expert Top Contributor
        • Mar 2012
        • 1043

        #4
        LIST HISTORY command
        https://www.ibm.com/support/knowledg.../r0001991.html

        Db2 log records
        https://www.ibm.com/support/knowledg.../r0001910.html
        which refers to: 'Create index, drop index log records'
        https://www.ibm.com/support/knowledg...024868__log005

        Comment

        • pjbr34
          New Member
          • Feb 2006
          • 4

          #5
          Thank you Luuk. Afaik List history command doesn't seem to provide info about deleted indexes (it does for deleted tables, but not indexes).

          And as to log records, I will drill down deeper to see what I find.
          Thanks for your help anyway.

          Best regards,
          PJBR

          Comment

          Working...