RE: UNCLASSIFIED RE: UV - Database backup
Maybe try 'uv -admin -help' At 03:54 PM 03/08/2004, you wrote: Afraid not, Glenn - E:\IBM\UV\bin>uv -admin E:\IBM\UV\bin> - Nothing at all, I'm afraid :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, 9 March 2004 9:45 a.m. To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: UV - Database backup I believe (since I wrote all that stuff) that issuing "uv -admin" will display all your available options. Since that original version, I've added additional (DataStage engine only) options for displaying things like engine status, active users, etc, as well as allowing you to start and stop multiple versions (yes, more than one can run on a system now), allowing you to enable/disable autostartup at system boot, changing administer name, etc At 03:37 PM 03/08/2004, you wrote: >Tim > >-Original Message- >Are there any other really useful "uv -admin ..." subcommands like "-L" >and "-U" that you can share with us? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: UV - Database backup
As I'm sure Glenn knows (hopefully, since he wrote all that stuff :-), the "uv -admin ..." options are a Unix only construct. Dave At 09:54 AM 3/9/2004 +1300, you wrote: Afraid not, Glenn - E:\IBM\UV\bin>uv -admin E:\IBM\UV\bin> - Nothing at all, I'm afraid :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, 9 March 2004 9:45 a.m. To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: UV - Database backup I believe (since I wrote all that stuff) that issuing "uv -admin" will display all your available options. Since that original version, I've added additional (DataStage engine only) options for displaying things like engine status, active users, etc, as well as allowing you to start and stop multiple versions (yes, more than one can run on a system now), allowing you to enable/disable autostartup at system boot, changing administer name, etc At 03:37 PM 03/08/2004, you wrote: >Tim > >-Original Message- >Are there any other really useful "uv -admin ..." subcommands like "-L" >and "-U" that you can share with us? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users David T. Meeks || "All my life I'm taken by surprise Architect, Technology Office || I'm someone's waste of time Ascential Software || Now I walk a balanced line [EMAIL PROTECTED] || and step into tomorrow" - IQ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: UV - Database backup
Works for me 8-)
> sudo /usr/opt/uv/bin/uv -admin
uv [ -admin option]
-c{learshm} clear BASIC catalog bit.
-start start uniVerse.
-stop shutdown uniVerse.
-L{ock} Suspend file I/O.
-R{eport} Current suspension status.
-U{nlock} Unsuspend file I/O.
> sudo /usr/opt/uv/bin/uv -version
UniVerse 10.0.8
>
Regards
David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273
+61 417 268 665
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of HENDERSON MICHAEL MR
Sent: Tuesday, 9 March 2004 7:25 AM
To: 'U2 Users Discussion List'
Subject: RE: UNCLASSIFIED RE: UV - Database backup
Afraid not, Glenn
-
E:\IBM\UV\bin>uv -admin
E:\IBM\UV\bin>
-
Nothing at all, I'm afraid
:-(
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
Behalf Of Glenn Herbert
Sent: Tuesday, 9 March 2004 9:45 a.m.
To: U2 Users Discussion List
Subject: Re: UNCLASSIFIED RE: UV - Database backup
I believe (since I wrote all that stuff) that issuing "uv -admin" will
display all your available options. Since that original version, I've
added
additional (DataStage engine only) options for displaying things like
engine
status, active users, etc, as well as allowing you to start and stop
multiple versions (yes, more than one can run on a system now), allowing
you
to enable/disable autostartup at system boot, changing administer name,
etc
At 03:37 PM 03/08/2004, you wrote:
>Tim
>
>-Original Message-
>Are there any other really useful "uv -admin ..." subcommands like "-L"
>and "-U" that you can share with us?
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence
Force.
If you are not the intended recipient you must not use, disclose, copy
or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: UV - Database backup
Afraid not, Glenn - E:\IBM\UV\bin>uv -admin E:\IBM\UV\bin> - Nothing at all, I'm afraid :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, 9 March 2004 9:45 a.m. To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: UV - Database backup I believe (since I wrote all that stuff) that issuing "uv -admin" will display all your available options. Since that original version, I've added additional (DataStage engine only) options for displaying things like engine status, active users, etc, as well as allowing you to start and stop multiple versions (yes, more than one can run on a system now), allowing you to enable/disable autostartup at system boot, changing administer name, etc At 03:37 PM 03/08/2004, you wrote: >Tim > >-Original Message- >Are there any other really useful "uv -admin ..." subcommands like "-L" >and "-U" that you can share with us? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UNCLASSIFIED RE: UV - Database backup
I believe (since I wrote all that stuff) that issuing "uv -admin" will display all your available options. Since that original version, I've added additional (DataStage engine only) options for displaying things like engine status, active users, etc, as well as allowing you to start and stop multiple versions (yes, more than one can run on a system now), allowing you to enable/disable autostartup at system boot, changing administer name, etc At 03:37 PM 03/08/2004, you wrote: Tim -Original Message- Are there any other really useful "uv -admin ..." subcommands like "-L" and "-U" that you can share with us? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: UV - Database backup
Tim -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder > Sent: Tuesday, 9 March 2004 6:58 a.m. > To: U2 Users Discussion List > Subject: Re: UV - Database backup [snip] > If you're doing it from the O/S level, you may want to use the > uv -admin -L option, which performs the same thing as > SUSPEND.FILES ON. uv -admin -U will turn it off. Where are these commands documented? The 10.0.15 Admin.pdf manual mentions only "uv -admin -start", "uv -admin -stop", and "uv -admin -c" Are there any other really useful "uv -admin ..." subcommands like "-L" and "-U" that you can share with us? Thanks Mike > > This is a fairly common practice. I'm not aware of any gotchas. > > Tim Snyder > IBM Data Management Solutions > Consulting I/T Specialist , U2 Professional Services > > [EMAIL PROTECTED] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - Database backup
You may not have SUSPEND.FILES as the following link indicates this feature was added on the 9.5C release: http://www.indexinfocus.com/dl/u2list/200211/40606.html I wouldn't be surprised if SUSPEND.FILES didn't make it into the User Ref documentation until 9.6, or later. You might check the UV account VOC file for an item called SUSPEND.FILES... if you have this item, then I would think the SUSPEND.FILES command is available for you to use. Tom Firl Columbia Ultimate > -Original Message- > From: Robert Porter [mailto:[EMAIL PROTECTED] > Sent: Monday, March 08, 2004 10:41 AM > To: [EMAIL PROTECTED] > Subject: Re: UV - Database backup > > > I just searched the admin guide, and the user reference, and > "SUSPEND.FILES" wasn't found in either of them. Could this > be version related? > > Tried it in the development account, and got this: > :SUSPEND.FILES > > Verb "SUSPEND.FILES" is not in your VOC. > > Robert > > >>> [EMAIL PROTECTED] 03/08/04 11:58AM >>> > > SUSPEND.FILES is documented in the UniVerse User Reference manual (and > briefly in the admin manual). The commands are SUSPEND.FILES ON and > SUSPEND.FILES OFF. If you're doing it from the O/S level, > you may want toQ > use the uv -admin -L option, which performs the same thing as > SUSPEND.FILES > ON. uv -admin -U will turn it off. > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - Database backup
fyi - SUSPEND.FILES doesn't exist in user accounts... only UV account. -Original Message- From: Robert Porter [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 1:41 PM To: [EMAIL PROTECTED] Subject: Re: UV - Database backup I just searched the admin guide, and the user reference, and "SUSPEND.FILES" wasn't found in either of them. Could this be version related? Tried it in the development account, and got this: :SUSPEND.FILES Verb "SUSPEND.FILES" is not in your VOC. Robert >>> [EMAIL PROTECTED] 03/08/04 11:58AM >>> SUSPEND.FILES is documented in the UniVerse User Reference manual (and briefly in the admin manual). The commands are SUSPEND.FILES ON and SUSPEND.FILES OFF. If you're doing it from the O/S level, you may want toQ use the uv -admin -L option, which performs the same thing as SUSPEND.FILES ON. uv -admin -U will turn it off. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - Database backup
I just searched the admin guide, and the user reference, and "SUSPEND.FILES" wasn't found in either of them. Could this be version related? Tried it in the development account, and got this: :SUSPEND.FILES Verb "SUSPEND.FILES" is not in your VOC. Robert >>> [EMAIL PROTECTED] 03/08/04 11:58AM >>> SUSPEND.FILES is documented in the UniVerse User Reference manual (and briefly in the admin manual). The commands are SUSPEND.FILES ON and SUSPEND.FILES OFF. If you're doing it from the O/S level, you may want toQ use the uv -admin -L option, which performs the same thing as SUSPEND.FILES ON. uv -admin -U will turn it off. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - Database backup
Robert Porter wrote on 03/08/2004 12:35:29 PM: > What effect would this be to the users? Also I don't see a SUSPEND. > FILES in the online HELP, or the Administering guide. There is a > SUSPEND.RECOVERY command though. > > So if we were to implement this, would it be like this? > > 1) SUSPEND.FILES > 2) Snapshot the filesystem (then would I have a filesystem snapshot > with no pending UV writes?) > 3) (command to un-SUSPEND.FILES) > 4) Run the backup > 5) Undo the snapshot > > Any potential "gotchas" with doing this? For the duration of the suspension, processes attempting to perform database writes will appear to hang until the suspension is removed. If you follow the procedures you've outlined, this will last for the duration of the snapshot - fairly minimal on most systems. The result will be, as you suspect, a quiescent copy of the database, with no worries about catching groups in mid-update. SUSPEND.FILES is documented in the UniVerse User Reference manual (and briefly in the admin manual). The commands are SUSPEND.FILES ON and SUSPEND.FILES OFF. If you're doing it from the O/S level, you may want to use the uv -admin -L option, which performs the same thing as SUSPEND.FILES ON. uv -admin -U will turn it off. This is a fairly common practice. I'm not aware of any gotchas. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - Database backup
What effect would this be to the users? Also I don't see a SUSPEND.FILES in the online HELP, or the Administering guide. There is a SUSPEND.RECOVERY command though. So if we were to implement this, would it be like this? 1) SUSPEND.FILES 2) Snapshot the filesystem (then would I have a filesystem snapshot with no pending UV writes?) 3) (command to un-SUSPEND.FILES) 4) Run the backup 5) Undo the snapshot Any potential "gotchas" with doing this? Thanks, Robert >>> [EMAIL PROTECTED] 03/08/04 10:34AM >>> Robert Porter wrote on 03/08/2004 10:59:43 AM: > Since we're talking about a journalled filesystem, when the snapshot > completes the filesystem is in a consistent state. That's not to say > that UV couldn't be caching something itself that's not on disk. If you use SUSPEND.FILES or uv -admin -L before creating your quiescent copy, you can ensure that there's nothing "in motion" at the UniVerse level. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - Database backup
Robert Porter wrote on 03/08/2004 10:59:43 AM: > Since we're talking about a journalled filesystem, when the snapshot > completes the filesystem is in a consistent state. That's not to say > that UV couldn't be caching something itself that's not on disk. If you use SUSPEND.FILES or uv -admin -L before creating your quiescent copy, you can ensure that there's nothing "in motion" at the UniVerse level. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - Database backup
We don't come down for backups... We're 24/7 - the docs tend to want their lab results in a timely manner. We come down once a month for PM and that can be (and has been) rescheduled because of medical reasons, such as a transplant. We're usually down under 2 hours per month. We run HP-UX 11.0, and UV 9.5. We used to use Logical Volume Manager (LVM) and MirrorDisk/UX to handle the drives. To run a backup we'd split the mirrors, backup the stale part and re-merge them. There were drawbacks to this method though. Either you had to have 3 mirror parts, or be running on a single part when split, and the re-merging of the mirrors took a few minutes. We did NOT have to have everyone off the system for the splits or the merges. When we moved to HP-UX 11.0, we also purchased OnlineJFS. This is a Veritas product HP sells. With it I can make drive changes on-the-fly both - both increases and decreases provided contiguous free space exists to reduce it. It also has the ability to analyze and defrag a filesystem online. But the really nice feature is taking a 'snapshot' of a filesystem. When you snapshot you get another virtual filesystem that has an image of how the filesystem looks at that moment. All writes to the filesystem actually go to the snapshots logical volume. Since only the writes go to the snapshot, it's volume only needs to be large enough to hold the writes themselves. The app can read and write as normal to it's regular volumes never knowing the difference. Vxfs and OnlineJFS handle it without the app knowing. When you undo a snapshot, the stored writes get written to the real volume to "catch up". Again this happens transparently to the application. We still use MirrorDisk/UX but now we never split the mirrors. Since we're talking about a journalled filesystem, when the snapshot completes the filesystem is in a consistent state. That's not to say that UV couldn't be caching something itself that's not on disk. For us that's a smaller issue than taking the system down to do backups, something we haven't done in the 9 years I've been here. We run 3 production-only backups and a full system (plus Novell and NT/SQL) backups every day. I've got 28 backups from the past week, plus every Sunday system backup of the last month, and every monthly backup from the past year should I need to restore. To handle the backups themselves, we're using HP Data Protector (formerly known as OmniBack) though licensing can be a little high depending on backup devices, and what you're backing up. To handle the snapshots at backup, I write shell scripts that does it and put them into the pre-exec and post-exec of the jobs. DP knows via return code from the scripts whether something went wrong and logs it appropriately. Robert >>> [EMAIL PROTECTED] 03/08/04 06:41AM >>> I doubt there is a method that will allow backup a UV database without stopping it and getting everybody off the system. If you have a mirrored system you could split the mirrors, backup the mirror and then remerge the mirrors but you would need to get everybody off the system for the split. My 2 cents? Louis - Original Message - From: "Armon Group" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 08, 2004 8:19 PM Subject: UV - Database backup : etc : : _ : It's fast, it's easy and it's free. Get MSN Messenger today! : http://www.msn.co.uk/messenger : : -- : u2-users mailing list : [EMAIL PROTECTED] : http://www.oliver.com/mailman/listinfo/u2-users : -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - Database backup
Firstly - do not tar a running uv system! This is because: A) you will get physical errors if writes are in progress. B) you will get logical errors if transactions are in progress. C) if you use dynamic files, the headers will not be updated. D) 'nuff said uvbackup should be aware of the write context so as to prevent the problems associated with A and C, but not B unless you use transactions. The only safe way to backup the database is if it is either stopped or quiescent. AFAIR you can pause the database using SUSPEND.FILES if you need to run a backup without taking the system down, but make sure any users are aware that the database is stopped and that any application transactions have completed before issuing it. You can the uvbackup to disk (for speed), dump that backup to device and use transaction logging until the next backup. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Armon Group > Sent: 08 March 2004 12:20 > To: [EMAIL PROTECTED] > Subject: UV - Database backup > > > What are the suggested means of backing up a UV system > without taking it down ?? > > Is there a document anywhere with the benifits / drawbacks of > the following methods (or any other methods) > > uvbackup > T.DUMP > tar > mirror disk system + tar > > etc > > _ > It's fast, it's easy and it's free. Get MSN Messenger today! > http://www.msn.co.uk/messenger > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > > __ > __ > This email was checked by MessageLabs SkyScan before entering > Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - Database backup
Given your stated requirements, the ONLY safe way for you is uvbackup. This runs within the database, and as such will not have trouble (much) with people accessing files. Any os-level backup will hiccup on files the db may have open. Running UV/NT, for us the problem is so severe that we always reboot the server after backing up (there are ways round the problems we've hit, but a reboot is simple, practical and works ...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Armon Group Sent: 08 March 2004 12:20 To: [EMAIL PROTECTED] Subject: UV - Database backup What are the suggested means of backing up a UV system without taking it down ?? Is there a document anywhere with the benifits / drawbacks of the following methods (or any other methods) uvbackup T.DUMP tar mirror disk system + tar etc _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - Database backup
I doubt there is a method that will allow backup a UV database without stopping it and getting everybody off the system. If you have a mirrored system you could split the mirrors, backup the mirror and then remerge the mirrors but you would need to get everybody off the system for the split. My 2 cents? Louis - Original Message - From: "Armon Group" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 08, 2004 8:19 PM Subject: UV - Database backup : : What are the suggested means of backing up a UV system without taking it : down ?? : : Is there a document anywhere with the benifits / drawbacks of the following : methods (or any other methods) : : uvbackup : T.DUMP : tar : mirror disk system + tar : : etc : : _ : It's fast, it's easy and it's free. Get MSN Messenger today! : http://www.msn.co.uk/messenger : : -- : u2-users mailing list : [EMAIL PROTECTED] : http://www.oliver.com/mailman/listinfo/u2-users : -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
