Fault backup LOGs

IBM Informix 10.00 FC5 + HDR Solaris 10 ==================================== Hi all: I cannot backup the LOGS of my instance, shows the following message to me of error: $ ontape -a Performing automatic backup of logical logs. Please mount tape 1 on /dev/rmt/0 and press Return to continue ... could not write log tape. Please mount tape 1 on /dev/rmt/0 and press Return to continue ... $ onstat - IBM Informix Dynamic Server Version 10.00.FC5W5 -- On-Line (Prim) -- Up 48 days 17:54:17 -- 6069248 KbytesBlocked:LAST_LOG_RESERVED4BACKUP I hope can help me.... THANKS bye _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/

On 19/06/07, Juan Pablo <in4mixperu@hotmail.com> wrote: > IBM Informix 10.00 FC5 + HDR > Solaris 10 > ==================================== > Hi all: > > I cannot backup the LOGS of my instance, shows the following message to me > of error: > > $ ontape -a> > Performing automatic backup of logical logs. > > Please mount tape 1 on /dev/rmt/0 and press Return to continue ... > could not write log tape. > Please mount tape 1 on /dev/rmt/0 and press Return to continue ... > > $ onstat -> > IBM Informix Dynamic Server Version 10.00.FC5W5 -- On-Line (Prim) -- Up 48 > days 17:54:17 -- 6069248 Kbytes> Blocked:LAST_LOG_RESERVED4BACKUP > > I hope can help me.... THANKS > > bye > > _________________________________________________________________ > MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Juan Is there a tape in the drice? Is the tape write protected ? Have youy tried a different tape? Have you changed the tape parameters or onconfig since the last ontape -a, if so change them back. Keith

Hi, you are sure that the tape mounted on device /dev/rmt/0 is OK? And the tape device itself is OK and working? You can try to execute as user "informix" a command like the following to test the tape device and tape: dd if=/dev/zero of=/dev/rmt/0 bs=2048 count=100 The output of this should be something like: 100+0 records in 100+0 records out If you see anything else (especially errors), then you have to fix the tape drive or tape first. To clarify the state of IDS, you may want to run command "onstat -l" to see the state of the log files. Anything helpful in the message log ("onstat -m")? "onstat -g ath" will tell what threads there are and what activity they are persuing. If you suspect the problem is in the server, then the above 3 onstat commands will be a starting point for more detailed analysis (possibly to be done by IBM Informix Tech Support). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 ids-bounces@iiug.org wrote on 19.06.2007 12:28:42: > IBM Informix 10.00 FC5 + HDR > Solaris 10 > ==================================== > Hi all: > > I cannot backup the LOGS of my instance, shows the following message to me > of error: > > $ ontape -a> > Performing automatic backup of logical logs. > > Please mount tape 1 on /dev/rmt/0 and press Return to continue ... > could not write log tape. > Please mount tape 1 on /dev/rmt/0 and press Return to continue ... > > $ onstat -> > IBM Informix Dynamic Server Version 10.00.FC5W5 -- On-Line (Prim) -- Up48 > days 17:54:17 -- 6069248 Kbytes > Blocked:LAST_LOG_RESERVED4BACKUP > > I hope can help me.... THANKS > > bye > > _________________________________________________________________ > MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

As mentioned by Martin and Keith erlier, this issue normally happens with tape or tape drive. If tape is writable, no change in ONCONFIG etc. Another possibility to change SCSI terminator and SCSI cable on TAPE DRIVE. I had this issue about 2 years ago and it fixed by changing SCSI terminator and SCSI cable. Cheers. Martin Fuerderer <MARTINFU@de.ibm.com> wrote: Hi, you are sure that the tape mounted on device /dev/rmt/0 is OK? And the tape device itself is OK and working? You can try to execute as user "informix" a command like the following to test the tape device and tape: dd if=/dev/zero of=/dev/rmt/0 bs=2048 count=100 The output of this should be something like: 100+0 records in 100+0 records out If you see anything else (especially errors), then you have to fix the tape drive or tape first. To clarify the state of IDS, you may want to run command "onstat -l" to see the state of the log files. Anything helpful in the message log ("onstat -m")? "onstat -g ath" will tell what threads there are and what activity they are persuing. If you suspect the problem is in the server, then the above 3 onstat commands will be a starting point for more detailed analysis (possibly to be done by IBM Informix Tech Support). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 ids-bounces@iiug.org wrote on 19.06.2007 12:28:42: > IBM Informix 10.00 FC5 + HDR > Solaris 10 > ==================================== > Hi all: > > I cannot backup the LOGS of my instance, shows the following message to me > of error: > > $ ontape -a> > Performing automatic backup of logical logs. > > Please mount tape 1 on /dev/rmt/0 and press Return to continue ... > could not write log tape. > Please mount tape 1 on /dev/rmt/0 and press Return to continue ... > > $ onstat -> > IBM Informix Dynamic Server Version 10.00.FC5W5 -- On-Line (Prim) -- Up48 > days 17:54:17 -- 6069248 Kbytes > Blocked:LAST_LOG_RESERVED4BACKUP > > I hope can help me.... THANKS > > bye > > _________________________________________________________________ > MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.