Re: [U2] Copied an account, now indexes messed up..
Hi Dennis, I have a working running account... And needed to create a write-off account, so I simply used cp -Rp xxx to copy the one account to the other... Now I have index problems A UV file that has indices stores the pathname of the index directory in the header of the file. If you copy the file using an operating system tool, this pointer still points back to the indices of the original file. This can cause all sorts of fun with updates to the copied file altering the indices of the original file. Take a look at the SET.INDEX command. This allows you to display the index pathname, to change it, or to remove it completely, effectively deleting the indices. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Copied an account, now indexes messed up..
SET.INDEX filename TO NULL On the copy. CREATE.INDEX filename INDEX etc on the copy will create copy. BUILD.INDEX filename ALL On copy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, 18 July 2008 9:00 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] Copied an account, now indexes messed up.. I have a working running account... And needed to create a write-off account, so I simply used cp -Rp xxx to copy the one account to the other... Now I have index problems I tried to search U2Ug knowledgebase but all it ever returns is No records found... I know that indexes have path names embedded, and that my copy is messing up the original account's indexes... The thing is I need both accounts to have indexes, and I can't remember how I separate them... And its urgent... Oops! --- 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] Copied an account, now indexes messed up..
Consider starting with UniAdmin... --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Copied an account, now indexes messed up..
Great point! I was thinking of doing that with my system. Is that pre 10.2 (we're at 10.1.8/hpux11)? Oh well, doesn't matter. I think we're moving to 10.2 on hp11.i in the next couple of weeks. BTW, someone shared a cool trick on this list at one time. COMO ON BLABLA SELECTF SET.INDEX INFORM COMO OFF This will show you all of the index paths for your current account. Then you can do a quick scan of the como for possible issues. One other thing... If you've got distributed files, you'll need to make sure you remember the REBUILD.DF. -- Original message -- From: Anthony Youngman [EMAIL PROTECTED] And if you've got to rebuild all the indices on the live server, you might want to look at recreating them. Not sure what the keyword is, but if you recreate them as relative indices, it will put the relative path in the file header and you won't have this problem again ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 18 July 2008 14:28 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Copied an account, now indexes messed up.. Thank you, thank you, thank you... Worked... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent: 18 July 2008 11:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Copied an account, now indexes messed up.. SET.INDEX filename TO NULL On the copy. CREATE.INDEX filename INDEX etc on the copy will create copy. BUILD.INDEX filename ALL On copy. --- 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/