3 Replies Latest reply: May 20, 2013 5:14 PM by 1009972 RSS

    running db2 on zfs make disk 100% utilization

    warut21
      Hello,

      I am using db2 on solaris 10 with zfs filesystem. Since change from ufs to zfs it show 100% percent utilization of disk that keep db2 data file almost all the time.

      Is this normal behavior or it has something wrong about zfs or db2 configuration?

      I use T6140 with raid 1+0 to present to ldom host and using zfs, this is result from iostat

      # iostat -xne 5|grep c0d3
      r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b s/w h/w trn tot device
      164.0 7.4 5897.8 191.3 0.0 1.2 0.0 7.2 0 39 0 0 0 0 c0d3
      214.6 3.2 3394.5 39.2 0.0 1.8 0.0 8.3 0 99 0 0 0 0 c0d3
      198.0 2.0 3145.3 32.0 0.0 1.5 0.0 7.7 0 99 0 0 0 0 c0d3
      270.6 38.2 4347.1 2011.5 0.0 2.8 0.0 8.9 0 100 0 0 0 0 c0d3
      206.2 2.8 3189.1 40.0 0.0 1.7 0.0 7.9 0 99 0 0 0 0 c0d3
      202.2 2.0 3201.5 32.0 0.0 1.8 0.0 8.7 0 99 0 0 0 0 c0d3
      186.4 2.0 2963.8 32.0 0.0 1.6 0.0 8.2 0 99 0 0 0 0 c0d3
      231.8 2.0 3675.0 32.0 0.0 2.0 0.0 8.5 0 99 0 0 0 0 c0d3
      199.4 1.6 3188.4 25.6 0.0 1.7 0.0 8.6 0 99 0 0 0 0 c0d3
      264.6 17.8 4287.0 220.4 0.0 2.7 0.0 9.6 0 99 0 0 0 0 c0d3
      243.2 2.8 3893.2 40.0 0.0 2.2 0.0 8.9 0 99 0 0 0 0 c0d3
      230.6 2.8 3698.8 37.6 0.0 2.1 0.0 8.8 0 99 0 0 0 0 c0d3
      259.0 2.0 4207.1 32.0 0.0 2.4 0.0 9.1 0 99 0 0 0 0 c0d3
      305.8 2.8 4847.6 33.6 0.0 2.9 0.0 9.5 0 100 0 0 0 0 c0d3

      Regards,