Problem(Abstract)
online.log shows sessions getting killed (MCMD_KILL)
Symptom
You see messages in online.log. something similar to these:
04:15:08 sid 2011976 username sanjju@linux12 pid 2566 terminated.
04:15:08 killed(MCMD_KILL)
Cause
You will see such messages in online.log when someone kills session(s) either manually, or through some maintenance script, by running onmode -z.
Other scenarios where we can see these messages in online.log is when informix server kills sessions internally. Situations where server could be killing sessions internally are like, when the server is switching to a single user mode, or when it is shutting down.
Also, with newer version of Informix server (11.50.xC9, or 11.70.xC4 and higher versions) that supports Low Memory Management feature and has the feature enabled with a defined threshold, you can see sessions getting killed internally after the instance enters the defined threshold for low memory.
You can run 'onstat -g lmm' and review the output. This should list the sessions, if any were killed due to enabling of low memory management feature. For more information on this command, please check the link given in the "Related Information' section of this document.
http://www-01.ibm.com/support/docview.wss?uid=swg21654719&myns=swgimgmt&mynp=OCSSGU8G&mync=E
'Informix > informix reference' 카테고리의 다른 글
| Determining the number of free table pages without locking (0) | 2013.12.23 |
|---|---|
| Why some tables in systables have a partnum of zero? (0) | 2013.12.22 |
| Monitor Resource Contention (0) | 2013.11.16 |
| Why there is a difference in amount of memory usage between 'onstat -g seg' and 'onstat -g mem' outputs? (0) | 2013.11.16 |
| How to rename chunks of current instance using external restore (0) | 2013.11.16 |