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:* [email protected]
*To:* [email protected]
*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 <[email protected]>
To: U2 Users List <[email protected]>
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:* [email protected]
*To:* 'U2 Users List' <[email protected]>
*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: [email protected]
[mailto:[email protected]] 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:* [email protected]
*To:* 'U2 Users List' <[email protected]>
*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: [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
