URGENT :INFORMIX ERROR 123 CAN NOT ATTACH TO SHARED MEMORY

[s***@gmail.com]

Hi all , please it's extremly urgent , i don't have a back up for my DB , and can't access it , or access the program that comunicate with DB , Even DBACCESS or DBEXPORT so i can save my DB is not working . I'm Having this Errors :
Unable to attach shared memory
ISAM Error:Cannot attach shared memory

please it's EXTREMLY URGENT my job depends on this . i'm looking for a solution if not a way to save my DB and start all over on another Server to deblock the situation . thanks .

[s***@gmail.com]

I'm on SCO OPENSERVER by the way .

[s***@t-online.de]

Post by s***@gmail.com
I'm on SCO OPENSERVER by the way .

I hope you know what environment is used.
If so have a look at $INFORMIXDIR/etc/$ONCONFIG, gointhere and search for MSGPATH

this file contains a path/filename containing the log file of your db.

What does that say.

If you have no clue then locate the dir where informix installed on your system
gointo the etc subdir.

Do a ipcs -m
there should be a couple of shm segements where the key looks like
0x52??4801...

The for ?? you have to substract 0x56 to find the hex value for SERVERNUM.

ex:
0x52a34801--> 0xa3 - 0x56 = 77 decimal

means my SERVERNUM 77 so do a grep 77 onconfig*
this will give you the onconfig file. do the above eq find MSGPATH and look what the log file has to say.

In this file the communication is also configured. Look for DBSERVERNAME and DBSERVERALIAS.

Look in the file sqlhosts what these values represent,

If one is listed with ontlitcp (or onsoctcp not sure...) then set your INFORMIXSERVER to that value like export INFORMIXSERVER=<name found>

try again to connect...


It could also be a permission problem if for instance oninit is not owned by root and has it suid bits set then repair this.

What the permissions should be is listed in the etc subdir
in a file called onlinefiles or... IIFfiles dependant on what your version is.


Hope it helps a bit.

Superboer.