SUSPEND.FILES ON/OFF

Manu
----- Original Message ----- From: "Scott Richardson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, July 04, 2007 6:54 PM
Subject: Re: [U2] UD Backups - DBPAUSE for UniVerse?


I have followed this thread with much interest.

I have scoured the U2 / UniVerse documentation, but I see no
DBPAUSE command or equivilent for UniVerse. Are there any
commands with similar functionaility for UV, or does IBM have any
plans to introduce such command equilivents in UV as currently exist
in UD?

For any Backup solution that uses the Microsoft VSS Snapshot
functionality, or an "Advanced Open File Manager" option, would it be
safe to say that for UD applications, they should issue the DBPAUSE
command, "grab a snapshot", then DBRESUME - *for each Backup
requested*, to ensure optimal consistency of the Backup's integrity?

Would it also be safe to say that for UV Applications, the only sure
way to grab a consistent Backup of the UV environment would be
when the UV Database is shutdown, or in a state where there are no
users logged on and No PHANTOMs running?

It would be nice if UV had the same operational level commands
that UD has in this area.

I would appreciate any insight on this.

Happy Indepedence Day / "Fourth of July" to all.

Thank you.
Regards,
Scott Richardson
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Prime Information / UniVerse / Unidata / Sequoia PICK / mvBase
Pr1me Computer \ Encore Computer Corporation \ Sequoia Systems
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Senior Systems Engineer / Consultant
Product Support Engineer
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

----- Original Message ----- From: "Stephen O'Neal" <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2007 8:16 PM
Subject: RE: [U2] UD Backups


Colin Alfke asked:
"Along that line - would there be anything else that may be holding up
DBPAUSE?"

A cause of a slow response back from DBPAUSE is not enough disk drives
under a system. When DBPAUSE is initiated, it flushes all of the UDT disk
buffers to disk.  If there is a lot of data waiting to be written, it can
take a while.

Another cause, is when a single disk drive is hot.  Example: if a file,
that has a lot of updates, is on a single disk drive.  Optimally, files
with a lot of updates should be striped across multiple disk drives.
   Steve

   Stephen M. O'Neal
   U2 Lab Services Sales Specialist
   Information Management, IBM Software Group
-------
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to