Oninit cdi / Archive
Talk to an expert →

ON-Bar / Last logical log saved number

Posted in 2017

Summary

Henri Moukouri asked how to get the number of the last logical log saved by ON-Bar into a shell variable. Benjamin Thompson said to look for the last row of type L in the ixbar file and gave a script using onstat -c for SERVERNUM, then tail -50000 of the ixbar file, grep ' L', tail -1 and awk. Henri planned to implement it.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Logging & Checkpoints

h.moukouri — — source: IIUG Forums & Mailing Lists

Hi, After a backup with ON-Bar, I would like to get the number of the last logical log saved using a shell script.Please, can any one help me for that ? Thanks.Henri M. Envoyé depuis mon smartphone Samsung Galaxy.

↪ replying to h.moukouri
BENJAMIN THOMPSON — — source: IIUG Forums & Mailing Lists

Look for the last row in your ixbar file of type 'L'. Ben.

↪ replying to BENJAMIN THOMPSON
Henri Moukouri — — source: IIUG Forums & Mailing Lists

Hi Ben, Thank you, for your answer.But, could you please tell me how I can get it in an environment variable through a shell script reading ixbar file ? Best Regards,Henri M. Sent from Samsung tablet -------- Message d'origine --------De : BENJAMIN THOMPSON <benjamin.thompson@skybettingandgaming.com> Date : 21/06/2017 10:32 (GMT+01:00) À : ids@iiug.org Objet : Re: ON-Bar / Last logical log saved number [39417] Look for the last row in your ixbar file of type 'L'. Ben. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Henri Moukouri
BENJAMIN THOMPSON — — source: IIUG Forums & Mailing Lists

Hi, Something like this. I am using "tail -50000" because ixbar files can get very large. SERVERNUM=`onstat -c | grep ^SERVERNUM | awk '{print $2}'` LASTLOGBACKEDUP=`tail -50000 $INFORMIXDIR/etc/ixbar.$SERVERNUM | grep ' L' | tail -1 | awk '{print $2}'` Ben.

↪ replying to BENJAMIN THOMPSON
Henri Moukouri — — source: IIUG Forums & Mailing Lists

Hi Ben, Thank you very much !I'm going to try it for implementation. Best Regards,Henri M. Sent from Samsung tablet -------- Message d'origine --------De : BENJAMIN THOMPSON <benjamin.thompson@skybettingandgaming.com> Date : 21/06/2017 11:05 (GMT+01:00) À : ids@iiug.org Objet : Re: ON-Bar / Last logical log saved number [39419] Hi, Something like this. I am using "tail -50000" because ixbar files can get very large. SERVERNUM=`onstat -c | grep ^SERVERNUM | awk '{print $2}'` LASTLOGBACKEDUP=`tail -50000 $INFORMIXDIR/etc/ixbar.$SERVERNUM | grep ' L' | tail -1 | awk '{print $2}'` Ben. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary