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
