Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Db2 11.5 Linux RHEL and xfs filesystem

  • 1.  Db2 11.5 Linux RHEL and xfs filesystem

    Posted 22 hours ago

    Hello,

    Our production environment is Linux RHEL 9.4, Db2 Linux v 11.5.9 in AWS EC2 environment with EBS gp3 volume 15.000 IOPS 500 Throughput (MiB/s) storage. We are using xfs filesystem configured over the EBS gp3 volume as database physical structure.
    We are searching suggestions / best practices related to xfs settings in a Db2 environment. We have found some documents suggesting to use nobarrier mount option that will increase the performance of the database. Does anyone already used nobarrier and notime as mount options for xfs filesystem in RHEL environment with Db2 11.5 ? 
     
    At the moment our Db2 xfs filesystems have been mounted as:
    /dev/nvme6n1 on /data3 type xfs (rw,relatime,seclabel,attr2,inode64,logbufs=8,logbsize=32k,noquota)
     
    From the documentation we have found the suggested mount is:
    /dev/nvmeXnY /db2/data xfs noatime,nodiratime,inode64,logbufs=8,nobarrier,largeio,swalloc,nofail
     
    Any suggestion / experience is welcome.
     
    Thanks. Ciao. Roberto.


    ------------------------------
    Roberto Stradella
    ------------------------------


Related Content