Re: And the Winner is: [U2] [UV] checking files for corruption - Humor Here - plus Do this Every Month

2007-09-13 Thread iggchamp
Thanks SteveO to you and all of the entrants

-- Original message -- 
From: "Stephen O'Neal" <[EMAIL PROTECTED]> 

> Scott Thompson asked ..."> What is the best way to verify the integrity of 
> a file while users are accessing (if possible at all)?" 
> 
> Please note that Scott only asked for a single file... 
> 
> Runner Up: 
> Karl P 
> 
> was extremely close with "LIST FNAME LASTATTRIBUTE". If he would have 
> added DET.SUP, he would have been a Winner. This would have avoided the 
> output. 
> 
> Karl's entry would require you to press the ENTER key as the @ID and 
> LASTATTRIBUTE were displayed for every record. You would probably get 
> sick of this after a while and enter a "S" to suppress the output when the 
> PAK (Press Any Key to continue) prompt was requested. 
> 
> However, you would have to write a rather extensive PAragraph or PRoc to 
> include ALL of the files. 
> 
> And the Winner is: 
> Jerry Banker who stated: 
> 
> "You can try doing a uvbackup on the file to /dev/null. When the file is 
> backed up it checks the integrity of the file. 
> Jerry" 
> 
> uvbackup is the only utility that goes thru all of the files and reports 
> on its integrity. 
> 
> uvbackup can be run with users on the system. 
> 
> The question that was not asked... 
> Should I add the "uvbackup on the file to /dev/null" to my monthly 
> processes to verify the integrity of the database? 
> 
> Best business practices state that this should be included every month. 
> This is a more PC answer than "HELL YES, We're talkin' Job Security"! 
> 
> Nice Contest, 
> 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/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


And the Winner is: [U2] [UV] checking files for corruption - Humor Here - plus Do this Every Month

2007-09-12 Thread Stephen O'Neal
Scott Thompson asked ..."> What is the best way to verify the integrity of 
a file while users are accessing (if possible at all)?"

Please note that Scott only asked for a single file...

Runner Up:
Karl P

was extremely close with "LIST FNAME LASTATTRIBUTE".  If he would have 
added DET.SUP, he would have been a Winner.  This would have avoided the 
output.

Karl's entry would require you to press the ENTER key as the @ID and 
LASTATTRIBUTE were displayed for every record.  You would probably get 
sick of this after a while and enter a "S" to suppress the output when the 
PAK (Press Any Key to continue) prompt was requested. 

However, you would have to write a rather extensive PAragraph or PRoc to 
include ALL of the files.

And the Winner is:
Jerry Banker who stated:

"You can try doing a uvbackup on the file to /dev/null. When the file is 
backed up it checks the integrity of the file.
Jerry"
 
uvbackup is the only utility that goes thru all of the files and reports 
on its integrity.

uvbackup can be run with users on the system. 

The question that was not asked...
Should I add the "uvbackup on the file to /dev/null" to my monthly 
processes to verify the integrity of the database?

Best business practices state that this should be included every month. 
This is a more PC answer than "HELL YES, We're talkin' Job Security"!

Nice Contest,
   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/