topic Re: File size limit ? in Operating System - OpenVMS

File size limit ?

asif munir — Sun, 02 Apr 2006 06:29:38 GMT

We have OpenVMS version 7.1 having a nfs mount from a hp-ux 11i unix box. I have allowed for lagefiles on the unix file system but when i try to do on oracle export of a dump file to the mounted filesystem on VMS i keep geeting an error when the file size gets to more than 2GB. I receive the following error message,

"EXP-00015: error on row 1895219 of table DOSLIGN, column DATFIN_LD, datatype 12

EXP-00222:

System error message 5

%RMS-F-WBE, error on write behind

EXP-00002: error in writing to export file

EXP-00002: error in writing to export file

EXP-00000: Export terminated unsuccessfully

EXP-00222:

System error message 5

%RMS-E-DAC, ACP file deaccess failed during $CLOSE
"

After looking up the error code it says that there is no space left on the device.

I was just wondering is there a limitation on nfs mount to VMS of are there any paramters that i need to change in order for this export to happen.

Asif

Re: File size limit ?

asif munir — Sun, 02 Apr 2006 06:33:04 GMT

Just to add, this is a 100GB mount point on the unix box so we have no issue of the size, only 2% is being used at the moment so there is no issue with the space.

Asif

Re: File size limit ?

Karl Rohwedder — Sun, 02 Apr 2006 07:39:39 GMT

Asif,

could you pls. tell more about:
- which TCPIP serice version
- do you export a native VMS filesystem or a container flesystem
- NFS V2 or V3

regards Kalle

Re: File size limit ?

Hein van den Heuvel — Sun, 02 Apr 2006 07:59:31 GMT

There is a 1TB limit on VMS: 2**31 * 512
There is a 2GB limit on HPUX out-of-the-box.

You want the HPUX host folsk to investigate the 'large file' settings to allow to break this 2GB boundary.

Just google for "+hpux +largefiles"
If you trust/like ITRC pointers, then add +site:itrc.hp.com

Cheers,
Hein.

Re: File size limit ?

asif munir — Sun, 02 Apr 2006 09:48:49 GMT

The version of tcp/ip on vms is,

Digital TCP/IP Services for OpenVMS Alpha Version V4.2 - ECO 3

I am running nfs v3 on the HP-UX server.

Also i have configured the filesystem on HP-UX for largefiles so that is not an issue.

Asif

Re: File size limit ?

asif munir — Sun, 02 Apr 2006 09:51:20 GMT

The HP-UX server is my NFS server and i am using the VMS server as the NFS client to the hp-ux box.

Asif

Re: File size limit ?

Steven Schweda — Sun, 02 Apr 2006 12:13:03 GMT

Support in the C run-time library for large
files may not exist in VMS V7.1.

At VMS V7.3-2 (with some CRTL patches) in:
SYS$COMMON:[DECC$LIB.REFERENCE.DECC$RTLDEF]DECC$TYPES.H
it says:

# error " Support for large files not available before OpenVMS Alpha V7.2"

I don't know how the NFS programs are
implemented, but I'd expect them to be
written in C, and I'd be a little amazed if
anything so old as TCPIP V4.2 - ECO
would offer large-file support.

You might look through the TCPIP release
notes to see if large-file support is ever
mentioned.

Re: File size limit ?

David Jones_21 — Mon, 03 Apr 2006 14:43:31 GMT

The first test I'd do would be to see if oracle can create the dump file to a local ODS-5 or ODS-2 volume. If it can, the problem is a restriction in the NFS implementation. If it can't, you need to chase down the problem with Oracle before determining if NFS has a problem.