Bad performance in SAN environment for append AIO

Solution Verified - Updated -


Because SAP recommends to use dft_extent_sz, which is set to 2 (2 pages for 16K each), any DB2 object is expanded exactly to 32k and on bulk inserts leads to exactly 32k append AIO, which doesn't perform as expected.


  • Red Hat Enterprise Linux 6
  • Red Hat Enterprise Linux 7
  • sysbench IO tool from EPEL
  • Ext-4 filesystem

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In