Oninit cdi / Archive
Talk to an expert →

RE: How to dbexport if size > 2 GB

Posted in 2004

Topics: Installation, Setup & Upgrades, SQL Development & Query Writing, Stored Procedures & SPL, Server Administration, Migration, Import/Export & Data Conversion, Platform-Specific Issues

Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

Hi Basheer. How about using sprit command ? e.g) use Art's my export, then split -l <Line count> export.file. Execute dbimport, execute load statement from dbaccess. Just my 2 cent. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Azeemuddin, Basheer" <bahmed@knrq.com> >To: informix-list@iiug.org >Subject: How to dbexport if size > 2 GB >Date: Mon, 5 Apr 2004 09:32:50 -0500 > >Informix V 9.3 >AIX 4.3.3 > >Dbexport fails because tbl size is > 2 GB >I have created file system as > >Large File Enabled Journaled File System ( in AIX) > >If I use Art's myexport, can I import this into HP-UX 10.20 Informix 7.3 >using dbimport (not Art's utils, because they never worked) > >Note: Since Hp-UX doesnot have ansi C and gnu couldn't install on this >machine. So Can't use Art's utils on HP-UX. AIX is OK. I was able to get >them working. > > >Thanks >Basheer > >sending to informix-list _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail sending to informix-list

↪ replying to Tsutomu Ogiwara
Ferronato — — source: Usenet: comp.databases.informix

Hi all Before dbexport, check the limits in your section. I guess you're running dbexport with "informix" user, then, in AIX, run the command: > ulimit -a Check the line with "file(blocks)" if it is 'unlimited' If not, change the file >vi /etc/security/limits If not have, insert a line, with user "informix": informix: fsize = -1 :x (save and quit) Try dbexport again. After that, IF you split the large file in nnnn lines (as says Tsutomu), you have to change the <database>.sql script file , before dbimport, removing the mention of that table (and constraints), or change to 0 (zero) in the number of rows and delete all lines in the file mentioned in script. Hope it helps you. Regards. R. Ferronato "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:<c4t58p$ag5$1@terabinaries.xmission.com>... > Hi Basheer. > > How about using sprit command ? > e.g) > use Art's my export, then split -l <Line count> export.file. > Execute dbimport, execute load statement from dbaccess. > > Just my 2 cent. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 > > > > > > >From: "Azeemuddin, Basheer" <bahmed@knrq.com> > >To: informix-list@iiug.org > >Subject: How to dbexport if size > 2 GB > >Date: Mon, 5 Apr 2004 09:32:50 -0500 > > > >Informix V 9.3 > >AIX 4.3.3 > > > >Dbexport fails because tbl size is > 2 GB > >I have created file system as > > > >Large File Enabled Journaled File System ( in AIX) > > > >If I use Art's myexport, can I import this into HP-UX 10.20 Informix 7.3 > >using dbimport (not Art's utils, because they never worked) > > > >Note: Since Hp-UX doesnot have ansi C and gnu couldn't install on this > >machine. So Can't use Art's utils on HP-UX. AIX is OK. I was able to get > >them working. > > > > > >Thanks > >Basheer > > > >sending to informix-list > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > sending to informix-list

Glossary