You have processes running in the middle of the night. So how do you tell they are not "in motion" ? You could just stop those processes..... right?
-----Original Message----- From: David Wolverton <dwolv...@flash.net> To: 'U2 Users List' <u2-users@listserver.u2ug.org> Sent: Thu, Aug 9, 2012 8:42 am Subject: Re: [U2] dbpause/dbresume or stopud/startud It's dependent on the software in use -- we have customers who want to use what they've always used as backup software, and many of the products they have been using will not back up 'open' files. So they end up skipping our primary datafile files!! Yikes!! I'm sure things will improve as the Windows Server versions keep marching forward -- just one of those things -- We have 'what we have seen work' and just suggest that when it happens. Many customers just do a 'stopud' at night to pull backups -- then startud when done -- all part of their backup script. Just too bad the dbpause does not have an option to 'release open files' . I think the problem is the backup software sees any 'open file' as a potential 'in motion' and does not bother with it since there is no way it can be 'consistent'. 'dbpause' handles this 'logically' but Windows still sees and reports the file as 'open'. Again, not a huge deal - just always keeping the ear to the ground if it gets 'better'. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, August 09, 2012 10:06 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud David: I'm sure I don't have a complete understanding of your situation. I use "dbpause" all the time and run backups using Windows backup utilities. I don't think they have a problem backing up locked files because of the volume Shadow Copy functionality built into Windows (of course the service needs to be running). Our backups have been running on a number of machines over the last seven or eight years. Am I missing something? Bill ------------------------------------------------------------------------ ----- Original Message ----- *From:* dwolv...@flash.net *To:* 'U2 Users List' <u2-users@listserver.u2ug.org> *Date:* 8/9/2012 6:35 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud > Has the issue on Windows been resolved? Our customers reported that > UniData maintained 'open files' at a dbpause, which still made the > backup difficult with a dbpause. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally > Terhune > Sent: Wednesday, August 08, 2012 5:27 PM > To: U2 Users List > Subject: Re: [U2] dbpause/dbresume or stopud/startud > > RFS with TP has been available in UniData for 15-20 years too. > I understand your issues. I'm just saying you do have the ability in > UniData to generate a consistent backup (physical and logical) using dbpause. > > Wally Terhune > Technical Support Engineer > Rocket Software > 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA > t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: > rocketsoftware.com/u2 > > > > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson > Sent: Wednesday, August 08, 2012 3:53 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] dbpause/dbresume or stopud/startud > > > That's the rub isn't it? > > We have a few thousand programs written over 30 years, and only a > limited staff, and users always want more. > Users don't see the need to go back and *fix* code that's working, > and/or are not willing to pay you to do it. > > It's a cost-benefit issue. For a site that doesn't *have* to be 24-7 > but can be say 22-7, it's safer to shutdown, then backup. > You can't always control every piece of code someone has written. > > > > -----Original Message----- > From: Wally Terhune <wterh...@rocketsoftware.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > Sent: Wed, Aug 8, 2012 2:18 pm > Subject: Re: [U2] dbpause/dbresume or stopud/startud > > > If you have put transaction processing semantics in your code you will > have logical consistency with dbpause. For RFS enabled systems, > dbpause forces a checkpoint. > > Wally Terhune > Technical Support Engineer > Rocket Software > 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA > t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: > rocketsoftware.com/u2 > > > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > On Behalf Of Wjhonson > Sent: Wednesday, August 08, 2012 10:08 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] dbpause/dbresume or stopud/startud > > > You get an extra benefit from stopud and startud in that your database > will be consistent. > dbpause does not enforce consistency > > Personally I would never suggest using dbpause to take a snapshot > because of that issue. > You're never guarenteed that you have a clean consistent copy. > > > -----Original Message----- > From: John Jenkins <u2g...@btinternet.com> > To: 'U2 Users List' <u2-users@listserver.u2ug.org> > Sent: Wed, Aug 8, 2012 6:02 am > Subject: Re: [U2] dbpause/dbresume or stopud/startud > > > "dbpause" and "dbresume" allow any background processes (e.g. PHANTOM > or WebDE > (Redback)) to continue running. You do not have to have a restart procedure. > Additionally, as long as your backup methodology is brief - a SAN > "snap" or a mirrored drive split - then anyone using Telnet, > UniObjects or ODBC not even > > notice and can continue uninterrupted. Stopping UniData menas > terminating those sessions > > I'd look at what is blocking your dbpause - there is a Tech Tip in the > U2 > knowledgebase.- search on "dbpause" - you should find SFMA-13082. > > Regards > > JayJay > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > thomas.bo...@firstgroup.com > Sent: 26 July 2012 10:34 > To: u2-users@listserver.u2ug.org > Subject: [U2] dbpause/dbresume or stopud/startud > Importance: High > > U2users, > > Will I get the same benefits by using stopud and startud as oppose to > dbpause and dbresume? The reason for my question is that my server is > running unidata > 7.2 but 50% of the time cannot resume and stays in dbpause state long > after backup? > > Regards, > > Thomas Boadu | IS Systems Manager > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
