[U2] Unidata can't build index
Can anyone shed light on this (other than the obivous) - I'm unclear about why this is occurring: :BUILD.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID Can not lock index file No indices are built This is a new file so I originally thought perhaps OS permissions where incorrect, but after checking I verified the permissions on the index file are 770. I don't have anything writing to this file so I'm not clear why it can't get a lock on the index file. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata can't build index
Jeff, did you do a CREATE.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID first? Susan Lynch F.W. Davison Company, Inc. - Original Message - From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: 01/28/2011 1:32 PM Subject: [U2] Unidata can't build index Can anyone shed light on this (other than the obivous) - I'm unclear about why this is occurring: :BUILD.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID Can not lock index file No indices are built This is a new file so I originally thought perhaps OS permissions where incorrect, but after checking I verified the permissions on the index file are 770. I don't have anything writing to this file so I'm not clear why it can't get a lock on the index file. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ 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] Unidata can't build index
On 01/28/11 14:11, Susan Lynch wrote: Jeff, did you do a CREATE.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID first? Yes, LIST.INDEX properly displayed all the indices including XPL.PERSON.ID which was new (but not built). -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata can't build index
BUILD.INDEX has to be able to get exclusive access to the primary file to start. It then blocks updates to the primary file (reads allowed) until it is finished. This is the long-time default behavior. Of course, you can use BUILD.INDEX ... ONLINE to avoid that requirement. This is a bit slower, but you can do it. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Friday, January 28, 2011 12:12 PM To: Susan Lynch Cc: U2 Users List Subject: Re: [U2] Unidata can't build index On 01/28/11 14:11, Susan Lynch wrote: Jeff, did you do a CREATE.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID first? Yes, LIST.INDEX properly displayed all the indices including XPL.PERSON.ID which was new (but not built). -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ 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