onbar and onlog

Hi, to backup the IDS 7.31 UC2 instance we use onbar in conjunction with Networker 5.1. The Logical Logs are saved by the event driven script log_full.sh which starts onbar -l. I´m looking for a way to analyse log files with onlog which are already backuped to tape. I want to read certain files from tape not from disk. Older log files would not be on disk anyhow. If I would use ontape it would be no problem. But with onbar I have no idea how to get the log files. Another question: Is there anywhere a tool available that helps analysing the log files. My idea is that I can ask the following: user "x" has updated table "x" row "x" with value "x" at a certain point of time. TIA Reinhard

Hi all, please do not kill me for asking again. Is there nobody who can help with onbar and onlog? I cannot find anything in manuals and release files. Any suggestions would be highly appreciated. Reinhard Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> schrieb in im Newsbeitrag: 827vrf$bnv$1@news08.btx.dtag.de... > Hi, > > to backup the IDS 7.31 UC2 instance we use onbar in > conjunction with Networker 5.1. The Logical Logs are saved by > the event driven script log_full.sh which starts onbar -l. > > I´m looking for a way to analyse log files with onlog which are > already backuped to tape. I want to read certain files from tape > not from disk. Older log files would not be on disk anyhow. > > If I would use ontape it would be no problem. But with onbar I have > no idea how to get the log files. > > Another question: Is there anywhere a tool available that helps > analysing the log files. My idea is that I can ask the following: > user "x" has updated table "x" row "x" with value "x" at a certain > point of time. > > TIA > > Reinhard > >

Sorry but there is no way to do what you want to do. You can only us onlog to look at the currently resident logfiles. This is the reason that backed up logs are no longer marked Free so that onlog will display their contents and at least you can look at the backed up logs that have not yet been overwritten. Art S. Kagel Reinhard Habichtsberg wrote: > > Hi all, > > please do not kill me for asking again. > Is there nobody who can help with onbar and onlog? > I cannot find anything in manuals and release files. > Any suggestions would be highly appreciated. > > Reinhard > > Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> schrieb in > im Newsbeitrag: 827vrf$bnv$1@news08.btx.dtag.de... > > Hi, > > > > to backup the IDS 7.31 UC2 instance we use onbar in > > conjunction with Networker 5.1. The Logical Logs are saved by > > the event driven script log_full.sh which starts onbar -l. > > > > I´m looking for a way to analyse log files with onlog which are > > already backuped to tape. I want to read certain files from tape > > not from disk. Older log files would not be on disk anyhow. > > > > If I would use ontape it would be no problem. But with onbar I > have > > no idea how to get the log files. > > > > Another question: Is there anywhere a tool available that helps > > analysing the log files. My idea is that I can ask the following: > > user "x" has updated table "x" row "x" with value "x" at a certain > > point of time. > > > > TIA > > > > Reinhard > > > >

In article <82ifrj$flt$1@news00.btx.dtag.de>, "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> wrote: > Hi all, > > please do not kill me for asking again. > Is there nobody who can help with onbar and onlog? > I cannot find anything in manuals and release files. > Any suggestions would be highly appreciated. Read 'Admin Guide' and other archive/backup docs on www.informix.com/answers/english/pids73.htm Thanh > > Reinhard > > Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> schrieb in > im Newsbeitrag: 827vrf$bnv$1@news08.btx.dtag.de... > > Hi, > > > > to backup the IDS 7.31 UC2 instance we use onbar in > > conjunction with Networker 5.1. The Logical Logs are saved by > > the event driven script log_full.sh which starts onbar -l. > > > > I'm looking for a way to analyse log files with onlog which are > > already backuped to tape. I want to read certain files from tape > > not from disk. Older log files would not be on disk anyhow. > > > > If I would use ontape it would be no problem. But with onbar I > have > > no idea how to get the log files. > > > > Another question: Is there anywhere a tool available that helps > > analysing the log files. My idea is that I can ask the following: > > user "x" has updated table "x" row "x" with value "x" at a certain > > point of time. > > > > TIA > > > > Reinhard > > > > > > Sent via Deja.com http://www.deja.com/ Before you buy.

Art S. Kagel <kagel@bloomberg.net> schrieb in im Newsbeitrag: 384D2A45.1A989939@bloomberg.net... > Sorry but there is no way to do what you want to do. You can only us > onlog to look at the currently resident logfiles. This is the reason that > backed up logs are no longer marked Free so that onlog will display their > contents and at least you can look at the backed up logs that have not yet > been overwritten. > > Art S. Kagel > Hi Art, maybe the reason is my poor english that I don´t understand the contradiction between your explanation and the following from BACKUP AND RESTORE GUIDE for IDS V. 7.3 also seen on www.informix.com/answers/english/pids73.htm : [Restoring to point in time ... To determin the appropriate date and tome for the restore, use the _onlog_ utility, which your Admiinistrators Guide describes. The _onlog_ display the date and time of committes transactions. Do not use the database server time or your watch ] (or Big Ben :-) ) [to determine the point-in-restore time, because it might not be accurate. ] How can I do this if I´m not able to read the logical logs with onlogfrom tape, e.g. the chunk where the logical logs or stored is destroyed? Regards, Reinhard

<tqma@my-deja.com> schrieb in im Newsbeitrag: 82kd9g$84b$1@nnrp1.deja.com... > > Read 'Admin Guide' and other archive/backup docs on > > www.informix.com/answers/english/pids73.htm > You can be sure I did. And I read them again after your posting but I didn´t get cleverer about it. Regards, Reinhard