Re: Log Message - Retun code 142

Hi Guys Thanks very much for your valuable suggestions. As i am working on Informix for the first time more clarifications. At present i am loading some data , here is sample output for onstat -l and onstat -m Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 12 16 26659 1924 13.86 phybegin physize phypos phyused %used 200035 10000 5895 316 3.16 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 16 2484637 262271 213985 9.5 1.2 Subsystem numrecs Log Space used OLDRSAM 2484637 164814592 Buffer Waiting Buffer ioproc flags L-2 25128948 0x1 0 address number flags uniqid begin size used %used a703040 1 U-B---- 1153 102817 500 500 100.00 a70305c 2 U-B---- 1154 102a0b 500 500 100.00 a703078 3 U-B---- 1155 102bff 500 500 100.00 ..... ...... ...... a703ac0 97 U-B---- 1249 10e397 500 500 100.00 a703adc 98 U-B---L 1250 10e58b 500 500 100.00 a703af8 99 U-B---- 1251 10e77f 500 500 100.00 a703b14 100 U-B---- 1252 10e973 500 500 100.00 a703b30 101 U-B---- 1253 10eb67 500 500 100.00 a703b4c 102 U-B---- 1254 10ed5b 500 500 100.00 a703b68 103 U-B---- 1255 10ef4f 500 500 100.00 a703b84 104 U-B---- 1256 10f143 500 500 100.00 a703ba0 105 U-B---- 1257 10f337 500 500 100.00 a703bbc 106 U-B---- 1258 10f52b 500 500 100.00 a703bd8 107 U-B---- 1259 10f71f 500 500 100.00 a703bf4 108 U---C-- 1260 10f913 500 45 9.00 a703c10 109 U-B---- 1133 10fb07 500 500 100.00 .... ..... ...... ...... upto number 128 and Message Log File: /usr/informix/online.log 11:52:03 Logical Log 1278 Complete. 11:52:04 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1278 Complete.""Logical Log 1278 Complete." 11:52:06 Logical Log 1279 Complete. 11:52:07 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1279 Complete.""Logical Log 1279 Complete." 11:52:09 Logical Log 1280 Complete. 11:52:10 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1280 Complete.""Logical Log 1280 Complete." 11:52:12 Logical Log 1281 Complete. 11:52:13 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1281 Complete.""Logical Log 1281 Complete." 11:52:15 Logical Log 1282 Complete. 11:52:16 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1282 Complete.""Logical Log 1282 Complete." 11:52:18 Logical Log 1283 Complete. 11:52:19 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1283 Complete.""Logical Log 1283 Complete." 11:52:22 Logical Log 1284 Complete. 11:52:23 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1284 Complete.""Logical Log 1284 Complete." 11:52:25 Logical Log 1285 Complete. 11:52:26 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1285 Complete.""Logical Log 1285 Complete." 11:52:28 Logical Log 1286 Complete. 11:52:29 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1286 Complete.""Logical Log 1286 Complete." 11:52:31 Logical Log 1287 Complete. 11:52:32 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1287 Complete.""Logical Log 1287 Complete." Can you please advise me which parameter i need to tune, as our database is very small , we are not performing any backups, every day midnight we have dbexport . Your help much appreciated Thanks Kalpana Pai "malcolm.iiug" <malcolm.iiug@btopenworld.com> wrote in message news:<bk9to1$73h$1@terabinaries.xmission.com>... > Kalpana, > you should understand that logs will still fill up. You have chosen not to > save the logs but they are still recorded so that they can be used by > ROLLBACK statements. Also be aware that any changes to the database schema, > including creation of temp tables other than in a temp dbspace, are recorded > to the log regardless of database logging. So, whatever you do logs will > still fill up occasionally. It looks to me as though you have logging > turned on for the database as to fill a 1 Mbyte logs (1000 pages) would take > a little time. In your case the log filled in 17 seconds. Were you doing > some form of batch update, alter table, batch delete, etc? > > regards > > Malcolm > ----- Original Message ----- > From: "KalpanaPai" <kalpanapai@hotmail.com> > To: <informix-list@iiug.org> > Sent: Wednesday, September 17, 2003 1:04 AM > Subject: Log Message - Retun code 142 > > > > Hi All > > > > As we are not using onbar or ontape, and LTAPEDEV is set to > > /dev/null, > > but i find the following msg in the log sometimes . > > May i know what needs to be set in onconfig, i have 128 logs and > > chkpoint is 60 sec > > logsize is 1000, BUFFERS 200000, PHYBUFF 32 , LOGBUFF 32 and LOGSMAX > > 256. > > > > > > Logical Log 785 Complete. > > 11:39:53 Process exited with return code 142: /bin/sh /bin/sh -c > > /usr/informix/etc/log_full.sh 2 23 "Logical Log 785 Complete."> > "Logical Log 785 Complete." > > 11:40:09 Logical Log 786 Complete. > > 11:40:10 Process exited with return code 142: /bin/sh /bin/sh -c > > /usr/informix/etc/log_full.sh 2 23 "Logical Log 786 Complete."> > "Logical Log 786 Complete." > > 11:40:42 Fuzzy Checkpoint Completed: duration was 0 seconds, 29> > buffers not flushed. > > 11:40:42 Checkpoint loguniq 787, logpos 0x12f124 > > > > 11:41:42 Fuzzy Checkpoint Completed: duration was 0 seconds, 9> > buffers not flushed. > > 11:41:42 Checkpoint loguniq 787, logpos 0x136084 > > > > 11:42:42 Fuzzy Checkpoint Completed: duration was 0 seconds, 10> > buffers not flushed. > > 11:42:42 Checkpoint loguniq 787, logpos 0x14008c> > > > Thanks Heaps!!!!! > > kalpana > > sending to informix-list