1748256 Members
3807 Online
108760 Solutions
New Discussion юеВ

Re: Filesize

 
rbiorn
Advisor

Filesize

Hi!
Are there any filesize limits on HP10.20. I need db-files larger then 2Gb on an oracle 7.3.4 database.

-ragnar-
"You cannot achieve anything beyond your wildest dreams --- if you don't have any wild dreams"
4 REPLIES 4
Stefan Farrelly
Honored Contributor

Re: Filesize


The filesize limits on 10.20 around 128GB. All you need to be careful of is to use vxfs and the -o largefiles options on newfs when you format your filesystem.
Im from Palmerston North, New Zealand, but somehow ended up in London...
Marcin Wicinski
Trusted Contributor

Re: Filesize

Hi Ragnar,

hp-ux 10.20 limits filesize to 128 GB, but largefiles option must be used while filesystem creation:

newfs -F vxfs -o largefiles /dev/vg01/rlvol1

later,
Marcin Wicinski
Marcin Wicinski
Trusted Contributor

Re: Filesize

Hi again,

you can convert non-largefiles filesystem to largefiles using fsadm:

fsadm -F hfs -o largefiles /dev/vg01/rlvol2
Marcin Wicinski
Manel Ventura
Advisor

Re: Filesize

Be careful with the size of the files. Although theoretically you can have a filesystem up to 128Gb with a file of the same size, I have experienced problems with files greater than 18Gb (when I'm reorganizing the database). For reasons that I ignore, arrive a moment that the system gives a filesystem full, having a lot of free space in the filesystem. Be careful with this if you plan to use autoextended datafiles.