DINDEX not found in logical-logs
Hello my friends. I am trying to investigate some possible index deletion in 11.50.FC9W2GE engine. The issue is that I cannot find a DINDEX portion in my log files. I´ve tested an index creation (in 11.70.FC7GE) and a CINDEX record has appeared, just fine. But after index deletion (even after a manual checkpoint), I cannot find a DINDEX record in my logs. Does someone knows if the index deletion has been its flag renamed to something else? I´m looking for "INDEX" only records, nothing found until now. Thanks a lot. Regards.
Original post: Hello my friends. I am trying to investigate some possible index deletion in 11.50.FC9W2GE engine. The issue is that I cannot find a DINDEX portion in my log files. I´ve tested an index creation (in 11.70.FC7GE) and a CINDEX record has appeared, just fine. But after index deletion (even after a manual checkpoint), I cannot find a DINDEX record in my logs. Does someone knows if the index deletion has been its flag renamed to something else? I´m looking for "INDEX" only records, nothing found until now. Thanks a lot. Regards. Response: The DINDEX log record appears to only be used with old style attached indexes (the old behavior, not the new behavior where when you create an index it defaults to being detached...meaning it has it's own partition page and extents that are not shared with table data). So when you drop a detached index, there is no DINDEX record, there are only records for the deletes from the system catalogs, and some PERASE/ERASE records with the partition number of the index that's dropped. Jacques Renaut IBM Informix Advanced Support APD Team
Thanks, Jaques. I will have to search them all old production logs again, I´ve just found the ERASE/PERASE records in my test case. Thanks a lot. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: jrenaut@us.ibm.com > Subject: Re: DINDEX not found in logical-logs [31268] > Date: Tue, 27 Aug 2013 10:23:14 -0400 > > Original post: > > Hello my friends. > I am trying to investigate some possible index deletion in 11.50.FC9W2GE > engine. > The issue is that I cannot find a DINDEX portion in my log files. > > I´ve tested an index creation (in 11.70.FC7GE) and a CINDEX record has > appeared, just fine. But after index deletion (even after a manual > checkpoint), I cannot find a DINDEX record in my logs. > > Does someone knows if the index deletion has been its flag renamed to > something else? I´m looking for "INDEX" only records, nothing found until now. > > Thanks a lot. > Regards. > > Response: > > The DINDEX log record appears to only be used with old style attached indexes > (the old behavior, not the new behavior where when you create an index it > defaults to being detached...meaning it has it's own partition page and > extents that are not shared with table data). So when you drop a detached > index, there is no DINDEX record, there are only records for the deletes from > the system catalogs, and some PERASE/ERASE records with the partition number > of the index that's dropped. > > Jacques Renaut > IBM Informix Advanced Support > APD Team > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >