You still might lose a little data. But in this case I was without a good way to go to backups. Fortunately, the archive that blew up has not been too important.
-----Original Message----- From: Thomas Derwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 12:25 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Static file blows 2 gig file system limit. Hi Rod, Thanks soooo much for this tip! Fortunately we've only blown 2GB on a couple of test files so far, but it's great to have a workaround. And Hi Bob, AFAIK, 64-bit files are a UV-only feature. UD drops dead at 2GB. On UD, dynamic files, by default, consist of multiple 1GB segments, which get you past the 2GB barrier. Regards, Tom >>> [EMAIL PROTECTED] 08/10/04 11:27 AM >>> Isn't it possible to resize from 32 to 64 bit to get over this ? or create a 64bit file and copy in CREATE.FILE newfile DYNAMIC 64BIT (on aix 5.2 universe 10.2) Just thought Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Baakkonen, Rodney Sent: 10 August 2004 16:09 To: '[EMAIL PROTECTED]' Subject: [U2] Static file blows 2 gig file system limit. We had the unfortunate event of having a batch process update a Unidata static file until it hit the 2 gigabyte UNIX file limit. The programmers estimate of how much data we were archiving was around a million records. Unfortunately the estimate was way low. In hind sight I should have created the file as dynamic and I would not have gotten into this pickle. But the good news is that I was able to recover all but 992 bytes of the file. So I thought I would document what I did in case anyone else on the list ever encounters this unfortunate situation. I would not have been able to do this without applying some tidbits that I learned from Wally many years ago about Unidata files. Unidata will not open a normally created file that is not evenly divisible by 1024. When process blew 2 gig, this is the size of the file: -rw-rw-r-- 1 root mcc 2147483616 Aug 9 22:35 INSURED.ARCHIVE.01.5 The file size 2147483616 / 1024 = 2097151.96875 The solution on a UNIX box is to create a new file using 'dd': dd if=INSURED.ARCHIVE.01.5 bs=1024 count=2097151 of=INSURED.ARCHIVE.REPAIR.01 This file looks like this after the 'dd' -rw-rw-r-- 1 rabaak tech 2147482624 Aug 10 10:29 INSURED.ARCHIVE.REPAIR.01 after creating a VOC pointer for the new file, Unidata successfully opens the file and I have only lost 992 bytes. Better than the whole file anyway. COUNT INSURED.ARCHIVE.REPAIR.01 COUNT INSURED.ARCHIVE.REPAIR.01 1799394 record(s) counted. Hopefully you don't encounter this problem. But if you do on UNIX, try 'dd' to get back what you can. - Rod ------- 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/ ----------------------------------------- This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. ------- 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/
