Re: And the Winner is: [U2] [UV] checking files for corruption -
Drat. I'm always coming in 2nd. Well, other than choosing a wife. I struck gold with that, just over 30 years ago. 8^} And, by the way, what does Jerry win? Karl > 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/ > -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: And the Winner is: [U2] [UV] checking files for corruption - Humor Here - plus Do this Every Month
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
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/
Re: [U2] [UV] checking files for corruption
I, too, am not sure how thorough it is, but I do a FILE.STAT (or ANALYZE.FILE). -- Regards, Clif On Sep 11, 2007, at 11:07 AM, Bob Woodward wrote: I'm not sure how through it is but I've always found that just doing a COUNT on a file has shown when there's a problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 11, 2007 8:20 AM To: u2-Users Subject: [U2] [UV] checking files for corruption Hi all, UV 10.1.8 What is the best way to verify the integrity of a file while users are accessing (if possible at all)? I see that fixtool will set an exclusive file lock when executing without any options. If I understand correctly, the -start and -stop options will scan the file setting group locks. Would it work to set -start to 1 and -stop to the last group in the file? If so, how do I tell what the last group of the file is? Thanks in advance, Scott Thompson --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] checking files for corruption
A count misses many types of possible corruption. If you select the file, then do LIST FNAME LASTATTRIBUTE that will give you a better, though still incomplete, appraisal of a file's integrity. Karl > I'm not sure how through it is but I've always found that just doing a > COUNT > on a file has shown when there's a problem. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, September 11, 2007 8:20 AM > To: u2-Users > Subject: [U2] [UV] checking files for corruption > > Hi all, > > UV 10.1.8 > > What is the best way to verify the integrity of a file while users are > accessing (if possible at all)? > > I see that fixtool will set an exclusive file lock when executing without > any options. If I understand correctly, the -start and -stop options will > scan the file setting group locks. Would it work to set -start to 1 and > -stop to the last group in the file? If so, how do I tell what the last > group of the file is? > > Thanks in advance, > > Scott Thompson > --- > 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/ > -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] checking files for corruption
I'm not sure how through it is but I've always found that just doing a COUNT on a file has shown when there's a problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 11, 2007 8:20 AM To: u2-Users Subject: [U2] [UV] checking files for corruption Hi all, UV 10.1.8 What is the best way to verify the integrity of a file while users are accessing (if possible at all)? I see that fixtool will set an exclusive file lock when executing without any options. If I understand correctly, the -start and -stop options will scan the file setting group locks. Would it work to set -start to 1 and -stop to the last group in the file? If so, how do I tell what the last group of the file is? Thanks in advance, Scott Thompson --- 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/
RE: [U2] [UV] checking files for corruption
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 11, 2007 10:20 AM To: u2-Users Subject: [U2] [UV] checking files for corruption Hi all, UV 10.1.8 What is the best way to verify the integrity of a file while users are accessing (if possible at all)? I see that fixtool will set an exclusive file lock when executing without any options. If I understand correctly, the -start and -stop options will scan the file setting group locks. Would it work to set -start to 1 and -stop to the last group in the file? If so, how do I tell what the last group of the file is? Thanks in advance, Scott Thompson --- 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/
[U2] [UV] checking files for corruption
Hi all, UV 10.1.8 What is the best way to verify the integrity of a file while users are accessing (if possible at all)? I see that fixtool will set an exclusive file lock when executing without any options. If I understand correctly, the -start and -stop options will scan the file setting group locks. Would it work to set -start to 1 and -stop to the last group in the file? If so, how do I tell what the last group of the file is? Thanks in advance, Scott Thompson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/