Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Automatic Log backup

 
   Database Forums (Home) -> Informix RSS
Next:  ERP Expert - What is your New Year Resolution?  
Author Message
Jeremiah

External


Since: Jan 11, 2011
Posts: 3



(Msg. 1) Posted: Tue Jan 11, 2011 2:29 pm
Post subject: Automatic Log backup
Archived from groups: comp>databases>informix (more info?)

I read that altering the ALARMPROGRAM parameter allows for automatic
log backup. I did so but it doesn't look like my logs are being backed
up automatically.

I modified the alarmprogram.sh and used that in my parameter.

Am I missing something?

 >> Stay informed about: Automatic Log backup 
Back to top
Login to vote
Jeremiah

External


Since: Jan 11, 2011
Posts: 3



(Msg. 2) Posted: Wed Jan 12, 2011 7:15 am
Post subject: Re: Automatic Log backup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This is what's in section 23:

# LOGICAL LOG FILE COMPLETED

# onbar assumes no operator is present, so all messages are
written to the
# activity log and there shouldn't be any output, but send
everything to
# /dev/null just in case
printf "Subject: $INFORMIXSERVER : $EVENT_SEVERITY_NAME :
$EVENT_MSG\n" >> $MAILHEAD
printf "$EVENT_ADD_TEXT\n" >> $MAILBODY

# TO IMPLEMENT LATER
# If there is already a logical log backup don't launch onbar again.
if ( `test x${BACKUPLOGS} = xY` ) then
$BACKUP_CMD 2>&1 >> /dev/null
EXIT_STATUS=$?
printf " '$BACKUP_CMD' has been executed and returned CODE=
%s\n\n" $EXIT_STATUS >> $MAILBODY
else
echo "Script will not backup the logical logs."
fi

# Now check if the logs are near to fill up
NUMLOGUB=`$ONSTATCMD -l | grep U-B | wc -l`
NUMLOGF=`$ONSTATCMD -l | grep F- | wc -l`
NUMLOGA=`$ONSTATCMD -l | grep A- | wc -l`
NUMLOGU=`$ONSTATCMD -l | grep U- | wc -l`
NUMLOG=`expr $NUMLOGU + $NUMLOGA + $NUMLOGF`
PERC=`expr \( 100 \* \( $NUMLOGUB + $NUMLOGF + $NUMLOGA \)
\) / $NUMLOG `

if ( `test $PERC -le 10` ) then
PERC=`expr 100 - $PERC`
printf "\n-------------------------------------\n\n" >>
$MAILBODY
printf "WARNING : MORE THAN 90 PERCENT (%s percent) OF THE
LOGICAL LOGS ARE FULL\n" $PERC >> $MAILBODY
printf " A LOGICAL LOG BACKUP IS NEEDED. SEE INFO
BELOW\n" >> $MAILBODY
$ONSTATCMD -l | grep -v Blocked: | grep -v Block: | tail +4
>> $MAILBODY
fi
;;


On Jan 11, 4:52 pm, Art Kagel wrote:
> Depends on what you put into alarmprogram.sh!  Can you post the section for
> trapping event code 23 (log complete)?
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (a...@iiug.org)
> Blog:http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference.  Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Tue, Jan 11, 2011 at 5:29 PM, Jeremiah wrote:
> > I read that altering the ALARMPROGRAM parameter allows for automatic
> > log backup. I did so but it doesn't look like my logs are being backed
> > up automatically.
>
> > I modified the alarmprogram.sh and used that in my parameter.
>
> > Am I missing something?
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l....DeleteThis@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list

 >> Stay informed about: Automatic Log backup 
Back to top
Login to vote
Jeremiah

External


Since: Jan 11, 2011
Posts: 3



(Msg. 3) Posted: Wed Jan 12, 2011 7:19 am
Post subject: Re: Automatic Log backup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I think I found my problem. ALARMPROGRAM parameter was pointing to the
wrong path.
 >> Stay informed about: Automatic Log backup 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Backup time - Hello All, We are using IDS 9.40 on top of Sparc Solaris 9. There is level 0 backup run every night. I'm just wondering why sometimes the backup takes couple hours and sometimes it is up to fifteen hours long. Database is not large (packed level 0..

Need to restore Level 0 backup - Hi I"ve not worked with Informix IDS for a while now so a little rusty. We have an Informix database which isnt' in use anymore other than archival purposes. The server died, and it's going to take a lot of time and money to get the server back. ...

Backup using two different tools run together - Hi All, I have a simple question. Can backup using two different tools run together. It can run for sure, I know. However question is will there be any conflict if we have to restore? Are they independent of each? Example: onarchive and ontape. ..

Backup/restore compatibility - Hello, In the DB2 World, there is a (very annoying) constraint concerning backup/ restore: Data backed up on a big-endian host cannot be restored on a little-endian host, and vice versa. The constraint is very illogical considering that one of DB2's..

onbar backup error on informix - Hi. i have an hpux system running informix 7.31 which includes onbar and informix storage manager ISM. I've configured (i think) ism to backup to hard disk by adding an informix user administrator an adding a device type=file pointing at some directory i...
   Database Forums (Home) -> Informix All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]