Re: Alter fragment stalled with CKPT REQ
On Feb 18, 1:16 pm, "Doug Lawry" <la...@nildram.co.uk> wrote:
> The following describes a problem I had this morning. I know there are other
> ways of doing reorgs (such as using Server Studio), but I need to understand
> today's problem first in case it has wider ramifications.
>
> Regards,
> Doug Lawry
>
> -----------------------------------------------------
>
> IDS 10.00.FC5 / Red Hat Linux (no HDR)
>
> Intended procedure:
>
> ontape -s -L 0 -N dbsname
> dbaccess -e dbsname table_reorg
> ontape -s -L 0 -U dbsname>
> SQL script "table_reorg.sql" contained:
>
> ALTER FRAGMENT ON TABLE tabname INIT IN dbspace;> [repeated for 9 tables]
>
> Result was that tables 3 and 5 (after restarting) stalled with "On-Line
> (CKPT REQ) ... Blocked:CKPT". Informix returned to normal after killing the
> process on both occasions. The exercise was then discontinued.
>
> No long transaction message (or any other error) was received.
>
> Only one entry was returned by "onstat -l | fgrep -v B", i.e. the logs
> weren't full, but logging was off anyway.
>
> There was no activity according to "onstat -u" or "top" for at least 5
> minutes while in this state.
>
> A very similar recent exercise with the same application on IDS 10.00.FC8 /
> Red Hat Linux ran fine.
Did you check the physical log usage?
Did you see some activitie in "onstat -g act" ?
If the next logical log contains the checkpoint record that is raising
your checkpoint.