Re: checkpoint problem
Posted in 2006
scottishpoet — — source: Usenet: comp.databases.informix
is this a new problem or has it always occurred? have you changed anything in terms of your workload that has caused this problem to occur? the checkpoint is the time taken to flush data from memory to disk, is there some ocntention on some devices that is causing this to take a long time, too many dbspaces table son one device, what does sar report as the disk activity across your devices during the checkpoint? do you possibly have a problem with one of your disks running slow? try if possible dding to each of the devices and see what the performance is like