Write Logical Logs To Disk

Hi, Greetings, The situation: I am trying to write the logical logs on the first instance to the disk instead of the tape so that I may transfer these to the second instance and use recovery to bring it upto date. I am trying this to implement production backup at the database level. The problem: IDS will not write to a disk. I tried by creating a pipe and writing to it, but that failed too. If there any way I can write my logical logs to the disk instead of the tape ? Thanking you. Regards Gagan

You can use ISM (Informix Storage Manager -- which is a stripped down version of Legato). It comes free with IDS. It works nicely to send the logs to a disk filesystem. I used this in conjuction with EMC BCV's to perform an external restore with onbar, and applied the logs from there. "GAGAN DESHPANDE" <gagandeshpande@ho To: ids@iiug.org tmail.com> cc: Sent by: Subject: Write Logical Logs To Disk [2443] forum.subscriber@i iug.org 01/19/2004 01:21 PM Hi, Greetings, The situation: I am trying to write the logical logs on the first instance to the disk instead of the tape so that I may transfer these to the second instance and use recovery to bring it upto date. I am trying this to implement production backup at the database level. The problem: IDS will not write to a disk. I tried by creating a pipe and writing to it, but that failed too. If there any way I can write my logical logs to the disk instead of the tape ? Thanking you. Regards Gagan

Make sure the file is already there, is owned by informix:informix, and has 660 permissions. > -----Original Message----- > From: GAGAN DESHPANDE [mailto:gagandeshpande@hotmail.com] > Sent: 19 January 2004 18:21 > To: ids@iiug.org > Subject: Write Logical Logs To Disk [2443] > > > Hi, > > Greetings, > > The situation: > > I am trying to write the logical logs on the first instance > to the disk instead of the tape so that I may transfer these > to the second instance and use recovery to bring it upto > date. I am trying this to implement production backup at the > database level. > > The problem: > > IDS will not write to a disk. I tried by creating a pipe and > writing to it, but that failed too. > > If there any way I can write my logical logs to the disk > instead of the tape ? > > Thanking you. > > Regards > Gagan > >-------------------------------------------------------- Eurolife Assurance Group plc, Eurolife House, 16 St John Street, London, EC1M 4NT Tel: 020-7454 1151 Fax: 020-7454 1277 www.eurolife.co.uk Registered in England, number 2471313 This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.

Hi, how are you backing up the logical logs ? Are you using ontape or ON-Bar ? Assuming you're using ontape : - specify the absolute file path name in your $ONCONFIG file with parameter LTAPEDEV, - make sure you've done as Scott wrote (see below), - if you've a running "ontape -c" you need to stop it and restart it, so that it picks up the new value from your $ONCONFIG. - be sure you "save" the file before hitting 'RETURN" when ontape asks for a new tape ... With ON-Bar it's a bit more complicated. Thus explanation can only given upon request. :) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "Scott O'Rourke" <scott@eurolife.co.uk> Sent by: forum.subscriber@iiug.org 20.01.2004 15:28 To: ids@iiug.org cc: Subject: RE: Write Logical Logs To Disk [2454] Make sure the file is already there, is owned by informix:informix, and has 660 permissions. > -----Original Message----- > From: GAGAN DESHPANDE [mailto:gagandeshpande@hotmail.com] > Sent: 19 January 2004 18:21 > To: ids@iiug.org > Subject: Write Logical Logs To Disk [2443] > > > Hi, > > Greetings, > > The situation: > > I am trying to write the logical logs on the first instance > to the disk instead of the tape so that I may transfer these > to the second instance and use recovery to bring it upto > date. I am trying this to implement production backup at the > database level. > > The problem: > > IDS will not write to a disk. I tried by creating a pipe and > writing to it, but that failed too. > > If there any way I can write my logical logs to the disk > instead of the tape ? > > Thanking you. > > Regards > Gagan > >-------------------------------------------------------- Eurolife Assurance Group plc, Eurolife House, 16 St John Street, London, EC1M 4NT Tel: 020-7454 1151 Fax: 020-7454 1277 www.eurolife.co.uk Registered in England, number 2471313 This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.

hi there remember "ontape -c" is interactive, so you should script something like this: (unix-only) ### ontape -c <<EOF 1>/tmp/ontape.log 2>&1 & <-------- empty line !!!EOF cat /foo/bar/fifo | gzip -c > logicallog.dat #### save lots of disk space ### And, as Scott O'roruke wrote, fifo must be 660, informix.informix hope it helps greetz