How do you get around uncompressing large files?

[David Heard]

oracle dba 1678990689 Jan 8 10:54 dms92_20040107.dmp.

[Robert-Jan Goossens]

David,

I don't understand your question. Do you need to uncompress the file on a different filesystem ?

Regards,
Robert-Jan

[David Heard]

I have a large file and when I try to uncompress it, it runs for about 5 minutes and errors out with file to large error message.

[Robert-Jan Goossens]

Oke,

Your filesystem does not support largefiles.

Check if lragefiles is enabled.

vxfs
# fsadm -F vxfs /your_mount_point

hfs
# fsadm -f hfs /your_mount_point

Robert-Jan

[Mark Grant]

This sounds like you are trying to uncompress the file in a filesystem that does not have largefiles support.

If so, you'll have to set largefiles option with

"fsadm -o largefiles /dev/vg00/rlvol1" or whatever the filesystem is. It should also be mounted with the "-o largefiles" option.

[David Heard]

I do not have online JFS. What are the commands in single user mode

[Robert-Jan Goossens]

No you do not need to be in single user mode.

Umount the filesystem and reenter the fsadm command

# umount /your_mount_point
# fsadm -F vxfs -o largefiles /your_mount_point
# mount /your_mount_point

[Dave Hutton]

Just going down another road. But is there a chance you don't have enough room in the place that your trying to uncompress it? The reason I ask is I'm 90% sure that when you uncompress a file you tend to have 2 files (the compressed one and the one your trying to uncompress) so you really need space in that filesystem to hold 2 files.
Hopefully that makes sense.

Dave

[Robert-Jan Goossens]

Check below,

# umount /app/oracle/dbappl
# fsadm -F vxfs -o largefiles /dev/vg01/rlvol4
# grep /app/oracle/dbappl /etc/fstab
/dev/vg01/lvol4 /app/oracle/dbappl vxfs log,nodatainlog,largefiles,rw,suid 0 2
# mount /app/oracle/dbappl
# fsadm -F vxfs /app/oracle/dbappl
nomultifsets
largefiles

Going home (:-)
Robert-Jan

[Michael Schulte zur Sur]

Hi,

what do want to do with that file, once it is uncompressed, import? If so, you can bypass that by uncompressing and importing via pipe.

greetings,

Michael

[Todd McDaniel_1]

David/Robert...

fsadm can be done WITHOUT umounting the FS. No need for single user mode either.

fsadm -F vxfs -o largefiles /mount/point/here

[James Odak]

A few things

#1 What version of UX are you running ..its been a while but 10.20 and lower with out JFS changing to largefiles will purge all data from the filesystem .. i could be wrong, there might have been patches to fix that since then

#2 also without JFS you must use the /dev/vgxxx/lvxx with the fsadm command
mount points only work with Online JFS installed

#3 lastly if you are just viewing this file, get some spare diskspace and make a temp filesystem largefile enabled and do not do anything to risk your exisiting oracle data.

[Robert-Jan Goossens]

Todd,

You will need online jvs for that action.

# uname -a
HP-UX 001 B.11.00 U 9000/800 160901517 unlimited-user license
# fsadm -F vxfs /app/oracle/admin
nomultifsets
nolargefiles
# fsadm -F vxfs -o largefiles /app/oracle/admin
fsadm: set feature (LARGEFILES) failed, errno 25

Kind regards,
Robert-Jan