WELL... in theory UniData has SOME control -- I mean, on Windows, there could be a dbpause 'flag' that tells UniData to close all the open file handles on dbpause and reopen them on dbresume.
That would fix the issue! ;-) DW -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wally Terhune Sent: Thursday, August 09, 2012 9:38 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud Dbpause doesn't close files. It blocks updates by UniData processes to UniData files. This is via a flag in shared memory that all UniData processes access. We have no control as to how operating systems manage file system files. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: [email protected] **w: rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Wolverton Sent: Thursday, August 09, 2012 7:35 AM To: 'U2 Users List' 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: [email protected] [mailto:[email protected]] 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: [email protected] **w: rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 3:53 PM To: [email protected] 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 <[email protected]> To: U2 Users List <[email protected]> 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: [email protected] **w: rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wjhonson Sent: Wednesday, August 08, 2012 10:08 AM To: [email protected] 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 <[email protected]> To: 'U2 Users List' <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: 26 July 2012 10:34 To: [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
