[Info-ingres] File size limit on Ingres 2.6 + RH 8

Hi all:

I am using Ingres 2.6 SP2 on a Red Hat 8 box.
One of my user tables is 1.1 GB. size, in one .t00 file.
I need to download this table in an ascii file using copydb -c. Doing this, I have the next error and the conexión with DB is broken:
File size limit excedeed.
The result incomplete ascii file is almost 2 GB.
I know there is a file size limitation of 2 GB per file on Ingres, but I don't remember that this is applied to Ingres 2.6 over RH 8. Even if this limitation persists on Ingres 2.6 over Linux, simply I will have to create another data location and modify this table over those 2 locations. But this, will work for proper table operation (selects, update, etc). What Can I do for copydb -c?
I did a simple test, copying one big file (2.3 GB) to RH file system, and there is no problem. I asume that no problem exists with RH FS supporting a file > 2 GB. Then it will be about Ingres 2.6.

I will appreciate your comments and if the only way to solve this is upgrading my OS and Ingres version.

Best Regards

Oscar

--
Lic. Oscar Carlés Barriocanal
Director de Servicios al Cliente
Íntegra S.R.L.
Telefax: (595 21) 424473 RA



.

Relevant Pages

  • Re: [Info-ingres] File size limit on Ingres 2.6 + RH 8
    ... I need to download this table in an ascii file using copydb -c. ... I know there is a file size limitation of 2 GB per file on Ingres, ... create another data location and modify this table over those 2 ... of the Linux kernel which didn't have large file support ...
    (comp.databases.ingres)
  • Re: [Info-Ingres] DataMigration
    ... I'm not sure what you should do on ingress but on ingres, ... you need is copydb. ... If the servers are the same OS / architecture you can use a binary copy ...
    (comp.databases.ingres)
  • Re: [Info-ingres] Re: Archiving data from tables
    ... I'm not near an ingres system right now, ... When using copydb with a view, ... Reportwriter report could be written to write out the data in the ... format you need based on a simple ...
    (comp.databases.ingres)
  • Re: Archiving data from tables
    ... It only runs on Windows but it could in theory be used via Ingres Net ... script for the table to be archived, creating a view (select * from ... When using copydb with a view, ...
    (comp.databases.ingres)
  • Ingres 2.6 buggy
    ... of Ingres in the past? ... Problems with BLOBS, case statement, copydb just to ... Prev by Date: ...
    (comp.databases.ingres)