Hi Bob, A 64bit file has a very large capacity. The 64 bit number is binary so every bit = 1 greater power of 2. Whereas 2,147,483,648 = 2^31 then 9,223,372,036,854,775,808 = 2^63. A very big number indeed. The reason it is 31 and 63 is that the leftmost bit generally signifies the sign of the number, eg: whether it is a positive or a negative number. If it is 1 then it is negative, 0 is positive so it generally doesn't get used when calculating the filepointers.
I'm not that familiar with HPUX, however I'd be checking out any filesystem limitations there maybe. Depending on the filesystem you are using, eg: UFS, XFS or JFS there could be limitations on the maximum filesystem size. Check with your support people but Universe shouldn't be giving you any problems. Admittedly we are running a version 10.0 system on Tru64 but we have files that are now in excess of 25Gb so it really shouldn't be that. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Wednesday, 1 September 2004 8:30 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Memo: Universe file size limit Surely if the standard Universe 32bit max file size is 2gb (2147483648 Bytes) Then the 64bit would be 4gb (2147483648*2 Bytes) Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: 01 September 2004 11:46 To: [EMAIL PROTECTED] Subject: RE: [U2] Memo: Universe file size limit Unix limitation? Perhaps something needs tweaking there. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 September 2004 10:18 To: [EMAIL PROTECTED] Subject: [U2] Memo: Universe file size limit Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large... thanks in advance.... ************************************************************ HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. ************************************************************ _____________________________________________________ This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/