Blocked Check point

I am running informix 11.70.FC5 on AIX 6.1 and am experiencing a blocked checkpoint There are plenty of logs available and the current log file is not full. We do not have transaction loggin switched on for the database and so there is no long transactions Nothing out of the ordinary in the message log. I restarted the database which cleared the issue for a short while. I would appreciate any pointers as to where I need to start looking for issues. The blocked checkpoint is one probably raised by a standard interval based check point (every 5 minutes)

You need to collect some data and open a PMR with IBM. onstat -a should allow some investigation...Most probably there is some deadlock between threads. onstat -g conwill show the conditions (and waiters) and there should be some relevant info there. onstat -umay show a thread in a critical section (can hold a checkpoint). Flag "X" onstat -g stk allwill show the stack traces of all tr threads. a dump of the shared memory would allow these commands to be run later. In principle this should be a bug... Regards On Thu, Sep 19, 2013 at 9:41 PM, Mark Tyrer <m_tyrer@hotmail.com> wrote: > I am running informix 11.70.FC5 on AIX 6.1 and am experiencing a blocked > checkpoint > > There are plenty of logs available and the current log file is not full. > > We do not have transaction loggin switched on for the database and so > there is > no long transactions > > Nothing out of the ordinary in the message log. > > I restarted the database which cleared the issue for a short while. I would > appreciate any pointers as to where I need to start looking for issues. > > The blocked checkpoint is one probably raised by a standard interval based > check point (every 5 minutes) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b6dc224e797db04e6c3771e

Thanks Fernando=2C I will give that a try Regards Mark --- Original Message --- From: "Fernando Nunes" <domusonline@gmail.com> Sent: September 19=2C 2013 11:45 PM To: ids@iiug.org Subject: Re: Blocked Check point [31466] You need to collect some data and open a PMR with IBM. onstat -a should allow some investigation...Most probably there is some deadlock between threads. onstat -g conwill show the conditions (and waiters) and there should be some relevant info there. onstat -umay show a thread in a critical section (can hold a checkpoint). Flag "X" onstat -g stk allwill show the stack traces of all tr threads. a dump of the shared memory would allow these commands to be run later. In principle this should be a bug... Regards On Thu=2C Sep 19=2C 2013 at 9:41 PM=2C Mark Tyrer <m_tyrer@hotmail.com> wro= te: > I am running informix 11.70.FC5 on AIX 6.1 and am experiencing a blocked > checkpoint > > There are plenty of logs available and the current log file is not full. > > We do not have transaction loggin switched on for the database and so > there is > no long transactions > > Nothing out of the ordinary in the message log. > > I restarted the database which cleared the issue for a short while. I wou= ld > appreciate any pointers as to where I need to start looking for issues. > > The blocked checkpoint is one probably raised by a standard interval base= d > check point (every 5 minutes) > > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b6dc224e797db04e6c3771e ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.