Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Checkpoint Blocked problem

188 views

Skip to first unread message

Scott MacKenzie

unread,

Mar 3, 2002, 4:09:06 PM3/3/02

Safian,

onstat -l

will give the status of the logical logs. From another recent
post, I will posit that you have no free logical logs for the
checkpoint process to record it's business. I recommend you
backup your logical logs and then see if the error goes away.

> Safian wrote:
>
> Dear Informix support,
>
> I am having big problem with my Informix database system. I am not
> able to run the billing processing due to the database gets blocked.
>
> The following error is encountered: “Informix Dynamic Server ver 7.31
> UC3 – on-line (CKPT REQ) – up 01:36:5 Blocked: CKPT”.
>
> I don't really understand about the meaning of the above error
> message, it seems that the system wants to do checkpoint but at the
> same time it gets blocked because checkpoint? Is it deadlock
> situation?
>
> The manual says that the Checkpoint is initiated under the
> following situations:
> i) The checkpoint interval, specified by the configuration CKPTINTVL
> has elapsed and one or more nodifications have occured since the last
> checkpoint.
> ii) The physical log become 75% full
> iii) The database server detects that the next logical-log file to
> become current contains the most-recent checkpoint record.
> iv) Certain administrative tasks such as adding chunk take place.
> v) Checkpoint is initiated with onmode -c
> vi) Checkpoint is initiated from ON-monitor, Force-Ckpt menu.
>
> My CKPTINTVL=300, but I am not sure how to check the physical log.
>
> Looking forward for your assistance.
>
> ------------------------------------
> Md Safian Md Yassin
> CCBS System Manager
> Ghana Telecom Ltd.
> Tel: +233 21 200 365
> GSM: +233 20 200 0014

( ______
)) .-- Scott MacKenzie; Dine' College IS --. >===<--.
C|~~| (>--- Phone/Voice Mail: 928-724-6639 ---<) | = |-'
`--' `- Email: sco...@crystal.ncc.cc.nm.us -' `-----'

Murray Wood

unread,

Mar 3, 2002, 7:56:18 PM3/3/02

Dont post HTML

The question is why is the Checkpoint Blocked? Informix messages log?
Could be used up all logs, problem with your disks, or doing a recovery ...
Resolve that and you will be fine.

BTW we are not informix support.

0 new messages