Logical Log Files are Full -- Backup is Needed

I have updated IDS to IBM Informix Dynamic Server Version 11.70.FC1. Unix OS - HP-UX B.11.31 - ia64 After update I am getting following message. IBM Informix Dynamic Server Version 11.70.FC1 -- On-Line (CKPT REQ) – Up 04:53:11 -- 215824 KbytesBlocked:CKPT 10:12:01 Maximum server connections 0 10:12:01 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 6, Llog used 7 10:12:01 Logical Log Files are Full -- Backup is Needed -------------------------------------------------------------- LTAPE is set as LTAPEDEV /Backup/tapedev - which is a big drive When I manually backup logical logs using ontape -a command it works. I also tried LTAPEDEV /tmp but it does not work. Thank you Kanti

Hi, If you don't care about your logical logs then change the value of LTAPEDEV to /dev/null. Unfortunately you will need to stop and restart the instance to make this change take affect. A better option is to create a symbolic link through to /dev/null. Say /dev/kknull or something like that. Good luck. > To: ids@iiug.org > From: kbakarania@pascoclerk.com > Subject: Logical Log Files are Full -- Backup is Needed [21953] > Date: Mon, 15 Nov 2010 15:22:14 -0500 > > I have updated IDS to IBM Informix Dynamic Server Version 11.70.FC1. > Unix OS - HP-UX B.11.31 - ia64 > > After update I am getting following message. > > IBM Informix Dynamic Server Version 11.70.FC1 -- On-Line (CKPT REQ) – > Up 04:53:11 -- 215824 Kbytes> Blocked:CKPT > > 10:12:01 Maximum server connections 0 > 10:12:01 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, > Plog used 6, Llog used 7 > > 10:12:01 Logical Log Files are Full -- Backup is Needed > -------------------------------------------------------------- > > LTAPE is set as LTAPEDEV /Backup/tapedev - which is a big drive > > When I manually backup logical logs using ontape -a command it works. > > I also tried LTAPEDEV /tmp but it does not work. > > Thank you > > Kanti > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

You can change the value of LTAPEDEV through onmonitor and it will make the change immediately w/o the need for bouncing the engine.

If you don't run ontape -a or ontape -c to back up the logs, how are you expecting that they are being backed up instead? If you were using a script in the ALARMPROGRAM to back up each logical log file as it fills, it may be that you were using a modified version of the $INFORMIXDIR/etc/logs_full.sh script. However, the upgrade will have installed the original IBM supplied version of that script which wants to use onbar to back up logs, and since you do not have onbar's storage manager configured, those onbar back ups are failing. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Nov 15, 2010 at 3:22 PM, KANTI BAKARANIA <kbakarania@pascoclerk.com>wrote: > I have updated IDS to IBM Informix Dynamic Server Version 11.70.FC1. > Unix OS - HP-UX B.11.31 - ia64 > > After update I am getting following message. > > IBM Informix Dynamic Server Version 11.70.FC1 -- On-Line (CKPT REQ) – > Up 04:53:11 -- 215824 Kbytes> Blocked:CKPT > > 10:12:01 Maximum server connections 0 > 10:12:01 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 1, > Plog used 6, Llog used 7 > > 10:12:01 Logical Log Files are Full -- Backup is Needed > -------------------------------------------------------------- > > LTAPE is set as LTAPEDEV /Backup/tapedev - which is a big drive > > When I manually backup logical logs using ontape -a command it works. > > I also tried LTAPEDEV /tmp but it does not work. > > Thank you > > Kanti > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636284fba7650e404951ddbc7

1. In your $ONCONFIG check if ALARMPROGRAM is set to the right value like /opt/informix/ids1150/etc/alarmprogram.sh 2. Edit alarmprogram.sh and set: BACKUPLOGS=Y BACKUP_CMD="ontape -a -d" 3. Bounce the engine On 15.11.2010 21:22, KANTI BAKARANIA wrote: > I have updated IDS to IBM Informix Dynamic Server Version 11.70.FC1. > Unix OS - HP-UX B.11.31 - ia64 > > After update I am getting following message. > > IBM Informix Dynamic Server Version 11.70.FC1 -- On-Line (CKPT REQ) – > Up 04:53:11 -- 215824 Kbytes> Blocked:CKPT > > 10:12:01 Maximum server connections 0 > 10:12:01 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, > Plog used 6, Llog used 7 > > 10:12:01 Logical Log Files are Full -- Backup is Needed > -------------------------------------------------------------- > > LTAPE is set as LTAPEDEV /Backup/tapedev - which is a big drive > > When I manually backup logical logs using ontape -a command it works. > > I also tried LTAPEDEV /tmp but it does not work. > > Thank you > > Kanti > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Ivan Zaviç System& DB Administrator Mobile:+381-64-846-99-08 mail: ivan.zavis@mi-system.co.rs _________________________________________________________ M&I SYSTEMS CO. Cirila i Metodija 13/a, 21000 Novi Sad, Serbia Tel/Fax: +381-(0)21-68-98-600 Mail: info@mi-system.co.rs, URL: http://www.mi-system.co.rs

After changing the ALARMPROGRAM in $ONCONFIG to /usr/informix/etc/alarmprogram.sh it works. Now I am not getting the message "Logical Log Files are Full - Backup is Needed". Thank you all Kanti