Re: Newbie question on logs

Whoa. Did you setup ISM? Onbar needs a storage manager and IDS 7.3x delivers ISM (Informix Storage Manager, essentially Legato Lite) for you to use but you need to configure it. ISM does not use the ONCONFIG TAPE/LTAPE parameters. Read the Backup and Restore Manual (or is it the Archive and Restore Manual?) about setting up onbar and ISM. In the meantime you can quickly backup the logs by setting the LTAPE parameters and using ontape -a to archive the logical logs. The archives will be compatible with onbar for later restores if needed. Art S. Kagel PS wrote: > > I tried all possibilities of onbar, but still the logs are not marked as > backuped ... > I use dbaccess on the server ( NT ) ; and I get a strange error in the log : > ( I don't ask for abort !!) > 11:11:01 Aborted by client. > 11:11:00 Archive on rootdbs ABORTED. > 11:10:59 Level 0 Archive started on rootdbs > 11:10:59 Checkpoint Completed: duration was 0 seconds. > 11:10:59 Logical Log 1 - Backup Aborted > Aborted by client. > 11:10:57 Logical Log 1 - Backup Started > 11:09:59 Aborted by client. > 11:09:59 Archive on rootdbs ABORTED. > 11:09:58 Level 0 Archive started on rootdbs > 11:09:57 Checkpoint Completed: duration was 0 seconds. > 11:09:56 Logical Log 1 - Backup Aborted > Aborted by client. > 11:09:54 Logical Log 1 - Backup Started > > "Nick Kataria" <kataria.nick@emeryworld.com> wrote in message > news:8h8mfu$ake$1@news.cnf.com... > If the flag is U-B---- then that log will be used when it's turn will come > (in circular queue fashion). Don't worry if the flag has U-B----- and %used > is 100 or less. > > You have to take level 0 archive to make newly added log to be active. > > PS <no@mail.please> wrote in message news:8h8j1r$qsg$1@news0.skynet.be... > > How to empty the logical logs > > > > I tried to backup ( onbar -l ...) , but still they are full. > > I also tried to create a 11th log, but it is marked as NEw, Inactive ! How > > to activate it ? > > > > Thanks > > > > > >

Thanks, I am just assessing the modifications we will have to do in our code if we change the RDBMS to informix. So I got a trial version, withgout any proper doc. I finally succeded to "backup" the logs by changing the tape device name in the onconfig to NUL, and issuing "ontape -a" ( My NT server does not have a tape device... BTW, is there a nice GUI interface, apart from the sluiggish ISA, to manage an Informix system ? Remember, I am on NT, and I didn't choose that ... Philip "Art S. Kagel" <kagel@bloomberg.net> wrote in message news:393BC8F8.1472B0E0@bloomberg.net... Whoa. Did you setup ISM? Onbar needs a storage manager and IDS 7.3x delivers ISM (Informix Storage Manager, essentially Legato Lite) for you to use but you need to configure it. ISM does not use the ONCONFIG TAPE/LTAPE parameters. Read the Backup and Restore Manual (or is it the Archive and Restore Manual?) about setting up onbar and ISM. In the meantime you can quickly backup the logs by setting the LTAPE parameters and using ontape -a to archive the logical logs. The archives will be compatible with onbar for later restores if needed. Art S. Kagel PS wrote: > > I tried all possibilities of onbar, but still the logs are not marked as > backuped ... > I use dbaccess on the server ( NT ) ; and I get a strange error in the log : > ( I don't ask for abort !!) > 11:11:01 Aborted by client. > 11:11:00 Archive on rootdbs ABORTED. > 11:10:59 Level 0 Archive started on rootdbs > 11:10:59 Checkpoint Completed: duration was 0 seconds. > 11:10:59 Logical Log 1 - Backup Aborted > Aborted by client. > 11:10:57 Logical Log 1 - Backup Started > 11:09:59 Aborted by client. > 11:09:59 Archive on rootdbs ABORTED. > 11:09:58 Level 0 Archive started on rootdbs > 11:09:57 Checkpoint Completed: duration was 0 seconds. > 11:09:56 Logical Log 1 - Backup Aborted > Aborted by client. > 11:09:54 Logical Log 1 - Backup Started > > "Nick Kataria" <kataria.nick@emeryworld.com> wrote in message > news:8h8mfu$ake$1@news.cnf.com... > If the flag is U-B---- then that log will be used when it's turn will come > (in circular queue fashion). Don't worry if the flag has U-B----- and %used > is 100 or less. > > You have to take level 0 archive to make newly added log to be active. > > PS <no@mail.please> wrote in message news:8h8j1r$qsg$1@news0.skynet.be... > > How to empty the logical logs > > > > I tried to backup ( onbar -l ...) , but still they are full. > > I also tried to create a 11th log, but it is marked as NEw, Inactive ! How > > to activate it ? > > > > Thanks > > > > > >

PS wrote: > > Thanks, > I am just assessing the modifications we will have to do in our code if we > change the RDBMS to informix. So I got a trial version, withgout any proper > doc. The docs are online on the Informix WEB Site for viewing or download. FWIW. > I finally succeded to "backup" the logs by changing the tape device name in > the onconfig to NUL, and issuing "ontape -a" ( My NT server does not have a > tape device... > > BTW, is there a nice GUI interface, apart from the sluiggish ISA, to manage > an Informix system ? > Remember, I am on NT, and I didn't choose that ... There used to be a GUI admin interface, nice is not a word one would use associated with it. It was functional enough but TBT most of us used and continue to use the commandline utilities, some of which I know are not available on NT. The GUI was so ignored that it has been completely replaced with the ISA. Some DBAs are beginning to use the ISA and to give feedback to Informix to improve it. That is an evolving product and will hopefully grow into a very useful tool. Art S. Kagel > Philip > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:393BC8F8.1472B0E0@bloomberg.net... > Whoa. Did you setup ISM? Onbar needs a storage manager and IDS 7.3x > delivers ISM (Informix Storage Manager, essentially Legato Lite) for you to > use but you need to configure it. ISM does not use the ONCONFIG TAPE/LTAPE > parameters. Read the Backup and Restore Manual (or is it the Archive and > Restore Manual?) about setting up onbar and ISM. In the meantime you can > quickly backup the logs by setting the LTAPE parameters and using ontape -a > to archive the logical logs. The archives will be compatible with onbar > for later restores if needed. > > Art S. Kagel > > PS wrote: > > > > I tried all possibilities of onbar, but still the logs are not marked as > > backuped ... > > I use dbaccess on the server ( NT ) ; and I get a strange error in the log > : > > ( I don't ask for abort !!) > > 11:11:01 Aborted by client. > > 11:11:00 Archive on rootdbs ABORTED. > > 11:10:59 Level 0 Archive started on rootdbs > > 11:10:59 Checkpoint Completed: duration was 0 seconds. > > 11:10:59 Logical Log 1 - Backup Aborted > > Aborted by client. > > 11:10:57 Logical Log 1 - Backup Started > > 11:09:59 Aborted by client. > > 11:09:59 Archive on rootdbs ABORTED. > > 11:09:58 Level 0 Archive started on rootdbs > > 11:09:57 Checkpoint Completed: duration was 0 seconds. > > 11:09:56 Logical Log 1 - Backup Aborted > > Aborted by client. > > 11:09:54 Logical Log 1 - Backup Started > > > > "Nick Kataria" <kataria.nick@emeryworld.com> wrote in message > > news:8h8mfu$ake$1@news.cnf.com... > > If the flag is U-B---- then that log will be used when it's turn will come > > (in circular queue fashion). Don't worry if the flag has U-B----- and > %used > > is 100 or less. > > > > You have to take level 0 archive to make newly added log to be active. > > > > PS <no@mail.please> wrote in message news:8h8j1r$qsg$1@news0.skynet.be... > > > How to empty the logical logs > > > > > > I tried to backup ( onbar -l ...) , but still they are full. > > > I also tried to create a 11th log, but it is marked as NEw, Inactive ! > How > > > to activate it ? > > > > > > Thanks > > > > > > > > >

In article <8hiaeh$j8b$1@news1.skynet.be>, "PS" <no@mail.please> writes: > Thanks, > I am just assessing the modifications we will have to do in our code if we > change the RDBMS to informix. So I got a trial version, withgout any proper > doc. You can download docs from Informix (http://www.informix.com). With the full release you get the docs on CD-ROM.