Write() Call and 2GB File Limit on 10.20

[melvin mariney]

Hi,

My database(Informix) can write more than 2gb to a disk filesystem for a database backup, but I get an error whenever I set the size of the file to more than 2GB within Informix.

What in the OS on 10.20 limits the write() call on a single open() call to 2gb?

TIA,
Melvin Mariney

[James R. Ferguson]

Melvin:

To use 'largefiles' you must have converted the filesystem to a largefile filesystem.

If you /etc/fstab entries show "largefiles" then the filesystem in question has been converted.

You should FIRST READ the HP-UX Large Files White Paper (in PDF format) at:

http://docs.hp.com/hpux/11.0/

...JRF...

[Erkan Durmus]

This is the solution I had used with Oracle:

!!! IMPORTANT: THESE EXAMPLES ONLY WORK IN KORN SHELL (KSH) !!!

Use the UNIX pipe and split commands:

Export command:

echo|exp file=>(split -b 1024m - expdmp-) userid=scott/tiger tables=X

Note: You can put any "exp" parameters. This is working only in ksh and
has been tested on Sun Solaris 5.5.1.

Import command:

echo|imp file=<(cat expdmp-*) userid=scott/tiger tables=X

Splitting and compressing at the same time:

Export command:

echo|exp file=>(compress|split -b 1024m - expdmp-) userid=scott/tiger tables=X

Import command:

echo|imp file=<(cat expdmp-*|zcat) userid=scott/tiger tables=X