DB2 : DB2 and ZFS

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by rdutton 0n 31 December 2008

We recently switched servers and versions (going from AIX 32 bit v8.2 FP9 to Solaris 64 bit v9.5 FP2a). The new server is a T2000 with 64GB RAM running Solaris 10 – a much stronger machine than before so we were expecting better performance, but we are getting worse. We have another v9.5 FP2a installation in test (also on Solaris 10) that is getting better performance on a weaker server. Production and test are identically configured (except for smaller bufferpools and circular logging in test). The biggest difference we see is the T2000 is using ZFS and test is using UFS.

Has anyone had performance issues with ZFS? Is there special tuning needed for ZFS?

Learn more about databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting