IDS Forum

Re: Logical logs backup

Posted By: Martin Fuerderer
Date: Thursday, 20 August 2009, at 3:30 a.m.

In Response To: Logical logs backup (LAKSHMI DEVI PALANISSAMY)

Hi,

logical logs that have the 'B'-flag (in output of "onstat -l")
are backed up (already).
So even before you did the manual logical log backup,
all your logs were already backed up, except log 8
because it was the (then) current log file.
Your (manual) logical log backup also advanced
the current log file by one. Hence afterwards all
logs were backed up except log 9 as this now is
the current log file.

So I would guess that somehow your log files do
get backed up "automatically".

[ Or they get backed up to "/dev/null". This
means that they do not really get backed up,
but the server treats them as backed up as
soon as they become full. Hence you don't
need to bother with log backup. This is a
special mode requiring the configuration of
onconfig parameter LTAPEDEV being set to
/dev/null. Although I do not think you have this
configuration, because it should cause some
kind of message for the manual log backup
along the lines that this is not possible/allowed
to /dev/null ... ]

You can manually advance the current logical
log file by one log using the command
"onmode -l". This will not by itself backup the
completed logical log. (The previous current log
will be "completed" even when not full. And as
a completed log it is a candidate for log backup.)
Wait for a moment or two and then check again
using "onstat -l". I guess you will see that this
log will soon get the 'B'-flag ... Also you can
check the IDS message log file (or use
"onstat -m") to see a message about log backup.

Then you can find out how the log was
"automatically" backed up. The most common
mechanism is the "alarm program", but there
can be others, or the /dev/null setting as
mentioned above.

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martin Jetter
Board of Management: Erich Baier
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

ids-bounces@iiug.org wrote on 08/20/2009 08:03:25 AM:

> [image removed]
>
> Logical logs backup [16729]
>
> LAKSHMI DEVI PALANISSAMY
>
> to:
>
> ids
>
> 08/20/2009 08:04 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hi,
>
> We are using IDS 11.5 and OS is RHEL 5.3
>
> We have 10 logical logs having the id from 4-13.
> I did a database import to the existing database and hence the logical
logs
> becomes full.
> The status of the logical logs is
> Logical log 4 to 7 -> U_B__
> Logical log 8 -> U_C_L
> Logical log 9-13 -> U_B__
> All the logical logs are 100% full
>
> Hence i did a logical log backup and level 0 backup
> After that the status is
> Logical log 4 to 8 -> U_B__
> Logical log 9 -> U_C_L
> Logical log 10-13 -> U_B__
>
> But yet the status of %used didnt go off to 0
>
> When i did a another logical log backup and level 0 backup. the
> status becomes
> Logical log 4 to 9 -> U_B__
> Logical log 10 -> U_C_L
> Logical log 11-13 -> U_B__
>
> And now the %used gets decreases from 100 to a number
>
> Is there anyway i can take backup and clear all the existing logical
logs?
> Should i use the automaticl backup using alarm program?
>
> Thanks in advance!
>
> Thanks,
> Lakki
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• Logical logs backup
  LAKSHMI DEVI PALANISSAMY -- Thursday, 20 August 2009, at 2:03 a.m.
  • Re: Logical logs backup
    Martin Fuerderer -- Thursday, 20 August 2009, at 3:30 a.m.
    • Re: Logical logs backup
      LAKSHMI DEVI PALANISSAMY -- Thursday, 20 August 2009, at 4:53 a.m.
      • Re: Logical logs backup
        Martin Fuerderer -- Thursday, 20 August 2009, at 5:45 a.m.
        • Re: Logical logs backup
          LAKSHMI DEVI PALANISSAMY -- Thursday, 20 August 2009, at 6:31 a.m.
          • Re: Logical logs backup
            Martin Fuerderer -- Thursday, 20 August 2009, at 7:30 a.m.
          • Re: Logical logs backup
            Art Kagel -- Thursday, 20 August 2009, at 10:38 a.m.
  • Re: Logical logs backup
    Art Kagel -- Thursday, 20 August 2009, at 10:38 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.