Re: [U2] [UV] RESIZE INPLACE
So, Perry, did you do it? Chuck On 4/25/2013 3:09 PM, Perry Taylor wrote: 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.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
I had contact with U2 Support who confirmed that the INPLACE option was not stable at our release (10.3.9) so I steered clear. I actually had the luxury of being able to create a new file and copying records so that is what I ended up doing. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, May 06, 2013 7:25 AM To: U2 Users List Subject: Re: [U2] [UV] RESIZE INPLACE So, Perry, did you do it? Chuck On 4/25/2013 3:09 PM, Perry Taylor wrote: 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.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
So you remain on the ice flow with the rest of us little penguins waiting for someone else to see if the water is safe from hungry lurking seals. We'll keep watching for someone else's blood in the water. Glad you're alive. Still, 144GB! That coulda been a good show . . . Thanks, Chuck On 5/6/2013 9:50 AM, Perry Taylor wrote: I had contact with U2 Support who confirmed that the INPLACE option was not stable at our release (10.3.9) so I steered clear. I actually had the luxury of being able to create a new file and copying records so that is what I ended up doing. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, May 06, 2013 7:25 AM To: U2 Users List Subject: Re: [U2] [UV] RESIZE INPLACE So, Perry, did you do it? Chuck On 4/25/2013 3:09 PM, Perry Taylor wrote: 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.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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 : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] 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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] 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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
Thats cool - Original Message - From: Manu Fernandes e...@infodata.lu To: U2 Users List u2-users@listserver.u2ug.org Sent: Sunday, April 28, 2013 2:45 AM 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 : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] 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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
Nothing like jumping into the deep end, eh, Perry? 144GB. More by the time this thread is finished. If RESIZE INPLACE fails, what is the typical kind of failure to expect? What's the worst that can happen? What has happened to others? If you do this, please let us know the result, good or bad, including the activity level on that file while the resize was happening. It's all very interesting, but as dearly as I love you all at ZirMed, I am happy to watch from a distance. This is my typical approach for resizing big files. It avoids the RESIZE command requires some, but little, downtime. I am certain Perry knows all this, but there are always new people listening in. It requires being able to identify which records have been updated recently, (e.g. indexes). That may mean a little planning ahead, anticipating future needs, such as resizes. 1. Create a new empty file the proper size and copy the entire old file into the new. 2. Create a list of all records updated since the copy began. 3. Recopy those.Repeat 23 as needed. 4. Shut off all other access to the file. (No one has it open, can open it.) 5. Create a list of all records update since last iteration of #2-3. 6. Recopy those. 7. Set.index to null on the original file -- dont forget to do this! 8. Rename to original file 9. Rename to new file to be live file 10. Set.index on the new live file. attach original indexes to new file. 11. Let users at the file. Warm regards, Chuck On 4/25/2013 3:09 PM, Perry Taylor wrote: 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.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
make a backup first - Original Message - From: Perry Taylor perry.tay...@zirmed.com To: U2-Users List u2-users@listserver.u2ug.org Sent: Thursday, April 25, 2013 2:09 PM Subject: [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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
Check with support. IF it works, it is a very recent fix. Personally, that size file I would rename then create a file with the correct size then copy all the data over and use the overwrite option. (overwrite will reduce the IO because it doesn't have to check if the record exists). Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, April 25, 2013 4:10 PM To: U2-Users List Subject: [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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
make a backup first Comforting! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Thursday, April 25, 2013 2:37 PM To: U2 Users List Subject: Re: [U2] [UV] RESIZE INPLACE make a backup first - Original Message - From: Perry Taylor perry.tay...@zirmed.com To: U2-Users List u2-users@listserver.u2ug.org Sent: Thursday, April 25, 2013 2:09 PM Subject: [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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
This stems from past experience when someone just decided to resize and comes to me later asking for last nights backup, and the file got hosed. I backup every night but spot backups take minutes as apposed to re-entering all the days data after restoring last nights backup. When some one suggests something possibly scary, the first thing that comes to mind is a simple copy or backup. I run guide on each of the four live databases on the weekend when my programmer feels it's getting sluggish or strange errors in data show up. That tells me the files I should be looking at, hit lists. If it's scary, I make a copy of the account to a pilot and test the filesizing first. If it's good I hit the live account. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Femcare-Nikomed Ltd. rfrai...@utahmed.com 801-569-4016 - Original Message - From: Perry Taylor perry.tay...@zirmed.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, April 25, 2013 3:16 PM Subject: Re: [U2] [UV] RESIZE INPLACE make a backup first Comforting! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Thursday, April 25, 2013 2:37 PM To: U2 Users List Subject: Re: [U2] [UV] RESIZE INPLACE make a backup first - Original Message - From: Perry Taylor perry.tay...@zirmed.com To: U2-Users List u2-users@listserver.u2ug.org Sent: Thursday, April 25, 2013 2:09 PM Subject: [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.comhttp://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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users