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 > Online.log

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-05-03, 02:30
sengchoon sengchoon is offline
Registered User
 
Join Date: Aug 2002
Posts: 21
Online.log

Can anyone explain to me what this mean in online.log?

02:31:14 Process exited with return code 139: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 2333 Complete." "Logical Log 2333 Complete."


And also will the fiel size of online.log affect performance?
Reply With Quote
  #2 (permalink)  
Old 04-05-03, 06:09
eherber eherber is offline
Registered User
 
Join Date: Aug 2002
Location: Bonn/Germany
Posts: 152
This indicates that the ALARMPROGRAM failed or more
specifically did not return with exit code 0.
Your log backup did not finish successfully.

If you are using 'onbar', take a look at the onbar activity
log (BAR_ACT_LOG parameter in $ONCONFIG) to get
more information.
You might also trying to backup your logs manually
with (onbar -b -l) and see what is happening.
139 seems to be the returncode from the 'onbar' process
and means BAD_VERSION. So I guess that the entries in sysutils:bar_version (or $INFORMIXDIR/etc/sm_versions for newer releases of the Informix databaseserver) ) are not correctly.
.
__________________

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Reply With Quote
  #3 (permalink)  
Old 04-05-03, 20:56
sengchoon sengchoon is offline
Registered User
 
Join Date: Aug 2002
Posts: 21
Online.log

I'm actually using ontape to do daily backup (ontape -s -L 0) and also logical log backup (ontape -c). How to I configure ? Is it onbar better than ontape?

Quote:
Originally posted by eherber
This indicates that the ALARMPROGRAM failed or more
specifically did not return with exit code 0.
Your log backup did not finish successfully.

If you are using 'onbar', take a look at the onbar activity
log (BAR_ACT_LOG parameter in $ONCONFIG) to get
more information.
You might also trying to backup your logs manually
with (onbar -b -l) and see what is happening.
139 seems to be the returncode from the 'onbar' process
and means BAD_VERSION. So I guess that the entries in sysutils:bar_version (or $INFORMIXDIR/etc/sm_versions for newer releases of the Informix databaseserver) ) are not correctly.
.
Reply With Quote
  #4 (permalink)  
Old 04-06-03, 03:09
eherber eherber is offline
Registered User
 
Join Date: Aug 2002
Location: Bonn/Germany
Posts: 152
If you use the continuous backup mechanism of
ontape, then you should set your ALARMPROGRAM
to:

$INFORMIXDIR/etc/no_log.sh

This will prevent the errors reported in the 'online.log'.

onbar is more complicated than ontape. It has advanced
features such as parallel backup to more than one
device, point-in-time restore, backup-history-database
etc.

However if you don't have a database of several
hundred gigabytes, I would recommend that you
stay with ontape. This solution is simple and easy
to use.

You will find more information in the 'Backup & Restore Guide'.
__________________

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Reply With Quote
  #5 (permalink)  
Old 04-06-03, 04:08
sengchoon sengchoon is offline
Registered User
 
Join Date: Aug 2002
Posts: 21
Online.log

Is this mean that the logical log will be automatically backup when it's full? And is it mean that if I want to test Data Replication, I have to use onbar concept?


Quote:
Originally posted by eherber
If you use the continuous backup mechanism of
ontape, then you should set your ALARMPROGRAM
to:

$INFORMIXDIR/etc/no_log.sh

This will prevent the errors reported in the 'online.log'.

onbar is more complicated than ontape. It has advanced
features such as parallel backup to more than one
device, point-in-time restore, backup-history-database
etc.

However if you don't have a database of several
hundred gigabytes, I would recommend that you
stay with ontape. This solution is simple and easy
to use.

You will find more information in the 'Backup & Restore Guide'.
Reply With Quote
  #6 (permalink)  
Old 04-06-03, 04:45
eherber eherber is offline
Registered User
 
Join Date: Aug 2002
Location: Bonn/Germany
Posts: 152
When you start 'ontape -c' the logical log will be
automatically backed up as soon as it is full.

You can setup HDR with onbar and ontape.
__________________

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
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