Oninit cdi / Archive
Talk to an expert →

Re: Can pre-9.4 IDS really only use 2GB of a tape?

Posted in 2003

Topics: General Discussion

David Williams — — source: Usenet: comp.databases.informix

"Ganesan Subramanian" <gsubrama.news.invalid@web2news.net> wrote in message news:41799N796@web2news.com... > > It is not only 32 bit isue. Even in IDS9.3 -64bit system, we can't > export a database which is >2GB. > Correct, pre 9.4 you cannot export >2Gb TO DISK. Did you try to tape? As far as I know the 2GB limits apply to disk only. Tape is different. > -Ganesan. > > -- > Direct access to this group with http://web2news.com > http://web2news.com/?comp.databases.informix

↪ replying to David Williams
Michael Krzepkowski — — source: Usenet: comp.databases.informix

David Williams wrote: >"Ganesan Subramanian" <gsubrama.news.invalid@web2news.net> wrote in message >news:41799N796@web2news.com... > > >>It is not only 32 bit isue. Even in IDS9.3 -64bit system, we can't >>export a database which is >2GB. >> >> >> > > Correct, pre 9.4 you cannot export >2Gb TO DISK. Did you try to tape? > > As far as I know the 2GB limits apply to disk only. Tape is different. > > That would be 2 GB per table. Michael > > >>-Ganesan. >> >>-- >>Direct access to this group with http://web2news.com >>http://web2news.com/?comp.databases.informix >> >> > > > >

↪ replying to Michael Krzepkowski
Ganesan Subramanian — — source: Usenet: comp.databases.informix

Michael Krzepkowski wrote: > --------------000805010801020303090101 > Content-Type: text/plain; charset=us-ascii; format=flowed > Content-Transfer-Encoding: 7bit > > David Williams wrote: > >>"Ganesan Subramanian" >> <gsubrama.news.invalid@web2news.net> wrote in message >>news:41799N796@web2news.com... >> >>>It is not only 32 bit isue. Even in IDS9.3 -64bit system, we can't >>>export a database which is >2GB. >>> >> Correct, pre 9.4 you cannot export >2Gb TO DISK. Did you >> try to tape? >> >> As far as I know the 2GB limits apply to disk only. Tape >> is different. >> > That would be 2 GB per table. > > Michael > >>>-Ganesan. It is very easy to test. Please try. "dbexport test -t /dev/rmt/0m -b 1024 -s 20000000" And you will get an error as below. Tape size must be a positive integer between 0 and 2097151 -- Direct access to this group with http://web2news.com http://web2news.com/?comp.databases.informix To contact in private, remove n5osp0pa-mm

Glossary