Forum Post: Re: Performance Degradation After Dump&load

  • Thread starter Thread starter Richard Banville
  • Start date Start date
Status
Not open for further replies.
R

Richard Banville

Guest
The new toss limit will be honored (acted on) as additional space is requested for new records or update of existing records requiring more space for this table. As blocks are encountered on the rm free chain that have less space than either the create limit or the toss limit they will be removed from the rm free chain. This action is amortized by up to 100 blocks removed from the chain per new space request (at which time a new cluster of free space will be requested). There are "tech support" maintenance ways to rebuild the rm free chain immediately through dbrpr but not something generally suggested as a normal maintenance operation.

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