Re: Disable backups of Informix temporarily

If you set LTAPEDEV to /dev/null then you will potentially create recovery problems, depending onwhen you next archive is scheduled. You will LOSE all the transactions that occur while /LTAPEDEV is set to /dev/null I am guessing each log is backing up when it is full, and the backup is occuring from a script that runns maybe from ALARMPROGRAM. You might have enough room in your logical logs to stop the script that backs each log up when it is full while you do the work, and then start the script again. However, you are right, the database will "stop working" if you don't back up the logs for a while as the logs will become full and you will then be forced to back them up to start the database working again. You have 2 choices 1/ lose the transactions ... the /dev/null solution 2/ don't lose any transactions by making sure you have enough logical logs to store the transactions while you perform whatever function you need to perform. Stop the backups of the transactions, perform your action and then restart the log backups.. Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<6eEmc.10471$V97.5464@newsread1.news.pas.earthlink.net>... > adave wrote: > > I am in the process of reconfiguring the backup server (separate > > issue), and in the meanwhile, backups on the Informix dbs cannot > > happen. > > I'm inclined to say 'Be Very Worried'. But you probably already are. > > > I believe the db stops working if i don't backup the logical logs and > > the databases for some time. Is it possible to redirect it to > > /dev/null or some other way until the backup server is working again? > > Yes - set LTAPEDEV to /dev/null and logical logs are not backed up. > > > I don't know much about Informix, but can provide details if needed.