RESIZE filename * * * CONCURRENT USING tempdirpath will be fine even if the dynamic hashed file is open in COMMON. Make sure that the combination tempdirpath/filename is less than 128 characters long.
"They" have put a deal of work into making CONCURRENT safe over the years. Any bad press you read is probably old. It's still true that you should avoid INPLACE at all costs, especially for dynamic files! > ----- Original Message ----- > From: "John Kent" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] static/dynamic file(s) opinions wanted! > Date: Wed, 23 Jul 2008 09:48:50 +1000 > > > Ray, > is there any problem to doing this while people are logged in > and might write to the file > > Assuming the file is not in common > > jak > ----- Original Message ----- From: "Ray Wurlod" <[EMAIL PROTECTED]> > To: <u2-users@listserver.u2ug.org> > Sent: Wednesday, July 23, 2008 9:09 AM > Subject: RE: [U2] static/dynamic file(s) opinions wanted! > > > > Occasionally RESIZE filename * * * is a good thing to do with > > dynamic files. This re-packs each group, consolidating > > fragmented free space (from deleted/reduced records) in (at the > > end of) each group buffer. It may, if you're lucky, also bring > > some groups out of overflow. > > > > Dynamic files do not, of themselves, re-pack groups in normal > > operation unless by doing so they would avoid extending the group > > into overflow. > > > >> ----- Original Message ----- > >> From: "Doug Chanco" <[EMAIL PROTECTED]> > >> To: u2-users@listserver.u2ug.org > >> Subject: RE: [U2] static/dynamic file(s) opinions wanted! > >> Date: Tue, 22 Jul 2008 18:25:50 -0400 > >> > >> > >> Thanks Kevin but I am still missing something, if dynamic files are well > >> "dynamic" why would one need to resize them and how would one know what to > >> resize them to? I am sorry if this is basic stuff but I come from a jBASE > >> world and have never really used dynamic files. > > ------- > > 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/
