Shell Script to Check File Size, New File When Size Reached

[saw15]

Using HP 11.0 Unix..

Filesystem is set to largefiles, but still can only create 2 gig file using sqlplus writing to a textfile, the file should be about 3 gig. I call the sqlplus via a *.sh script.

Does anyone possibly know why my file is being limited to 2gig?

I call the temp.sql statement from the *.sh script. Where would I use the split command in the *.sh script if that was the chosen route? (this is the statement that I use to call sqlplus - sqlplus $dbuser/$dbpass @$exppath/temp.sql).

Any other suggestions? Possibilites?

Thanks

 

[patel]

We have same trouble
if I use original sh then I can create 2GB file
If I use tcsh then I can't

type
#ulimit -a

This will tell you what is your limit

To change it

POSIX shell (/usr/bin/sh):
Use ulimit -a to display all ulimit parameters. The first letter of each of parameter is the option that you use to change the
limit of that parameter. For example for "file(blocks)" make this unlimited by:
ulimit -f unlimited

K-shell (usr/bin/ksh):
Ulimit for ksh only refers to filesize. There is no "unlimited" value, although the maximum value of 4194304 is interpreted
as unlimited. To change it:
ulimit 4194304

C-Shell (/usr/bin/csh)
Ulimit is not used. Instead "limit" is used and it has much the same functionality as the POSIX version of ulimit.

Patel