Hi Ang, You don't have to wait until the file exceeds 2Gb before resizing to 64bit. Put a job in your crontab to run at night and go through each file. Resize the ones over 1.5Gb to 64bit and you won't have that problem. Be careful to check both parts of a dynamic file because they can also blow 2.0Gb as you found out.
Once a file is 64bit don't use uvfixfile as it doesn't work. Use the file tool found in uniadmin. 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 Ang Suan Yong Sent: Wednesday, 11 August 2004 12:13 PM To: [EMAIL PROTECTED] Subject: RE: [U2] dynamic file blows 2 gig file system limit. Dear All, What if the dynamic file blows 2 gig ? i have encountered problem when repairing a dynamic file by using uvfixfile and resize to 64bits . It prompt the belowing message In Universe version 9 : The file has been truncated. File Modulos is greater that physical file. Invalid next split ptr in header. Warning. File Load Discrepancy detected Scanning overflow buffers. Warning : No Link to overflow group 264602. In Universe version 10 : Warning: "TEST.FILE/DATA.30" has been truncated. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 2147483647 Warning: Unable to set GROUP LOCKS on TEST.FILE. Beginning TRACE of TEST.FILE. TRACE of TEST.FILE completed. Scanning free buffer chain. Scan complete. Scanning overflow buffers. Warning: No link to overflow group 264602. Scan complete. 1048574 group(s) processed. 1549423 group buffer(s) processed. 11041957 record(s) processed. Number of data bytes = 2122571628. Thanks and Regards > -----Original Message----- > From: Wally Terhune [SMTP:[EMAIL PROTECTED] > Sent: Wednesday, 11 August, 2004 2:47 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Static file blows 2 gig file system limit. > > This problem should no longer occur with UniData 6.0.8 or later. > Also - once you have truncated the file back down to an even multiple of > the blocksize and can open it, there is rarely any additional physical > file > corruption. > With fairly recent versions of UniData, the error message tells you > exactly > what the problem is and the block size of the file. > Or, you can use 'fileview -p1 FILENAME' from the shell to see the block > size to use with the dd command. > > Wally Terhune > Manager - U2 Advanced Technical Services > IBM DB2 Information Management Software > Tel: 303.294.4866 Fax: 303.294.4832 > [EMAIL PROTECTED] > > www.ibm.com/software/data/u2/support - Open, Query, Update, Search - > Online! > > Don't miss out on the IBM DB2 Information Management Technical Conference > September 19-24, 2004 - Las Vegas, NV > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > DISCLAIMER:- <<This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you.>> ------- 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/
