Good work! Sounds like a good 'consumablity' issue to fix for guide_ndx, though seems like this situation would be rare, indeed.
Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 ..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 Israel, John R. Sent: Thursday, December 17, 2009 8:39 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command I believe I have the solution. 1) The field in question, ALT.BILL.TO, is not being used on our system. 2) It is indexed to speed up SELECT statements that came from the vendor (ex: SELECT filename WITH BILL.TO = X OR WITH SHIP.TO = X OR WITH ALT.BILL.TO = X). All three fields must be indexed to get the response we need. 3) the guide_ndx appears to not take into account an indexed field that contains no data. Granted, indexing a field that is not used sounds dumb, but the vendor wrote it to accommodate different customers with different needs. Just because we do not use it does not mean others don't. However, it needs to be indexed or else the selects (like above) will still wind up doing a full table scan. My test was to simply shove a value into a single record, save it, then re-run the guide_ndx. No problems reported in the guide_ndx! While this is not the RIGHT answer (fixing quide_ndx to correctly address this condition is), this is a simple solution. We just need to put a bogus value in 1 record in each of the two files. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, December 17, 2009 8:50 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command Odd. Guide_ndx uses almost the same logic as BUILD.INDEX - but does not lock the primary file and does not apply the TMP data to the index. What's different about this one file/index? BUILD.INDEX will handle TMP files > 2GB. Not sure about guide_ndx. How big did the TMP file get? I recommend opening a support case with your UniData support provider. Regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 ..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 Israel, John R. Sent: Thursday, December 17, 2009 6:35 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command Wally, Thanks for the help on the guide stuff. My co-worker ran the guide_ndx command on all of the indexed files. He is getting an error on one of the files that is confusing us. When looking at the GUIDE_XERROR.LIS file (the results of the guide_ndx command), it lists the data file followed by a test on each indexed field. We are getting an error that looks like: ---- . . . Checking index 'ALT.BILL.TO' logically... Error while opening /tmp/K02_08746 (No such file or directory). ---- He has done this both as himself and as superuser, so it is not a permissions issue. If he runs the guide_ndx command with one session, and uses a 2nd session to see what is in /tmp, he sees: K00_08746 K01_08746 Once the guide_ndx finishes, these files are apparently deleted by the guide_ndx command. He has deleted the index file (making sure the X_... file was also gone) and rebuilt it from scratch, but still gets the same type of error, this time being /tmp/K02_15518. Note that in both cases, it is failing on a file that starts with /tmp/K02... on a field called ALT.BILL.TO. None of the other files that he tested gave us a problem. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 _______________________________________________ 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