Created On:  15 February 2011

Problem:

Using XDBC I tried to retrieve and/or update data of a COBOL file and get, when the COBOL file is bigger than 4 gigabytes, this error on the SELECT statement:
 
17:21:19,995 ERROR [Application] ...
scan, sqlState = 07000
java.sql.SQLException: executeQuery exception: MFEXTFH: Cannot open 'FileNAme',No space in directory or directory does not exist
 at vortex.sql.vortexPreparedStatement.executeQuery(vortexPreparedStatement.java:154)
 at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)

Resolution:

You have to set the File Handler option FILEMAXSIZE=8 in an File Handler configuration file
and for convenience set an EXTFH environment variable pointing to the full pathname of the File Handler configuration file.

(This is documented in Net Express like Server Express documentation)
(File Handling->Chapter 6: File Handler Configuration)

Content of File Handler configuration file: 
[XFH-DEFAULT]
FILEMAXSIZE=8

-> sample script to set EXTFH environment environment variable and set FILEMAXSIZE=8 in File Handler configuration file:
EXTFH=/home/MFFH.cfg
export EXTFH
echo [XFH-DEFAULT] >$EXTFH
echo FILEMAXSIZE=8 >>$EXTFH

Depending on the XDBC configuration you are using
  IF Stand-Alone Configuration:  EXTFH & File Handler configuration file   have to be set before to launch the XDBC application
  IF Network Configuration:        EXTFH & File Handler configuration file   have to be set before to launch the the XDBC server
Incident #2487807