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

Unable to open input file 'c'

167 views
Skip to first unread message

David Reed

unread,
Oct 23, 2007, 2:44:23 PM10/23/07
to inform...@iiug.org
Informix 7.x
SCO Unix

When I do oninit, I get the following messages:
Unable to open input file 'c'
Unable to open input file 's'


Informix go into fast recovery and then crash. Any advice?

Regards
David Reed

Jonathan Leffler

unread,
Oct 24, 2007, 12:17:07 AM10/24/07
to


I assume there is some long term plan to upgrade to more recent hardware
and software, and there is an immediate crisis that must be resolved.

What is the x in 7.x?

What has changed in your configuration files recently?

What does the online log say?

Does 'oninit -v' give any help?

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

publictimestamp.org/ptb/PTB-1613 whirlpool 2007-10-24 03:00:05
AAC9108F434B737C3716B27E18E8339D0AAAC353561F377574BF4B1E82FD48FD2BA17E
E66F6457ADB50079A30AF546A23E9AB38B48A8A33BFDAAB96D37753AB

TBP (The Big Potato)

unread,
Oct 25, 2007, 5:49:01 AM10/25/07
to
jpie...@chubb.com wrote:
> By the way, I found the following old case on my case log
>
> *Case #:284938*
> *Date Opened:* 11/15/2001
> *Date Closed:12/10/01*
> *Engineer:Ronald Peacock/ Kurt Becker*
> *E-mail:rpea...@informix.com, kbe...@informix.com*
> *Brief Description: Instance would not come back online. Oninit -v
> failed with the following while checking for temporary tables to drop :*
> * “unable to open input file ‘s’*
> *“unable to open input file ‘c’*
> *Detail Description:*
> *Resolution: Upgrade to 7.31.UD3 resolves the issue*
> _ _
> _The previous info was from another issue, please disregard_
> I mixed the above with the below
> *Brief Description:* After UPGRADE from UC6 to UD3, issuing the cdr list
> repl command returns the following error message : cdr: can’t fetch
> participant . SQL code –1829 : Cannot open file ‘csqli.iem’
> *Detail Description:*
> *Resolution:* copy itoxmsg.pam to citoxmsg.pam in $INFORMIXDIR/msg
> resolve the issue
>
> What is your current version and release of informix 7.xx.xxx? Fill in
> the x'es.
>
> jp
> Inactive hide details for Jonathan Leffler
> <jlef...@earthlink.net>Jonathan Leffler <jlef...@earthlink.net>
>
>
> *Jonathan Leffler <jlef...@earthlink.net>*
> Sent by: informix-l...@iiug.org
>
> 10/24/2007 12:17 AM
>
>
>
> To
>
> inform...@iiug.org
>
> cc
>
>
> Subject
>
> Re: Unable to open input file 'c'
> _______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

What does oninit -v show?

If it is related to dropping temp tables, try oninit -p - short term solution

Art S. Kagel

unread,
Oct 25, 2007, 9:29:57 AM10/25/07
to


I've seen this one long ago. Vague memory, but IB it's related to the
ownership or privs of /dev/console especially if you have the CONSOLE
parameter in the ONCONFIG file pointing there. It's a particularly
useless message, but I remember something like this.

Art S. Kagel

tilleul17

unread,
Oct 25, 2007, 11:52:21 AM10/25/07
to inform...@iiug.org

In the file evidence.sh there are two lines :

ev_pretty $ONSTAT -g smb s
ev_pretty $ONSTAT -g smb c

These onstats are used to print out sbspace information.
They make sense in 9.x but not in 7.x IDS version . When you call

%onstat -g smb s
or
%onstat -g smb c

in a 7.x environment onstat will report these messages about input files
that can't be opened.

Unfortunately the updated version of evidence.sh (that one that included
these onstat commands) made it into all IDS build environments (not only
>=9.x)

So what it means when you see these messages on the terminal after you
typed

%oninit

simply is that IDS crashed upon the attempt to start it.
You may ignore the message about not being able to open input fil 'c' or
's'
but you probably want to investigate the reason for the crash. (look
online.log, af.xxxxx file)

I think they fixed evidence.sh in saome later IDS 7.31.xD but not sure.

Rgds
Tilman

0 new messages