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

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

On Thu, 18 Sep 2003 19:55:22 -0400, KalpanaPai wrote:

<SNIP>
> 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
><SNIP>
> 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 .

Change LTAPEDEV in the ONCONFIG file to /dev/null and change ALARMPROGRAM from
usr/informix/etc/log_full.sh to usr/informix/etc/no_log.sh.

This will cause your logical logs to be discarded immediately upon completion.
Only the online copy of the logs not yet reused will still exist for fast
recovery after a crash and no restore to the latest moment is possible.

Art S. Kagel