Re: Long checkpoint duration

Keith wrote: > During the checkpoint, do you see activity from the flushers? Does No activity at all! > onstat -F show them active. Do you see write activity for those guys> with onstat -u? Do you see chunk writes with onstat -D? No nothing, it really seems to "hang". But there is no user active doing anything. > What's your checkpoint interval? lru max dirty? lru min dirty? How > big is your phsical log? 300, 60, 50, 2048 > > Up to 8 hours for a checkpoint sounds like a performance problem to me. The whole system is frozen during that time, and yes, the users are not really amused. The application uses Apache, Perl and ODBC to access the Informix database. May be any problems with that combination. Thanks for your input, R'diger