FileSystem Deframmentation

[Maurizio Fulli]

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

[Steven E. Protter]

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

[Maurizio Fulli]

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.