Okay, a few things here... First the index issue. When UniVerse creates an index on a file, it puts the absolute pathname to the index into the file header. You will need to remove this using the SET.INDEX command thus:
SET.INDEX filename TO NULL Next, the file size: The D_ZIP is the dictionary file. If you haven't fnuxi'd this, the modulus in the file header will be in the wrong byte order, so the reported modulus (16777216) is garbage. You will need to fnuxi D_ZIP as well. Incidentally - Download the free daily admin guide from the U2UG website (under the Learner Pack) for more details: here is a top level view - The modulus is one of the two components of sizing a file, and refers to the number of groups (pages) in the file. As it says, in personal edition there is a limit to this value. This number is independent of the actual data stored since a) it is the space reserved, so part may be empty, and b) you can make the size of each group (page) - also known as the separation - larger to store the data, it just makes the file less performant (and affects things like locking). To change the modulus and separation, look at the RESIZE command (HELP RESIZE). Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: 01 February 2010 4:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Resize Question I'd like to preface this by saying I am a UniVerse newbie. Ideally, I am trying to import some data into a personal edition UniVerse database but I am having some trouble. One example is a ZIP code lookup called ZIP. First, I copied the files in from a UNIX system to a Windows install of Personal Edition. Not ideal but not sure if it's a deal-breaker as yet so I'm moving on... Then, I did fnuxi VOC and fnuxi ZIP. VOC was fine but on ZIP I got a warning the secondary indices are defined in a unix location and if necessary, use SET.INDEX to update file header to correct locations. I am not sure how to use SET.INDEX so I have not done anything with that. Now I go to UniVerse and get "Your VOC is out of date. Update to current release (Y/N)? If I select Yes, I get an error about &TEMP& being in my VOC file but unable to create it. I believe this is because I do not have all the data copied over from the live UniVerse server, so I select No and get "Unable to open the operating system file "OC.O/LOGON.TESTER" where TESTER is the account name logging on. That gives me a prompt so I can do ANALYZE.FILE ZIP and I see the file type is 18, modulo is 4507 and separation is 1. There are 44,098 records. Then I try a "SELECT ST FROM ZIP" to get the states and I get an error saying "File "D_ZIP" has modulo 16777216 which is > 10007. Please resize it to modulo <= 10007 in order to use it in Personal Edition." I have tried running RESIZE of various file types, modulo, and separation, but I still get the error on D_ZIP every time. I have no idea how to get D_ZIP down to <= 10007 or if it is even possible, or if the records being 44k+ means I cannot view it in personal edition or what exactly is going 44k+ on with this. Can anyone help me past this or tell me why I can't get past it? Thanks for any tips for a newbie, Andrew _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2660 - Release Date: 01/31/10 19:35:00 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
