log_full.sh exit with code 163

Hi, I saw online.log some errors like this: Process exited with return code 163: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 Now my database is slow to response, I/O seems very high. Any suggestion to diagnose ? Best Regards. Chen Ming

Backup your log files: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ba r.doc/barmst286.htm Lennie On Wed, Jan 14, 2009 at 12:39 AM, Mockey Chen <mockey.chen@nsn.com> wrote: > Hi, > > I saw online.log some errors like this: > Process exited with return code 163: /bin/sh /bin/sh -c > /usr/informix/etc/log_full.sh 2 23 > > Now my database is slow to response, I/O seems very high. > > Any suggestion to diagnose ? > > Best Regards. > > Chen Ming > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

ext Lennie Jarratt wrote: Backup your log files: [1]http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ib m.bar.doc/barmst286.htm Thanks your comment. But the server use /dev/null as backup device, there is onconfig LTAPEDEV /dev/null BAR_ACT_LOG /dev/null Any opinions ? Lennie On Wed, Jan 14, 2009 at 12:39 AM, Mockey Chen [2]<mockey.chen@nsn.com> wrote: Hi, I saw online.log some errors like this: Process exited with return code 163: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 Now my database is slow to response, I/O seems very high. Any suggestion to diagnose ? Best Regards. Chen Ming ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. References 1. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ba r.doc/barmst286.htm 2. mailto:mockey.chen@nsn.com

what is the value of ALARMPROGRAM parameter? can you show that script. ________________________________ From: Mockey Chen <mockey.chen@nsn.com> To: ids@iiug.org Sent: Wednesday, January 14, 2009 1:39:45 PM Subject: log_full.sh exit with code 163 [14516] Hi, I saw online.log some errors like this: Process exited with return code 163: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 Now my database is slow to response, I/O seems very high. Any suggestion to diagnose ? Best Regards. Chen Ming ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

The return of 163 is just an error return from that script. It usually means that you installed the default log_full.sh which calls onbar to backup the logical logs but you don't actually use onbar and have no configured it to work. If this is correct, then change the ALARMPROGRAM to another script that either does nothing or one that uses ontape to backup the logs (like the eventalarm.c executable in my utils3_ak package). That likely has nothing to do with the high IO. Post the output from the following onstat commands and we'll see if we can help. If it's a simple configuration adjustment, we will, if the problem's more complex then you may have to hire a consultant. Oh, also post your IDS version and platform information, that helps a lot. onstat -p onstat -d onstat -m onstat -c onstat -C onstat -g glo onstat -g iov onstat -g iof onstat -P Art On Wed, Jan 14, 2009 at 1:39 AM, Mockey Chen <mockey.chen@nsn.com> wrote: > Hi, > > I saw online.log some errors like this: > Process exited with return code 163: /bin/sh /bin/sh -c > /usr/informix/etc/log_full.sh 2 23 > > Now my database is slow to response, I/O seems very high. > > Any suggestion to diagnose ? > > Best Regards. > > Chen Ming > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.