Re: Dbexport

In article <63ku36$6e1@cssun.mathcs.emory.edu>, mbaumgartner@cardhealth.com writes > >Last week there was a thread that asked how long it would take to dbexport a 28 >Gig db. Well this past weekend we were trying to dbexport a 68 Gig db only to >have it blow up when one of the .unl files reached 2 Gig. > >We are running on HP/UX 10.20, ODS 7.14 UC1. The Unix ulimit is set to >unlimited and we are able to create a file on the file system larger than 2 Gig >using Unix utilities. > But not with Informix. Informix does not support files/devices > 2Gig. You will have to unload the table in sections by hand:- unload to "<table>1.unl" select * from <table> where <primary_key> <= <value> unload to "<table>2.unl" select * from <table> where <primary_key> > <value> then load from "<table>1.unl" insert into <table> load from "<table>2.unl" insert into <table> >A call was put in to Tech Support and no answer was provided-they are >researching the issue. > >Has anyone experienced this problem before? As with most of us, we are on a very >tight time frame to migrate off our existing drives. > >Thanks In Advance, > >Mark >Cardinal Health > > -- David Williams