topic Re: FileSystem Deframmentation in Operating System - HP-UX

FileSystem Deframmentation

Maurizio Fulli — Tue, 28 Jul 2009 09:43:39 GMT

Hi Guys,

i've a critical growth on database FS in production environment.
This database is distribuited on 2 hosts, but i can't stop one of this for maintenance activities.
The first Front-End DB got a FS block setting of 4kb, the second one got a 8kb setting.
I suppose that the second FE got a high FS framnmentation.

In attach The "fsadm -F vxfs -D -E" output.

Is possible to run a FS compact without give some impact on database mounted on FS?

Thks in advance

Re: FileSystem Deframmentation

Steven E. Protter — Tue, 28 Jul 2009 10:52:01 GMT

Shalom,

If you mean de-fragmentation, no there is no way to run this without impact on the database. The impact can be potentially severe, impeding performance.

If you choose a time to run the de-fragmentation that is one of lower use, you should be able to get through it without severe impact.

SEP

Re: FileSystem Deframmentation

Maurizio Fulli — Tue, 28 Jul 2009 13:15:00 GMT

Thks Steve,

i've open a TT on HP support, maybe the best way is to backup the entire datas, destroy the FS and rebuild FS with the correct block_size.

The FS compact procedure is only a temporary solution.