By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 1,984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Find out if index was dropped in Db2 LUW

P: 4
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,
Dec 19 '18 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,022
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.
Dec 29 '18 #2

P: 4
Hi Luuk, thanks for your answer. Can you please share the link you found?
Jan 8 '19 #3

Expert 100+
P: 1,022

P: 4
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,
Jan 16 '19 #5

Post your reply

Sign in to post your reply or Sign up for a free account.