OnBar and ISM

Currently I am running IDS 9.21.HC6 and using On-Archive for backups. I am in the process of upgrading to 9.40.HC7 and On-Archive no longer exists. I have been trying to use OnBar and ISM but having various problems which IBM have so far been unable to resolve. Would On-Tape be a better option for backups ? What do people out there generally use to backup Informix databases ? Sue

Sue, Onbar is very easy, but perhaps you are not getting the right experienced IBM assistance. If you can do on-archive, you can certainly use onbar. (I used to do onarchive). Does your company use something like netbackup or IBM tivoli for other backups such as systems and databases? Onbar will work in tandem with other vendor backup software (not just ISM). ISM is "legato lite" last I remember and maybe is not the best way to go? =20 But I have no ISM experience, only onbar & netbackup (from symantec).... Onbar is very cool. It is worth your while to hang in there and figure it out. What O/S are you on? Thanks, Norma Jean Sebastian . . . -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SUE SIMMONDS Sent: Wednesday, January 30, 2008 11:08 AM To: ids@iiug.org Subject: OnBar and ISM [11111] Currently I am running IDS 9.21.HC6 and using On-Archive for backups.=20 I am in the process of upgrading to 9.40.HC7 and On-Archive no longer exists.=20 I have been trying to use OnBar and ISM but having various problems which IBM=20 have so far been unable to resolve.=20 Would On-Tape be a better option for backups ?=20 What do people out there generally use to backup Informix databases ?=20 Sue=20 ************************************************************************ *******=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Hi Sue, We are running IDS 10.00.FC4 using onbar and ISM. We also experienced a number of problems with ISM in the beginning, but pretty much have worked through them and have been running successfully for about 8 months. ISM has very limited capability, but works for our current needs. Any specific issues? Mike

On 30/01/2008, SUE SIMMONDS <sues@hmgcc.gsi.gov.uk> wrote: > Currently I am running IDS 9.21.HC6 and using On-Archive for backups. > > I am in the process of upgrading to 9.40.HC7 and On-Archive no longer exists. > > I have been trying to use OnBar and ISM but having various problems which IBM > have so far been unable to resolve. > > Would On-Tape be a better option for backups ? > > What do people out there generally use to backup Informix databases ? > > Sue > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > Sue I've used ontape for years on a variety of platforms with no issues. Great if you can get your entire archive on one tape, but even tape swapping is (realitively) simple if you have a tape library and install expect. Ontape is a bit more limited in restoring, tends to be the entire instance, but you may be doing this any way depending on how many databases or spaces you have and how dependant on each other they are. Horses for courses and what skill/kit are available and what you want to achieve. Keep it simple then at 04:00 on a Monday morning when you simply must restore by 09:00 it will pay back in spades. Keith

When I run onbar -b -w to do a simple full system backup I get NetWorker: RPC error, Unable to send chunk NetWorker: Send Chunk to MMD failed, Broken pipe onbar.log shows (-43080) Process 2070 received signal 13. Process will exit after cleanup. XBSA Error: (BSAEndData) A system error occured. Aborting XBSA session. online.log has an assert failure 09:08:19 Level 0 Archive started on rootdbs, logdbs, defaultsbs, devwebdbs, devwebsbs, efacdbs, informdbs, knowledgedbs, knowledgesbs, limdbs, partsdbs, partssbs, personaldbs, productsdbs, projectsdbs, resourcedbs, securitydbs, taskfolddbs, taskfoldsbs1, taskfoldsbs2, taskfoldsbs3, taskfoldsbs4, whatifdbs 09:12:30 Archive on rootdbs, logdbs, defaultsbs, devwebdbs, devwebsbs, efacdbs, informdbs, knowledgedbs, knowledgesbs, limdbs, partsdbs, partssbs, personaldbs, productsdbs, projectsdbs, resourcedbs, securitydbs, taskfolddbs, taskfoldsbs1, taskfoldsbs2, taskfoldsbs3, taskfoldsbs4, whatifdbs ABORTED. 09:12:30 Aborted by client. 09:12:30 Assert Failed: Condition Failed (Ignoring free of pool 'arc_5' (0xc7eaf020) in use by blkpool), In (mt_shm_free_pool) 09:12:30 IBM Informix Dynamic Server Version 9.40.HC7 09:12:30 Who: Session(5, informix@hps03, 2070, c7716878) Thread(50, ontape, c76e7fec, 1) File: mtshpool.c Line: 3127 09:12:30 Action: Please notify IBM Informix Technical Support. 09:12:30 stack trace for pid 2026 written to /tmp/af.41a287e 09:12:32 See Also: /tmp/af.41a287e 09:13:00 Condition Failed (Ignoring free of pool 'arc_5' (0xc7eaf020) in use by blkpool), In (mt_shm_free_pool) 09:13:28 Checkpoint Completed: duration was 0 seconds. 09:13:28 Checkpoint loguniq 20495, logpos 0x3af018, timestamp: 0x264ae03c 09:13:28 Maximum server connections 0 and xbsa.messages shows _nwbsa_close_create_object_session: BSA_RC_ABORT_SYSTEM_ERROR System detected error due to savefile_fini() failure. Operation aborted. There is nothing else that I am aware of running on the server that could be interrupting the backup. I have IDS 9.40.HC7, ISM and On-Bar running successfully on another server. My UNIX administrator and I have checked all we can between the 2 servers but there must be something different that is causing the issues. Any ideas or suggestions would be gratefully received as IBM have not managed to identify the problem let alone resolve it !!!!!

I suggest that you set debugging in Networker as shown below and run the backup again. export NSR_DEBUG_FILE=/nsr/applogs/nmi.log export NSR_DEBUG_LEVEL=9 When the backup terminates check the logfile. Note that with NSR_DEBUG_LEVEL set to 9 causes NSR to be very verbose, thus the debug files grow very quickly. Check your Networker versions, and if possible move to Networker server version 7.4 and NMI version 3.00 though it does not support version IDS 11 yet :(. The error message "NetWorker: RPC error, Unable to send chunk" indicates that it communication between server and client was interrupted whilst processing a requested. Check that name resolution services are working correctly as Networker is a bit fussy about name resolution. Regards Kenneth Penza Systems Engineer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailpolicy.mitts.gov.mt P Please consider your environmental responsibility before printing this e-mail. END OF TEXT -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SUE SIMMONDS Sent: 05 February 2008 12:00 To: ids@iiug.org Subject: Re: OnBar and ISM [11158] When I run onbar -b -w to do a simple full system backup I get NetWorker: RPC error, Unable to send chunk NetWorker: Send Chunk to MMD failed, Broken pipe onbar.log shows (-43080) Process 2070 received signal 13. Process will exit after cleanup. XBSA Error: (BSAEndData) A system error occured. Aborting XBSA session. online.log has an assert failure 09:08:19 Level 0 Archive started on rootdbs, logdbs, defaultsbs, devwebdbs, devwebsbs, efacdbs, informdbs, knowledgedbs, knowledgesbs, limdbs, partsdbs, partssbs, personaldbs, productsdbs, projectsdbs, resourcedbs, securitydbs, taskfolddbs, taskfoldsbs1, taskfoldsbs2, taskfoldsbs3, taskfoldsbs4, whatifdbs 09:12:30 Archive on rootdbs, logdbs, defaultsbs, devwebdbs, devwebsbs, efacdbs, informdbs, knowledgedbs, knowledgesbs, limdbs, partsdbs, partssbs, personaldbs, productsdbs, projectsdbs, resourcedbs, securitydbs, taskfolddbs, taskfoldsbs1, taskfoldsbs2, taskfoldsbs3, taskfoldsbs4, whatifdbs ABORTED. 09:12:30 Aborted by client. 09:12:30 Assert Failed: Condition Failed (Ignoring free of pool 'arc_5' (0xc7eaf020) in use by blkpool), In (mt_shm_free_pool) 09:12:30 IBM Informix Dynamic Server Version 9.40.HC7 09:12:30 Who: Session(5, informix@hps03, 2070, c7716878) Thread(50, ontape, c76e7fec, 1) File: mtshpool.c Line: 3127 09:12:30 Action: Please notify IBM Informix Technical Support. 09:12:30 stack trace for pid 2026 written to /tmp/af.41a287e 09:12:32 See Also: /tmp/af.41a287e 09:13:00 Condition Failed (Ignoring free of pool 'arc_5' (0xc7eaf020) in use by blkpool), In (mt_shm_free_pool) 09:13:28 Checkpoint Completed: duration was 0 seconds. 09:13:28 Checkpoint loguniq 20495, logpos 0x3af018, timestamp: 0x264ae03c 09:13:28 Maximum server connections 0 and xbsa.messages shows _nwbsa_close_create_object_session: BSA_RC_ABORT_SYSTEM_ERROR System detected error due to savefile_fini() failure. Operation aborted. There is nothing else that I am aware of running on the server that could be interrupting the backup. I have IDS 9.40.HC7, ISM and On-Bar running successfully on another server. My UNIX administrator and I have checked all we can between the 2 servers but there must be something different that is causing the issues. Any ideas or suggestions would be gratefully received as IBM have not managed to identify the problem let alone resolve it !!!!! ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!