We loaded about 80,000 rows of data into one of our tables the day before yesterday. Each row contains the content of a patent, so this is a lot of data. There are about 20 inverted metamorph indexes on the table. Though it took a while, all but two of those indexes seem now to be up to date. However, the two indexes involving the biggest column in the table (that is, the column that contains the largest amount of data) seem to be stuck in some kind of endless process. The .BTR file for them has the date/time stamp from the day of the data "load", but the remaining files for the index are dated from the last time we updated the indexes, which was about a year ago. Moreover, there are a number of temporary files (T04168a.btr, T04168a.data, T04168a.PID, etc.) that seem to get modified often (though they have very little content) AND there is an instance of monitor.exe that seems to be grinding away at a furious pace, consuming a lot of CPU cycles and memory. This has been going on for about 36 hours, but so far we've left it alone thinking that it might be normal. But I'm starting to think that it might not be!
My question is Will killing monitor.exe and/or all other Texis processes, so that we can simply drop and recreate these two indexes do any harm to the DATA ITSELF. It'll take quite a few hours to rebuild them from nothing, but it certainly won't take 36 and counting!
Thanks
My question is Will killing monitor.exe and/or all other Texis processes, so that we can simply drop and recreate these two indexes do any harm to the DATA ITSELF. It'll take quite a few hours to rebuild them from nothing, but it certainly won't take 36 and counting!
Thanks