Find out if index was dropped in Db2 LUW

[pjbr34]

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

[Luuk]

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.

[pjbr34]

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

[Luuk]

LIST HISTORY command

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001991.html

Db2 log records

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.api.doc/doc/r0001910.html

which refers to: 'Create index, drop index log records'

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.api.doc/doc/r0024868.html#r0024868__log005

[pjbr34]

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