ON-Bar database server is dismissing the logical
ON-Bar log backups failed with errors -43336/-43338 ("database server is dismissing the logical logs") on IDS 11.70.FC8W1 under Linux. The poster had followed the IBM technote and changed LTAPEDEV from /dev/null to a real device, but the error persisted. Martin Fürderer and Art Kagel pointed out that editing LTAPEDEV directly in the ONCONFIG file only takes effect after restarting the engine (alternatively use onmode -wf). After bouncing the server, the backup worked, confirming the fix.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, I am trying to post below question on old site (iiug.org) under IDS section, but facing incomplete submission. My post is as below.. can you please assist on same. Thank you. Hello, Based on below bar_act.log, I followed the technote: http://www-01.ibm.com/support/docview.wss?uid=swg21641498 As per technote, changed the value for LTAPEDEV to non /dev/null. But its not worked for me.. may be missing something. Can anyone suggest on same.. IDS and OS details: IDS: 11.70.FC8W1 OS: RedHat GNU/Linux x86_64 Please refer below bar_act.log as follow: $more bar_act.log.061016 2016-06-09 20:00:01 28624 28620 /opt/informix/informix1170FC8W1/bin/onbar_d -b -L 0 2016-06-09 20:00:01 28624 28620 (-43336) Logical Logs cannot be backed-up because the database server is dismissing the logical logs. 2016-06-09 20:00:01 28624 28620 (-43338) Non whole-system backups are not allowed if the database server is dismissing logical logs. 2016-06-09 20:00:01 28624 28620 /opt/informix/informix1170FC8W1/bin/onbar_d complete, returning 156 (0x9c) ------------------------------ Thanks & Regards, Pravin Bankar HP Please consider the environment before printing this e-mail. --001a113d15d81dd1080534e95a3a
Hi, are you sure that you restarted the server after changing the parameter LTAPEDEV in the configuration file ? This will make the change effective ... Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Read about the Informix Warehouse Accelerator: http://tinyurl.com/the-iwa-blog IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martina Koederitz Board of Management: Dirk Wittkopp Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 From: "Pravin Bankar" <pravinebankar@gmail.com> To: ids@iiug.org Date: 06/10/2016 11:43 Subject: ON-Bar database server is dismissing the logical [37239] Sent by: ids-bounces@iiug.org Hello,=20 I am trying to post below question on old site (iiug.org) under IDS=20 section, but facing incomplete submission.=20 My post is as below.. can you please assist on same. Thank you.=20 Hello,=20 Based on below bar=5Fact.log, I followed the technote:=20 http://www-01.ibm.com/support/docview.wss?uid=3Dswg21641498=20 As per technote, changed the value for LTAPEDEV to non /dev/null.=20 But its not worked for me.. may be missing something. Can anyone suggest=20 on=20 same..=20 IDS and OS details:=20 IDS: 11.70.FC8W1=20 OS: RedHat GNU/Linux x86=5F64=20 Please refer below bar=5Fact.log as follow:=20 $more bar=5Fact.log.061016=20 2016-06-09 20:00:01 28624 28620=20 /opt/informix/informix1170FC8W1/bin/onbar=5Fd -b -L 0=20 2016-06-09 20:00:01 28624 28620 (-43336) Logical Logs cannot be backed-up=20 because the database server is=20 dismissing the logical logs.=20 2016-06-09 20:00:01 28624 28620 (-43338) Non whole-system backups are not=20 allowed if the database server is=20 dismissing logical logs.=20 2016-06-09 20:00:01 28624 28620=20 /opt/informix/informix1170FC8W1/bin/onbar=5Fd complete, returning 156 (0x9c= )=20 ------------------------------=20 Thanks & Regards,=20 Pravin Bankar=20 HP Please consider the environment before printing this e-mail.=20 --001a113d15d81dd1080534e95a3a=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20
Did you change LTAPEDEV in the ONCONFIG file manually or using onmode -wf?
If you made the change manually then it will not take effect until you
bounce the engine.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Fri, Jun 10, 2016 at 5:42 AM, Pravin Bankar <pravinebankar@gmail.com>
wrote:
> Hello,
> I am trying to post below question on old site (iiug.org) under IDS
> section, but facing incomplete submission.
>
> My post is as below.. can you please assist on same. Thank you.
>
> Hello,
>
> Based on below bar_act.log, I followed the technote:
> http://www-01.ibm.com/support/docview.wss?uid=swg21641498
> As per technote, changed the value for LTAPEDEV to non /dev/null.
> But its not worked for me.. may be missing something. Can anyone suggest on
> same..
> IDS and OS details:
> IDS: 11.70.FC8W1
> OS: RedHat GNU/Linux x86_64
>
> Please refer below bar_act.log as follow:
> $more bar_act.log.061016
> 2016-06-09 20:00:01 28624 28620
> /opt/informix/informix1170FC8W1/bin/onbar_d -b -L 0
> 2016-06-09 20:00:01 28624 28620 (-43336) Logical Logs cannot be backed-up
> because the database server is
> dismissing the logical logs.
> 2016-06-09 20:00:01 28624 28620 (-43338) Non whole-system backups are not
> allowed if the database server is
> dismissing logical logs.
> 2016-06-09 20:00:01 28624 28620
> /opt/informix/informix1170FC8W1/bin/onbar_d complete, returning 156 (0x9c)
>
> ------------------------------
> Thanks & Regards,
> Pravin Bankar
> HP Please consider the environment before printing this e-mail.
>
> --001a113d15d81dd1080534e95a3a
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113a98383c51410534e9ebb6
Thanks Martin for confirmation.
Yes, I have to restart the IDS.
It is test server and testing few scripts.
I will update accordingly; based on IDS restart and onbar backup completion.
Thanks.
~ Pravin Bankar
Thanks Art.
I manually updated the value for LTAPEDEV in onconfig.
And about to bounce the IDS but, was in between so it left back as it.
Also same time want to confirm; will there be any alternate.
No issue, I will confirm based on next IDS bounce and onbar backup.
Thanks.
~ Pravin Bankar
Pravin:
Was "will there be any alternate" a question? Not clear what you are
asking if it was.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Fri, Jun 10, 2016 at 6:34 AM, PRAVIN BANKAR <pravinebankar@gmail.com>
wrote:
> Thanks Art.
> I manually updated the value for LTAPEDEV in onconfig.
> And about to bounce the IDS but, was in between so it left back as it.
> Also same time want to confirm; will there be any alternate.
>
> No issue, I will confirm based on next IDS bounce and onbar backup.
>
> Thanks.
> ~ Pravin Bankar
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1144577e4983380534eb9986
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar