We actually do this with many of our big active files. Many benefits to distributed files when it comes to maintenance :)
The file in question here is a deep archive file which will see little activity and, once it's sized properly, will *hopefully* never change again. Perry -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Manu Fernandes Sent: Sunday, April 28, 2013 2:46 AM To: U2 Users List Subject: Re: [U2] [UV] RESIZE INPLACE Hi, Given the risk of manipulating a file of this size, I recommend the use of distributed files (DEFINE.DF). Just as effective, if not better, each part file is administered individually (backups, resizing, indexing, !accessing, locking,...) Procedure : 1 - analyse the keys to build a distribution algorythm ; at worst use hashing algorythm ; don't forget a elsewhere partnumber (1 ) 2 - create part files (define how many, size, ..., by analysing number key-records, time growing ,...) 3 - define distributed file ; DICT adress the original DICT 4 - copy all record from orig.file to df.file (do it one time before live to check if all keys can be processed by your algorythm) 5 - edit VOC orig.file to adress df.file as data file 6 - resize all part file individually. 7 - delete the orig.DATA file &index from os ; to get back your 144gb My two pence manu > -----Message d'origine----- > De : [email protected] [mailto:u2-users- > [email protected]] De la part de Perry Taylor > Envoyé : jeudi 25 avril 2013 22:10 > À : U2-Users List > Objet : [U2] [UV] RESIZE INPLACE > > Before I go and resize a 144GB file has anyone had any experiences with the > INPLACE option of RESIZE in UniVerse? Good, bad, ugly??? > > Thanks. > Perry > > Perry Taylor > Senior MV Architect > ZirMed > 888 West Market Street, Suite 400 > Louisville, KY 40202 > www.zirmed.com<http://www.zirmed.com/> > > > > CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is > for the sole use of the intended recipient(s) and may contain confidential and > privileged information. Any unauthorized review, use, disclosure or > distribution > is prohibited. ZirMed, Inc. has strict policies regarding the content of > e-mail > communications, specifically Protected Health Information, any > communications containing such material will be returned to the originating > party with such advisement noted. If you are not the intended recipient, > please > contact the sender by reply e-mail and destroy all copies of the original > message. > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
