Performance warning: Database file consists of 22 disk fragments

[Former Member]

Hello All,

I get the below warning message when SAP IQ 16 SP4 starts.

"Performance warning: Database file "H:\DATA\IQ.db" consists of 22 disk fragments"

Does anyone have an idea how to fix this warning ?

Thank you

[c_baker]

This is a catalog db message from the SQLAnywhere component of IQ and can be safely ignored for IQ.  It does not apply to the IQ dbspaces.

If you are on Windows and wish to optimize the underlying disk when IQ is down, it will clear this up.

You can also increase the -c cache parameter if you are concerned about catalog performance.

Chris

[markmumy]

The only piece that I would be concerned with is if the application is creating tables on the SYSTEM (catalog) dbspace.  Do you know if your application is explicitly doing that?  If not, then I would ignore the messages as Chris describes.  If you are creating SYSTEM objects, can you elaborate on why?

Mark

[stefano_bolli]

Hi,

    I've the same message some times ago.

It is related to file fragmentation on disk.

Hereafter 2 possible solutions:

1) stop IQ (if possible) defrag from operating system the disk where is located your "*.db"files

2) stop IQ (if possible) move the "*.db" file on a new disk without fragmentation.

In my case I applied option (2) and it works, message disappear.

Anyway the performances doesn't changes even if the warning disappeared.

Regards,

Stefano