424,066 Members | 2,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,066 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,
4 Weeks Ago #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 964
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.
3 Weeks Ago #2

P: 4
Hi Luuk, thanks for your answer. Can you please share the link you found?
1 Week Ago #3

Expert 100+
P: 964

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,
5 Days Ago #5

Post your reply

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