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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
