[progress Communities] [progress Openedge Abl] Forum Post: Re: Index Reads

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> if there any concerns to running idxcompact for a live production database w/OE replication running. If you need only to fix the issue with the index entry locks then you can run idxcompact with the smallest value of the index utilization parameter - namely 50. As a first step it will get rid of Index Delete Chain. It will not "de-utilize" the index blocks but will remove the obsolete index entry locks. How many blocks were on Index Delete Chain of index #1512?

Continue reading...
 
Status
Not open for further replies.
Back
Top