Re: ontape -l roll-forward of many logs

You can not just cat the files together for patently obvious reasons, i.e. each log file has it's own individual header It is trivial to script the process though Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 European Conference. Vienna, Austria. 2-6 October 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Neil Truby [mailto:neil.truby@ardenta.com] > Posted At: 01 September 2006 16:14 > Posted To: comp.databases.informix > Conversation: ontape -l roll-forward of many logs > Subject: ontape -l roll-forward of many logs > > > IDS v7.31 UD8 on solaris > > I'm doing a logical log rollforward. The logs are backed up > by an ontape -a process, to disk, and are about 10m each in size. > > It's all working fine if i roll forward one log then in a > seprate screen move the next one into position. But this is > a pain in the arse: I have hundreds to do and want to do them > in one fell swoop. > > But if I cat all 100 into one large file ontape bombs out > almost immediately asking if I have more logs. Similarly if > I run onlog on the 1concatenation of 100 logs it reads just > the first one and ask me if I have any more. > > Why is this happening? I've changed LTAPESIZE in the > ONCONFIG file on the restored server from 10m to 2g but it's > made no difference. > > SOMETHING is teling ontape/onlog to read only the first 10m > of the concatenated file. But what?! > > Thx > > Neil > >

"Paul Watson" <paul@oninit.com> wrote in message news:09b301c6ce17$acfed7b0$5583390a@arnold... > You can not just cat the files together for patently obvious reasons, > i.e. each log file has it's own individual header > > It is trivial to script the process though Gosh! I think it's far from trivial, because you have to interleave ontape -l's "Do you have another tape?" loop with a loop moving the next loginto place each time. If you have a scriptfor it I'll give you a pound. Thanks Neil

You are kidding, of course it's trivial mkfifo /tmp/mypipe chmod 666 /tmp/mypipe ontape -l < /tmp/mypipe > /tmp/ontape.out & Then write a simple awk script that reads the file /tmp/ontape.out via tail -f The only gotcha is under Linux you need to use --pid on the tail -f to ensure the tail closes when the ontape is complete. Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 European Conference. Vienna, Austria. 2-6 October 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Neil Truby [mailto:neil.truby@ardenta.com] > Posted At: 02 September 2006 01:43 > Posted To: comp.databases.informix > Conversation: ontape -l roll-forward of many logs > Subject: Re: ontape -l roll-forward of many logs > > > "Paul Watson" <paul@oninit.com> wrote in message > news:09b301c6ce17$acfed7b0$5583390a@arnold... > > You can not just cat the files together for patently > obvious reasons, > > i.e. each log file has it's own individual header > > > > It is trivial to script the process though > > Gosh! I think it's far from trivial, because you have to > interleave ontape -l's "Do you have another tape?" loop with > a loop moving the next log into place each time. > If you have a scriptfor it I'll give you a pound. > > Thanks > Neil > >

"Paul Watson" <paul@oninit.com> wrote in message news:1e0801c6cea1$4c7db0c0$5583390a@arnold... > You are kidding, of course it's trivial > > mkfifo /tmp/mypipe > chmod 666 /tmp/mypipe > ontape -l < /tmp/mypipe > /tmp/ontape.out &> > Then write a simple awk script that reads the file /tmp/ontape.out via > tail -f Doesn't work for me. The script ends staright away, leaving an zero-length file /tmp/ontape.out (on Solaris). Where do you put the name of the restore file?

What is in the awk script ? Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 European Conference. Vienna, Austria. 2-6 October 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Neil Truby [mailto:neil.truby@ardenta.com] > Posted At: 02 September 2006 14:03 > Posted To: comp.databases.informix > Conversation: ontape -l roll-forward of many logs > Subject: Re: ontape -l roll-forward of many logs > > > "Paul Watson" <paul@oninit.com> wrote in message > news:1e0801c6cea1$4c7db0c0$5583390a@arnold... > > You are kidding, of course it's trivial > > > > mkfifo /tmp/mypipe > > chmod 666 /tmp/mypipe > > ontape -l < /tmp/mypipe > /tmp/ontape.out &> > > > Then write a simple awk script that reads the file > /tmp/ontape.out via > > tail -f > > Doesn't work for me. The script ends staright away, leaving > an zero-length file /tmp/ontape.out (on Solaris). Where do > you put the name of the restore file? > >

Neil Truby wrote: > "Paul Watson" <paul@oninit.com> wrote in message > news:09b301c6ce17$acfed7b0$5583390a@arnold... > >>You can not just cat the files together for patently obvious reasons, >>i.e. each log file has it's own individual header >> >>It is trivial to script the process though > > > Gosh! I think it's far from trivial, because you have to interleave > ontape -l's "Do you have another tape?" loop with a loop moving the next log> into place each time. > If you have a scriptfor it I'll give you a pound. Get TCL & Expect. Expect is a superlanguage written over TCL (all TCP syntax is available also in Expect scripts) which has a non-procedural syntax specific to responding to prompts from software or hardware. Writing a script to run ontape -l and rename the files as ontape asks for the next one is trivial in Expect. I should have don my eventalarm.c using Expect (TCP and therefore Expect is embedable). Art S. Kagel