Re: HDR unusable with 9.40
Posted in 2004
Topics: High Availability & Replication, Logging & Checkpoints
Alexey Sonkin wrote: > Some good news on subj > > Informix support told me, that bug# 167294 is fixed in > 9.40uc5 and patch release 9.40uc4w4 (Intermediate release, > not fully tested) > > IBM opened 9.40uc4w4 for download for me, and I was able to > re-run my index creation tests under 9.40uc4w4 ( in exactly > the same database and server configuration) > > All indexes were successfully built!!! > > IBM definitely specifically addressed the 'checkpoint > generated on secondary by 75% fullness of the physical log' > issue: in the new version, few seconds after the index build > is finished on primary and index transfer to secondary is started, > IDS is starting some 'special' checkpoint on primary (this checkpoint > happenned for all 15 indexes I've built) > > Is there any information about 9.40uc5 release schedule? Unforunately bugs exists... Fortunately there are some people dedicated to correct them :) Regards.
Additional checkpoint will prevent the situation that was causing hang. Also it will reduce physical logging on secondary. Buffers on secondary will be dirty during index transfer and a frequent checkpoint during huge index transfer will avoid long checkpoint on secondary after the transfer. -Ajay Gupta Fernando Nunes <spam@domus.online.pt> wrote in message news:<2ojgrvFb3q3uU2@uni-berlin.de>... > Alexey Sonkin wrote: > > > Some good news on subj > > > > Informix support told me, that bug# 167294 is fixed in > > 9.40uc5 and patch release 9.40uc4w4 (Intermediate release, > > not fully tested) > > > > IBM opened 9.40uc4w4 for download for me, and I was able to > > re-run my index creation tests under 9.40uc4w4 ( in exactly > > the same database and server configuration) > > > > All indexes were successfully built!!! > > > > IBM definitely specifically addressed the 'checkpoint > > generated on secondary by 75% fullness of the physical log' > > issue: in the new version, few seconds after the index build > > is finished on primary and index transfer to secondary is started, > > IDS is starting some 'special' checkpoint on primary (this checkpoint > > happenned for all 15 indexes I've built) > > > > Is there any information about 9.40uc5 release schedule? > > Unforunately bugs exists... > Fortunately there are some people dedicated to correct them :) > > Regards.