Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Informix going Off-line by it's self!

Informix going Off-line by it's self!

Informix going Off-line by it's self!

This sounds nuts, but our Informix Box is goig Off-Line at least 5 time a day. To me it seems, it's because of parameters. The Digital Tru64 Unix 4.0d Alpha is up and running, but Informix goes Off-Line. Sometimes we even get a corrupt file system when Informix trips and falls down...

Has anyone been using a monitor utility of some sort, to determine which parameter is beeing depleted, or do you think I have another problem?

Thanks in advance folks!


RE: Informix going Off-line by it's self!

What does the message in your online log say?   If you've reached a maximum of some parameter setting it will tell you in the log.

I can tell you something from experience:  if a user kills their Informix process using a kill -9 it can cause the database to crash.   They MUST use the onmode -z sessionid command.  


RE: Informix going Off-line by it's self!

Yes!,  here is what I get in the online.log

10:52:54  shmat: [EMFILE][24]: out of shared memory segments, check system

This eventually causes:

10:52:04  Assert Failed: Internal Error - Segmentation Violation
10:52:04   Who: Session(9814, cecy@youarte.com, 31596, 238)
        Thread(1163117, sqlexec, 8089678, 3)
10:52:04   Results: OnLine must abort
10:52:04   Action: Reinitialize shared memory
10:52:04   See Also: /tmp/af.678ec86b, shmem.678ec86b.0
10:52:12  shmat: [EMFILE][24]: out of shared memory segments, check system

Any ideas??  I guess it has something to do with the configuration of Informix.. Our Top Informix guy is GONE!!

Thank you,


RE: Informix going Off-line by it's self!

Actually this is an issue for your Unix System Admin.  SHMSEG is a Unix kernel parameter that will need to be changed.  Somewhere in the installation notes for your operating system it should tell you what it should be set to.

On our system it's in $INFORMIX/release/en_us/0333/ONLINE.7.2

I'd say to try looking in $INFORMIX for a similarly named directory and then 'grep' for SHMSEG in any files beginning with ONLINE.

If you can't find it you should call Informix Tech Support.  If you have current support you probably should do this anyway.

Again - unless you are the Unix System Admin you should not be doing this yourself.  


RE: Informix going Off-line by it's self!


I will try to find the release notes on the server.

That you know of.. Is there a magic table with sugestions for these parameters?  I searched on the IBM site and found nothing....

I am supposed to do the Admin part of the server as well as finding the issues with Informix.



RE: Informix going Off-line by it's self!

You have my sympathies.  There is usually a file somewhere on your systems that shows you the default settings for the Unix kernel parameters.  However these always need to be tuned to fit your system's usage.

For now I think your best bet is trying to find the Informix file that tells you the best settings for your platform.

At the risk of getting in troubel with Tek-tips - you might consider posting a message on the Google Usenet forum for Informix.  It gets a lot of action and you may find someone there who uses your hardware.  It's:


Good luck.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close