If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Informix Not coming up ....

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-31-02, 18:36
pathapadu73 pathapadu73 is offline
Registered User
 
Join Date: Oct 2002
Posts: 3
Unhappy Informix Not coming up ....

Hi !!!

Today morning our SYSADMIN rebooted SUN box, it came up fine but Informix is down.
I am getting a message in Informix online.log as follows:
"mt_shm_remove: WARNING: may not have removed all/correct segments".

I checked /dev/rdsk/dbs* permissions, owner & group. Everything looks fine, it has 660 & Informix as owner & group. Checked the /etc/system parameters & that also looks fine. Checked SQLhosts & looks fine.

Checked for ipcs, nothing is running except for 2 root process.

I ran out of all my options, I am badly in need of some help, please folks help me out.

Thanks
Shashi
Reply With Quote
  #2 (permalink)  
Old 11-01-02, 03:14
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

run oninit -vy and capture output text for more information then post it again
Reply With Quote
  #3 (permalink)  
Old 11-07-02, 04:19
SkuRal SkuRal is offline
Registered User
 
Join Date: Oct 2002
Posts: 6
This problem comes from the shared memory part of informix server.
I'm not too good at shared memory management in the SUN-box, but your sysadm should be able to help you when you know it's a memory problem. There is some parameters in the onconfig file, setting shared memory system.

Look at buffers,shmbase, shmvirtsize, shmadd and shmtotal, to see if something changed. Changes in the onconfig-file is logged in your
%INFORMIXDIR%/%SERVERNAME%.log - file.

Hope this helps ( at least a bit )
/Ralph
Reply With Quote
  #4 (permalink)  
Old 11-15-02, 03:14
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

Informix goes down and can't start to online again in my experience
the share memory is still allocate or network port I/O is still allocate from informix
Reply With Quote
  #5 (permalink)  
Old 11-15-02, 04:20
SkuRal SkuRal is offline
Registered User
 
Join Date: Oct 2002
Posts: 6
Check with onstat -m to see if you've got any messages that states any errors in the shared memory base address.
/R
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On