473,508 Members | 2,195 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Find out if index was dropped in Db2 LUW

4 New Member
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
Dec 19 '18 #1
4 4805
Luuk
1,047 Recognized Expert Top Contributor
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
pjbr34
4 New Member
Hi Luuk, thanks for your answer. Can you please share the link you found?
Jan 8 '19 #3
Luuk
1,047 Recognized Expert Top Contributor
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
Jan 11 '19 #4
pjbr34
4 New Member
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
Jan 16 '19 #5

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

Similar topics

2
2784
by: Sean Berry | last post by:
Given myList = what is the easiest way to find out what index 'dog' is at?
11
2809
by: ike | last post by:
Could you please give your opinion on the portability of this code? /* -------- begin findindex.c -------- */ struct Foo { int junk0; }; struct Bar { int junk1; struct Foo foo; int junk2; }; ...
8
1662
by: mike | last post by:
what should i have to write in this code section? #### is what i want to write do i have to use foreach to for if options is TextBox array i used to enumbera....... but i don't...
10
11117
by: cmrhema | last post by:
hello I am working in asp.net and C# I am selecting multiple items in a list box. Now I want a count of the seleted items also the index of the selected item I browsed and found something...
2
4813
by: GS | last post by:
I want to create a dropdownlistbox in my windows form with name value pair. but I need to initialize its initial selected value to a value from database for the record. I was going to just use...
1
2572
by: Lorna | last post by:
I have a table on a form containing 2 columns - size type and size. Depending on the size type (Mens, womens, Youth) I want to change the set of sizes available (in an option box). I have been able...
5
2033
by: zcabeli | last post by:
Hello, how can i find the index of an existing element in a list ? thanks,
4
9969
by: raylopez99 | last post by:
I would like to know if there's a quick "Linq" way to find the index of an array having a particular value. I can do this the long way by sequential iteration, but would like to know if there's a...
6
17676
by: ashiela | last post by:
i need to find the max position of my program. how can i do that? int main() { int j,max=0,k; for(k=0;k<=9;k++) { printf("Enter the number:"); scanf("%d", &j); }
0
1157
by: sharavanan | last post by:
Is there any way to find ipv6 address index value from corresponding ipv6 subnet. i.e., I have one ipv6 subnet and list of IPs(take may 1000000 IPs). If I give one ipv6 address then code should...
0
7127
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7331
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7391
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7054
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5633
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3204
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1564
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
768
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
424
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.