All 6 messages in topic - view as tree
From: Alessandro Vercelli - view profile
Date: Tues, Aug 22 2006 6:09 pm
Email: "Alessandro Vercelli"
Hi all,
I've configured an IDS database with ISM for backup using onbar; in the
bar_act.log I see:
WARNING: Logical Logs will not be backed up / salvaged because
LTAPEDEV value is /dev/null
but in $ONCONFIG the LTAPEDEV parameter is not set at all; I tried to
set it
is:
cf_id 8
cf_name LTAPEDEV
cf_flags 0
cf_original
cf_effective /dev/null
cf_default /dev/null
I don't know what is the problem but this prevents from backing up logs.
Has anybody any suggestions for this issue?
Many thanks,
Alessandro
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Reply Rate this post: Text for clearing space
From: Martin Fuerderer - view profile
Date: Tues, Aug 22 2006 6:24 pm
Email: Martin Fuerderer
Hi,
set LTAPEDEV in your onconfig file to something that is
different from the string "/dev/null". E.g. set it to
"/tmp/tapedev" (without the apostrophes). This file does
not even need to exist. But it tells IDS that you don't want
it set to /dev/null.
After this change in your onconfig file you need to bring down
the server (e.g. "onmode -k") and start it again ("oninit").
Upon startup it will read the onconfig file and use the new
value for LTAPEDEV. This is necessary for the new value
to become effective.
As long as the value "/dev/null" is effective for the server,
it will always mark a log file immediately as backed up as
soon as it becomes full. This prevents a "logs-full" scenario
if you do not back up logical logs - but it also prevents actual
log backup, because they are always already marked as
backed up whenever onbar (or ontape) would want to backup
a log.
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
IBM Information On Demand Global Conference
October 15-20, 2006, Anaheim, California
see http://www.ibm.com/events/informationondemand
"Alessandro Vercelli"
Sent by: informix-list-boun...@iiug.org
22.08.2006 18:09
To
informix-l...@iiug.org
cc
Subject
Onbar problem
Hi all,
I've configured an IDS database with ISM for backup using onbar; in the
bar_act.log I see:
WARNING: Logical Logs will not be backed up / salvaged because
LTAPEDEV value is /dev/null
but in $ONCONFIG the LTAPEDEV parameter is not set at all; I tried to
set it
is:
cf_id 8
cf_name LTAPEDEV
cf_flags 0
cf_original
cf_effective /dev/null
cf_default /dev/null
I don't know what is the problem but this prevents from backing up logs.
Has anybody any suggestions for this issue?
Many thanks,
Alessandro
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
_______________________________________________
Informix-list mailing list
Informix-l...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Reply Rate this post: Text for clearing space
From: Alessandro Vercelli - view profile
Date: Wed, Aug 23 2006 11:26 am
Email: "Alessandro Vercelli"
Hi Martin,
I placed
"IBM Informix Backup and Restore Guide" (Part No. CT1SLNA, march 2003),
on page 9-26, says:
"If you specify a tape device in the LTAPEDEV configuration parameter,
ON-Bar ignores the value. ON-Bar also ignores the value of the LTAPEBLK,
LTAPESIZE, TAPEDEV, TAPEBLK, and TAPESIZE parameters. Consider leaving
these parameter values blank when you use ON-Bar because the storage
manager sets these values."
I think this part of documentation is not very clear.
Many thanks for your help.
Regards,
Alessandro
"Martin Fuerderer"
news:mailman.334.1156263329.20706.informix-list@iiug.org
> Hi,
> set LTAPEDEV in your onconfig file to something that is
> different from the string "/dev/null". E.g. set it to
> "/tmp/tapedev" (without the apostrophes). This file does
> not even need to exist. But it tells IDS that you don't want
> it set to /dev/null.
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Reply Rate this post: Text for clearing space
From: Martin Fuerderer - view profile
Date: Wed, Aug 23 2006 7:02 pm
Email: Martin Fuerderer
Hi,
hmm. Maybe it is not the clearest description.
It is correct in that onbar does not use the value of LTAPEDEV
(or TAPEDEV). But the server is still using it ...
I'm currently not 100% sure about the fallback rules for default
values when a value is missing (but the parameter is there).
There was something like it checks in "onconfig.std" and or
"onconfig" files, though I'm also not sure about the exact order.
Maybe somewhere there you have /dev/null for LTAPEDEV
and that's why.
Or you initially changed the actual onconfig file ($ONCONFIG)
from /dev/null to blank (or whatever), but you didn't restart the
server ... ?
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
IBM Information On Demand Global Conference
October 15-20, 2006, Anaheim, California
see http://www.ibm.com/events/informationondemand
informix-list-boun...@iiug.org wrote on 23.08.2006 11:26:27:
- Hide quoted text -
- Show quoted text -
> Hi Martin,
> I placed
> "IBM Informix Backup and Restore Guide" (Part No. CT1SLNA, march 2003),
> on page 9-26, says:
> "If you specify a tape device in the LTAPEDEV configuration parameter,
> ON-Bar ignores the value. ON-Bar also ignores the value of the LTAPEBLK,
> LTAPESIZE, TAPEDEV, TAPEBLK, and TAPESIZE parameters. Consider leaving
> these parameter values blank when you use ON-Bar because the storage
> manager sets these values."
> I think this part of documentation is not very clear.
> Many thanks for your help.
> Regards,
> Alessandro
> "Martin Fuerderer"
> news:mailman.334.1156263329.20706.informix-list@iiug.org
> > Hi,
> > set LTAPEDEV in your onconfig file to something that is
> > different from the string "/dev/null". E.g. set it to
> > "/tmp/tapedev" (without the apostrophes). This file does
> > not even need to exist. But it tells IDS that you don't want
> > it set to /dev/null.
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
Reply Rate this post: Text for clearing space
Subject changed: Re 2: Onbar problem
From: Martin Fuerderer - view profile
Date: Thurs, Aug 24 2006 10:44 am
Email: Martin Fuerderer
Hi,
The same manual, edition for IDS 10 (December 2004) says
in addition:
----------------------------------------------------------------------------------------------
...
Consider leaving these parameter values blank when you use
ON?Bar because the storage manager sets these values.
Warning:
Set LTAPEDEV to /dev/null or leave it blank on UNIX or \dev\nul
or NUL on Windows only if you do not want to back up the logical
logs. The ON?Bar activity log will display a warning and return
code 152. Because the database server marks the logical logs
as backed up when they are no longer current, ON?Bar cannot find
logical logs to back up. All transactions in those logs are lost, and
you will not be able to restore them.
If you performed a whole-system backup with LTAPEDEV set to null,
you must use the onbar -r -w -p command during restore to notify
ON?Bar that you do not want to restore the logs.
For more information, see ?Considerations When LTAPEDEV is
Set to Null? on page 6-21.
----------------------------------------------------------------------------------------------
This should be clearer, I guess.
You also can download new documentation at this site
http://www.ibm.com/software/data/informix/pubs/library/ids_100.html
Ciao,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
e-mail: marti...@de.ibm.com
Notes: Martin Fuerderer/Germany/IBM@IBMDE
IBM Information On Demand Global Conference
October 15-20, 2006, Anaheim, California
see http://www.ibm.com/events/informationondemand
informix-list-boun...@iiug.org wrote on 23.08.2006 11:26:27:
- Hide quoted text -
- Show quoted text -
> Hi Martin,
> I placed
> "IBM Informix Backup and Restore Guide" (Part No. CT1SLNA, march 2003),
> on page 9-26, says:
> "If you specify a tape device in the LTAPEDEV configuration parameter,
> ON-Bar ignores the value. ON-Bar also ignores the value of the LTAPEBLK,
> LTAPESIZE, TAPEDEV, TAPEBLK, and TAPESIZE parameters. Consider leaving
> these parameter values blank when you use ON-Bar because the storage
> manager sets these values."
> I think this part of documentation is not very clear.
> Many thanks for your help.
> Regards,
> Alessandro
> "Martin Fuerderer"
> news:mailman.334.1156263329.20706.informix-list@iiug.org
> > Hi,
> > set LTAPEDEV in your onconfig file to something that is
> > different from the string "/dev/null". E.g. set it to
> > "/tmp/tapedev" (without the apostrophes). This file does
> > not even need to exist. But it tells IDS that you don't want
> > it set to /dev/null.
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
Reply Rate this post: Text for clearing space
From: Alessandro Vercelli - view profile
Date: Thurs, Aug 24 2006 11:41 am
Email: "Alessandro Vercelli"
Hi Martin,
the IDS 10 guide is more clear, indeed.
I bounced the db several times but in sysconfig table the value was
always /dev/null; when I builded the db LTAPEDEV was /dev/null, and
probably a value is needed to change it and placing spaces is not
accepted.
Many thanks for your help.
Ciao,
Alessandro
"Martin Fuerderer"
news:mailman.349.1156408508.20706.informix-list@iiug.org
> Hi,
> The same manual, edition for IDS 10 (December 2004) says
> in addition:
> ----------------------------------------------------------------------------------------------
> ...
> Consider leaving these parameter values blank when you use
> ON?Bar because the storage manager sets these values.
> Warning:
> Set LTAPEDEV to /dev/null or leave it blank on UNIX or \dev\nul
> For more information, see ?Considerations When LTAPEDEV is
> Set to Null? on page 6-21.
> ----------------------------------------------------------------------------------------------
> This should be clearer, I guess.
> You also can download new documentation at this site
> http://www.ibm.com/software/data/informix/pubs/library/ids_100.html
> Ciao,
> Martin
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Reply Rate this post: Text for clearing space
End of messages
No comments:
Post a Comment