You have the 64 bit option available if you are greater than Universe version *9.5.1.1.C*
*RESIZE* Use RESIZE to reorganize a file with a new file type, modulo, and separation, or to change an existing nondynamic file to a dynamic file. You cannot use RESIZE to change the parameters of a dynamic file, or to resize an SQL table to a type 1, type 19, or type 25 file. *Syntax* *RESIZE *[ DICT] [ *filename*] [ *type*] [ *modulo*] [ *separation*][ CONCURRENT | INPLACE | USING *partition*] [ 64BIT | 32BIT] *RESIZE *[ DICT] [ *filename*] [ 30 | DYNAMIC] [ *parameter *[ *value*]] … [ USING *partition*] [ 64BIT | 32BIT] Not sure if that is readable... It took me some time to find this command documented when I was originally looking for it way back when... Also on Rocket's documentation its under the User Reference Guide, page 498 in the PDF file. I cut and pasted that from the 10.3 docs. I can't imagine that it has changed much since version 9. Whatever you do, if you do decide to resize it or perhaps turn it into a dynamic file or something of the like, then DO NOT cancel the resize. If you kill a resize process, the file will no longer be usable because it corrupts the file header. So if its a static hashed file and no one is accessing it, you can just simply do a unix/windows copy on it and make a backup. If its already a dynamic file, then use your backup utility on it before you start. Then you will have to use CONFIGURE.FILE to modify it, instead of RESIZE I believe. CONFIGURE.FILE is on page 146 of the 10.3 docs. I doubt this has changed all that much either. Just remember, once you start the resize there is no going back until you finish it. So make sure no one is going to use the file and NEVER CANCEL a RESIZE. On Fri, Jun 3, 2011 at 10:03 AM, George Gallen <ggal...@wyanokegroup.com>wrote: > Well, this process is still running....and it's up to just about 15M (1.3g) > so hopefully, it will be done very soon - I estimated this to take > about an hour or so, well, thats turning into almost 20 hours. > > I don't know if I have the 64bit option available, I could but something > tells me I don't - I'm on version 10.0.2 of UV > > But if it crashes the process because the file gets too big, I'll have to > pare down what gets written out - just less history, this is a file > that once it's created, it's exported and rarely used, so it's getting > the slow > part out of the way once, after that, it runs fast for updating. > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of John Thompson > > Sent: Friday, June 03, 2011 9:46 AM > > To: U2 Users List > > Subject: Re: [U2] File Item Count Limit? > > > > Also, If they are 64 bit files in Universe then they can grow quite > > large on > > the disk. > > > > You can have a file that probably takes up to 64 GB of disk space. > > Depending on the record size, etc... who knows how many records that > > could > > be. I don't have the formula's in front of me to figure that out. > > > > You can change whether a file is 32 or 64 bit in universe by using the > > RESIZE command. > > Its also a configurable paramater for newly created files in the > > uvconfig > > file. I think you can easily find it in UniAdmin somewhere. > > > > So even if that file you are referring to is a 32bit one and it exceeds > > 2 GB > > on the disk, you can resize it (without users on the system), and turn > > it > > into a 64 GB file and let it keep growing. > > > > Of course, back it up first as always... > > > > So I think you will be ok, especially if the records don't have much > > data in > > them as you say. > > > > On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath <dmc...@imb.com.au> wrote: > > > > > Assuming you're talking about a hash file, I'd hazard a guess that it > > > would be only limited by: > > > 1) File size > > > 2) The ability of the tools to handle the file record list (such as > > > SELECT) > > > 2.1) I.e, memory limitations and > > > 2.2) The count variable (assuming it is a 32bit signed int, that > > gives > > > you a max 2^31 = 2147483648 records) > > > > > > -----Original Message----- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > > Gallen > > > Sent: Friday, 3 June 2011 6:38 AM > > > To: U2 Users List > > > Subject: [U2] File Item Count Limit? > > > > > > I'm on UV/Linux > > > > > > Just curious, is there a limit to the number of items you can have in > > a > > > file? or just limited to overall file size? > > > We have one file that has about 15M items at present. Not much data > > in > > > each item, just a crap load of them. > > > > > > George > > > > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > > ph:856.848.9005 Ext 220 > > > The Wyanoke Group > > > http://www.wyanokegroup.com > > > > > > > > > > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > ______________________________________________________________________ > > > This email has been scanned by the MessageLabs Email Security System. > > > For more information please visit http://www.messagelabs.com/email > > > > > ______________________________________________________________________ > > > > > > > > ####################################################################### > > #################### > > > The information transmitted in this message and attachments (if any) > > is > > > intended only > > > for the person or entity to which it is addressed. The message may > > contain > > > confidential > > > and/or privileged material. Any review, retransmission, > > dissemination or > > > other use of > > > or taking of any action in reliance upon this information by persons > > or > > > entities other > > > than the intended recipient is prohibited. If you received this in > > error, > > > please > > > contact the sender and delete the material from any computer. > > > > > > The intended recipient of this e-mail may only use, reproduce, > > disclose or > > > distribute > > > the information contained in this e-mail and any attached files with > > the > > > permission of IMB. > > > > > > > > ####################################################################### > > #################### > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > -- > > John Thompson > > _______________________________________________ > > 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 > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
