max file size

[Unix Administrator_6]

I am looking for the maximum file size that is ok on the HP9000 for our database files. I thought there was a limit but I can't remember what it was. Any idea or know where I could find the limit for our HPUX 10.20?

[Unix Administrator_6]

Thanks Dean!

[Dean Carroll · Accepted solution]

got this from HP website.
Configuration Info
Operating System - HP-UX
Version -10.20
Hardware System -T520Solution

Maximum of 255 logical volumes on a disk.Maximum of 255 disks in a volume group.
Maximum of 255 volume groups in a system.

Minimum size of a physical extent is 1 Mb.
Maximum size of a physical extent is 256 Mb.

Minimum size of a logical volume is 1 Mb.
Maximum size of a logical volume is 128Gb.

Maximum size of a file is 128Gb.
Maximum size of a file system is 128Gb.

When LVM (Logical Volume Manager) mirrors are used and you
have a 128Gb logical volume prior to mirroring, you will
need another 128Gb to mirror. You will only see 128Gb of
the logical volume as being useable, though, so that you canhave a copy.

[Brian M. Fisher]

By default the max. file size is 2G unless largefiles has been configured for the filesystem.
To determine if largefiles has been set:
fsadm /dev/vgXX/lvolYY
where XX is vg number
YY is logical vol. number

Brian
<*(((>< er

[Unix Administrator_6]

Where is that info found on the HP site that Dean mentioned? I'm looking.....

[Dean Carroll]

Technical Knowledge Base Document ID A4627794

[Dean Carroll]

Technical Knowledge Base Document ID A4627794

[James R. Ferguson]

Sheri:

You should read /usr/share/doc/lg_files.txt for a good discussion.

You should also remember that utilities like tar do NOT support backup of files over 2GB.

...JRF...

[Unix Administrator_6]

Thanks guys. It sounds like I should go by 2G. I don't have the .txt doc that was mentioned by James, but thats ok, I hear what you guys are saying.

[Tim Malnati]

Adding the largefiles option to the file system configuration will allow files greater than 2 gig >>BUT<< this is dependant on the database engine/software that your using to access it. Some engines have the capability for the larger files (> 2 gig) but often require options to be set within the database environment in order to work with them.

[Bill Hassell]

Sherri wrote: "I don't have the .txt doc that was mentioned by James"

Does the /usr/share/doc directory exist? If not (and you're running 10.20 or higher) someone has removed this rather important directory. If this is the case, reload the OS-Core.RELEASE-NOTES package using swinstall from your Install/Core CDROM.