Error when initializing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

juanc - 19 May 2007 13:26 GMT

On IDS 10.00 when I trying to startup it remains eternally. In
another screen (onstat -) appears IBM Informix Dynamic Server Version
10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576
Kbytes Blocked:CKPT.

That I must do?

Reply to this Message

TBP - 19 May 2007 17:12 GMT

> On IDS 10.00 when I trying to startup it remains eternally. In
> another screen (onstat -) appears IBM Informix Dynamic Server Version
> 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576
> Kbytes Blocked:CKPT.
>
> That I must do?

Post the output from onstat -m and onstat -l.

Reply to this Message

Jonathan Leffler - 19 May 2007 19:43 GMT

I suspect that you have your logical logs full and needing backup, or
something along those lines. Either add some more logs or do the
archive. If that isn't the problem, send the onstat outputs suggested
by The Spud (aka The Big Potato).

Signature

Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/

Reply to this Message

juanc - 20 May 2007 02:02 GMT

> > On IDS 10.00 when I trying to startup it remains eternally. In
> > another screen (onstat -) appears IBM Informix Dynamic Server Version
[quoted text clipped - 12 lines]
> Email: jleff...@earthlink.net, jleff...@us.ibm.com
> Guardian of DBD::Informix v2007.0226 --http://dbi.perl.org/

Yor are righ, onstat -m show:

but, in this moment i don't have tape backup.

06:36:20 Warning: shared-memory connection file '/
INFORMIXTMP/.inf.omega' is overwritten. This file might
belong to another instance of IDS server. If the service name of the
IDS
database server is not unique in the environment of the host computer
where
the database server resides, rename the service.
06:36:20 IBM Informix Dynamic Server Version 10.00.UC6TL Software
Serial Number AAA#B000000
06:36:20 Your evaluation license will expire on 2007-08-04 00:00:00

06:36:21 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.

06:36:21 Physical Recovery Started at Page (1:587).
06:36:21 Physical Recovery Complete: 428 Pages Examined, 428 Pages
Restored.
06:36:21 Logical Recovery Started.
06:36:21 10 recovery worker threads will be started.
06:36:22 Fast Recovery Switching to Log 5
06:36:23 Fast Recovery Switching to Log 6
06:36:26 Logical Recovery has reached the transaction cleanup phase.
06:36:26 Logical Log Files are Full -- Backup is Needed

06:36:26 Process exited with return code 126: /bin/sh /bin/sh -c /
informix/ids10/etc/alarmprogram.sh 3 20 "Logical Logs are Full --
Backup is Needed." "Logical Log Fil

Reply to this Message

TBP - 20 May 2007 13:27 GMT

>>> On IDS 10.00 when I trying to startup it remains eternally. In
>>> another screen (onstat -) appears IBM Informix Dynamic Server Version
[quoted text clipped - 42 lines]
> informix/ids10/etc/alarmprogram.sh 3 20 "Logical Logs are Full --
> Backup is Needed." "Logical Log Fil

Well, you could try setting LTAPEDEV to /dev/null, as you do not have a
backup you will be in no worse position throwing your log backups down
/dev/null.

And this is a fairly new instance (switching to Log 5 then log 6).

Run onmode -ky and then set LTAPEDEV to /dev/null and then try starting up.

Where did this instance come from (i.e. is this a fairly recent new
instance? or a "copy" from another machine?)

Reply to this Message

scottishpoet - 21 May 2007 10:35 GMT

06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\b]

I believe this is likelt ot be a new ish instance to a newish user of
the software

Reply to this Message

Art S. Kagel - 21 May 2007 20:54 GMT

Post the output from onstat -l, I suspect that your logical logs are full
and need to be archived.

Art S. Kagel

Reply to this Message