Oninit cdi / Archive
Talk to an expert →

Re: changying from ANSI mode to unbuffered logging

Posted in 1998

Topics: Backup & Restore, Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion

Webster D'Souza — — source: Informix-list mailing list archive (1991-1998)

You need not do a dbexport to change from ANSI mode to unbuffered logging. If you are using Informix 5.X then you will have to execute the following command. Firstly you will have to set the tape parameters as /dev/null. After doing so from the $ prompt exectue the following command tbtape -s -U <database> It will ask you the level of archive to be taken. Specify 0. If you are using Informix 7.X instead of "tbtape" you will have to mention "ontape". Below are some other options that can be useful to you.. -A set the following database(s) to ansi logging -B set the following database(s) to buffered logging -N set the following database(s) to no logging -U set the following database(s) to unbuffered logging Regards, Webster ANTS wrote: > Yes, that what we are going to do. Recreate the database. If there are any > other ways please advise. > > But, the application developers worried that something might not work if we > changed. Any idea?? We have 4GL, stored procedures, and client PowerBuilder > applications. > > Regards, > > Nien > -----Original Message----- > From: fernando.collalti@orbit.net <fernando.collalti@orbit.net> > To: Sui <Sui> > Date: Wednesday, March 11, 1998 11:07 ' > Subject: Re: changying from ANSI mode to unbuffered logging > > > > >ANTS wrote: > >> > >> Hi all, > >> > >> We are planning to change the logging mode from ANSI to unbuffered > logging. > >> Any consequences that we have to take in 4GL, stored procedures and > >> PowerBuilder applications?? > >> > >> Please advise.... > >> > >> Nien > >> =========================================== > >> Mails are checked daily and processed right away. > >> If you don't get my replies within 3 days please send your mail again. > >Hello, > > > >Are you sure that this can be done? Unless you execute a > >dbexport and build the database again, it is not possible to change > >loggin status from ANSI to unbuffered/buffered. > > > > > >Kind Regards. > > > >Fernando Collalti > >mail: fernando.collalti@orbit.net > >

Glossary