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 ___ 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
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: 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 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: 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
Re: [U2] dbpause/dbresume or stopud/startud
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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: 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 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: 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?
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
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
Re: [U2] dbpause/dbresume or stopud/startud
Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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
Re: [U2] dbpause/dbresume or stopud/startud
You've restored from backups where files were locked during the backup? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 8:33 am 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
Re: [U2] dbpause/dbresume or stopud/startud
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
Re: [U2] dbpause/dbresume or stopud/startud
David: You raise a very interesting point; clients sometimes want to use whatever software they have to interface with your software. I have the same problem, especially with printers. All of our reports inject PCL (and PJL) into the print file to manage formatting. This means our output has two attributes not normally encountered; it needs to print directly to the printer and it can only use a PCL enabled printer. As an aside, a couple of days ago one of our clients purchased an expensive Sharp copier and when they tried to print a report it didn't print at all. It turned out the copier has a security module within it that popped open a security dialog to log the copies printed, but only worked if the print job went through the print driver. I had to inform them that wasn't a problem we could resolve as the entire process fails with direct printing. Thus, they had to turn off the security in order to use our printing. The same holds true of backup and anti-virus software; we don't support that software at all. They can't run anti-virus in the U2 data or software directories at all. They also can't use any backup software they want, especially because a number of them contain anti-virus capabilities within its functionality. So, to resolve this problem we've written a couple of Windows scripts that use Windows backup and creates a single Windows file for the U2 database. They can then use any backup software they want to backup this file. Another issue to keep in mind, Windows significantly changed the backup process between Windows 2003, Windows 2008, and Windows 2008 R2! ntbackup has been deprecated and replaced with wbadmin (in fact, in Windows 2008 R2 ntbackup isn't even loaded with the system). It's a completely different animal and not as flexible because, of course, they partially implemented something ntbackup didn't have (image backups), so they broke wbadmin and now we all have to do a different dance to get backups to work. :-( So, I guess I can say I do feel your pain! :-) Bill - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 8:14 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. [snipped] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dbpause/dbresume or stopud/startud
As far as I know, Windows doesn't care about UniData. If the Volume Shadow Copy service is running the backups cruise right through everything. Now, to answer the question of whether it works, we're not 24/7 and I wouldn't use this if we were. However, since our systems are basically unused for 3 - 4 hours every night, this is a viable solution that hasn't caused me any problems over the years. I don't really know what files were locked when the backups are performed, but I have restored quite a bit of data over the years and have had no problems. Again, we're not a 24/7 shop so this solution is the most viable and inexpensive for our purposes. If I could manage to work through a mirrored solution that would be simple and inexpensive I'd do that, but I don't have the time or resources to traverse that path. :-o This brings up another point; when stopud is run, all phantoms are killed, right? When startud runs how are these phantoms all started up again? Bill Untitled Page - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 8:29 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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
Re: [U2] dbpause/dbresume or stopud/startud
I would not envision having every active UniData process on the system close all of their files when a dbpause command is run. Each process has it's own file handles in its private memory. Processes not actively updating files would need to be signaled that dbpause is requested and then run through their file table and issue close commands at the OS level - then let the dbpause process know they are done. Also - a UniBasic process that issues a WRITE command and detects dbpause is active will just wait until dbresume. If the process were to close their files, it would have to 'jump out' of the WRITE, cycle thru closing all files, and then resume context of the WRITE statement. All of this seems overly intensive and possibly not easily architected. Just providing some background (and my bias). Regards, 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 David Wolverton Sent: Thursday, August 09, 2012 9:06 AM To: 'U2 Users List' Subject: Re: [U2] dbpause/dbresume or stopud/startud 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! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dbpause/dbresume or stopud/startud
Oh Geez -- I forgot all open files were managed in private memory! That moves it all the way to the 'never can happen' setup! Thanks Wally for the slap-up-side-of-the-head! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, August 09, 2012 11:28 AM To: U2 Users List Subject: Re: [U2] dbpause/dbresume or stopud/startud I would not envision having every active UniData process on the system close all of their files when a dbpause command is run. Each process has it's own file handles in its private memory. Processes not actively updating files would need to be signaled that dbpause is requested and then run through their file table and issue close commands at the OS level - then let the dbpause process know they are done. Also - a UniBasic process that issues a WRITE command and detects dbpause is active will just wait until dbresume. If the process were to close their files, it would have to 'jump out' of the WRITE, cycle thru closing all files, and then resume context of the WRITE statement. All of this seems overly intensive and possibly not easily architected. Just providing some background (and my bias). Regards, 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 David Wolverton Sent: Thursday, August 09, 2012 9:06 AM To: 'U2 Users List' Subject: Re: [U2] dbpause/dbresume or stopud/startud 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! ___ 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
Re: [U2] dbpause/dbresume or stopud/startud
Sure would be nice if VSS would cause a dbpause type thing to occur while snapshot is taking place... On Thu, Aug 9, 2012 at 11:29 AM, David Wolverton dwolv...@flash.net wrote: Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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:
Re: [U2] dbpause/dbresume or stopud/startud
You have to write a script that logs in as the phantom user, so that the jobs are launched inside U2. I really have no idea why IBM / Rocket didn't figure out a better way to solve this. See my past thread on the COLDSTART, a very useful command which went bye bye bye. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 9:33 am Subject: Re: [U2] dbpause/dbresume or stopud/startud As far as I know, Windows doesn't care about UniData. If the Volume Shadow Copy service is running the backups cruise right through everything. Now, to answer the question of whether it works, we're not 24/7 and I wouldn't use this if we were. However, since our systems are basically unused for 3 - 4 hours every night, this is a viable solution that hasn't caused me any problems over the years. I don't really know what files were locked when the backups are performed, but I have restored quite a bit of data over the years and have had no problems. Again, we're not a 24/7 shop so this solution is the most viable and inexpensive for our purposes. If I could manage to work through a mirrored solution that would be simple and inexpensive I'd do that, but I don't have the time or resources to traverse that path. :-o This brings up another point; when stopud is run, all phantoms are killed, right? When startud runs how are these phantoms all started up again? Bill Untitled Page - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 8:29 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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
Re: [U2] dbpause/dbresume or stopud/startud
I have no idea how that would be done. I use a U2 VB script to start services when Windows starts, but have no idea how to alert the dbms that it has started. :-( With a simple solution out there (it's been there for many years), I'm also amazed this simple issue hasn't been implemented. :-( Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 8/9/2012 9:40 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud You have to write a script that logs in as the phantom user, so that the jobs are launched inside U2. I really have no idea why IBM / Rocket didn't figure out a better way to solve this. See my past thread on the COLDSTART, a very useful command which went bye bye bye. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 9:33 am Subject: Re: [U2] dbpause/dbresume or stopud/startud As far as I know, Windows doesn't care about UniData. If the Volume Shadow Copy service is running the backups cruise right through everything. Now, to answer the question of whether it works, we're not 24/7 and I wouldn't use this if we were. However, since our systems are basically unused for 3 - 4 hours every night, this is a viable solution that hasn't caused me any problems over the years. I don't really know what files were locked when the backups are performed, but I have restored quite a bit of data over the years and have had no problems. Again, we're not a 24/7 shop so this solution is the most viable and inexpensive for our purposes. If I could manage to work through a mirrored solution that would be simple and inexpensive I'd do that, but I don't have the time or resources to traverse that path. :-o This brings up another point; when stopud is run, all phantoms are killed, right? When startud runs how are these phantoms all started up again? Bill Untitled Page - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 8:29 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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
Re: [U2] dbpause/dbresume or stopud/startud
If stopud just kills the Windows services (I don't know what it does), that will not kill the phantoms. Each pid runs as a seperate Windows process and is not signalled when the main services are stopped. You can manually kill any pid however. Maybe stopud does more than that. We can stop the four main processes and users who are logged in, stay logged in. No one new can log in however. Someone more familiar with stopud should comment on what that does. You don't have to *alert* U2 that it's started. What you do is execute a login as that user. In that users login script you put the phantoms you want to start. So when that user logs in, the phantoms start. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 3:37 pm Subject: Re: [U2] dbpause/dbresume or stopud/startud I have no idea how that would be done. I use a U2 VB script to start services when Windows starts, but have no idea how to alert the dbms that it has started. :-( With a simple solution out there (it's been there for many years), I'm also amazed this simple issue hasn't been implemented. :-( Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 8/9/2012 9:40 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud You have to write a script that logs in as the phantom user, so that the jobs are launched inside U2. I really have no idea why IBM / Rocket didn't figure out a better way to solve this. See my past thread on the COLDSTART, a very useful command which went bye bye bye. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 9:33 am Subject: Re: [U2] dbpause/dbresume or stopud/startud As far as I know, Windows doesn't care about UniData. If the Volume Shadow Copy service is running the backups cruise right through everything. Now, to answer the question of whether it works, we're not 24/7 and I wouldn't use this if we were. However, since our systems are basically unused for 3 - 4 hours every night, this is a viable solution that hasn't caused me any problems over the years. I don't really know what files were locked when the backups are performed, but I have restored quite a bit of data over the years and have had no problems. Again, we're not a 24/7 shop so this solution is the most viable and inexpensive for our purposes. If I could manage to work through a mirrored solution that would be simple and inexpensive I'd do that, but I don't have the time or resources to traverse that path. :-o This brings up another point; when stopud is run, all phantoms are killed, right? When startud runs how are these phantoms all started up again? Bill Untitled Page - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 8:29 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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)
Re: [U2] dbpause/dbresume or stopud/startud
I could be completely misunderstanding your comment ...execute a login as that user. How does one automatically execute a login when the U2 dbms service starts? Are you suggesting that I start the service under particular credentials and configure that user to have a login script (which then starts some U2 phantoms/processes)? What about the Allow service to interact with desktop checkbox available when a service starts with the local system account? Then, don't you have to mess with group policies and/or a netlogon share? What if the machine isn't part of a domain? As always, on this topic more questions are raised than were answered. :-) Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 8/9/2012 5:45 PM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud If stopud just kills the Windows services (I don't know what it does), that will not kill the phantoms. Each pid runs as a seperate Windows process and is not signalled when the main services are stopped. You can manually kill any pid however. Maybe stopud does more than that. We can stop the four main processes and users who are logged in, stay logged in. No one new can log in however. Someone more familiar with stopud should comment on what that does. You don't have to *alert* U2 that it's started. What you do is execute a login as that user. In that users login script you put the phantoms you want to start. So when that user logs in, the phantoms start. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 3:37 pm Subject: Re: [U2] dbpause/dbresume or stopud/startud I have no idea how that would be done. I use a U2 VB script to start services when Windows starts, but have no idea how to alert the dbms that it has started. :-( With a simple solution out there (it's been there for many years), I'm also amazed this simple issue hasn't been implemented. :-( Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 8/9/2012 9:40 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud You have to write a script that logs in as the phantom user, so that the jobs are launched inside U2. I really have no idea why IBM / Rocket didn't figure out a better way to solve this. See my past thread on the COLDSTART, a very useful command which went bye bye bye. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 9, 2012 9:33 am Subject: Re: [U2] dbpause/dbresume or stopud/startud As far as I know, Windows doesn't care about UniData. If the Volume Shadow Copy service is running the backups cruise right through everything. Now, to answer the question of whether it works, we're not 24/7 and I wouldn't use this if we were. However, since our systems are basically unused for 3 - 4 hours every night, this is a viable solution that hasn't caused me any problems over the years. I don't really know what files were locked when the backups are performed, but I have restored quite a bit of data over the years and have had no problems. Again, we're not a 24/7 shop so this solution is the most viable and inexpensive for our purposes. If I could manage to work through a mirrored solution that would be simple and inexpensive I'd do that, but I don't have the time or resources to traverse that path. :-o This brings up another point; when stopud is run, all phantoms are killed, right? When startud runs how are these phantoms all started up again? Bill Untitled Page - Original Message - *From:* dwolv...@flash.net *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 8/9/2012 8:29 AM *Subject:* Re: [U2] dbpause/dbresume or stopud/startud Hey -- this was a question I got though: Is there a way to make UniData VSS/Shadow-Copy 'aware'? Does that question come up to other people as they transition users to U2? -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