Informix

Informix

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

 View Only

  • 1.  onstat Thread priority question

    Posted 12/22/24 06:59 PM

    Hi,

    onstat -g ath | egrep "prty|sqlexec|kaio"


     tid     tcb              rstcb            prty status                vp-class       name
     14       46559390         0                3    IO Idle                 9cpu*        kaio
     15       466239c0         0                3    IO Idle                 1cpu*        kaio
     38       483f1980         0                3    IO Idle                 8cpu*        kaio
     59       46b19bd0         0                3    IO Idle                10cpu*        kaio
     142      46f0a1b0         45cce4b8         1    cond wait  netnorm      8cpu         sqlexec

    Which thread has higher priority, sqlexec(1) or kaio(3)?

    Regards,

    David.



    ------------------------------
    David Williams
    ------------------------------


  • 2.  RE: onstat Thread priority question

    Posted 12/23/24 05:38 AM

    Hi David,

    According to https://www.oninit.com/onstat/index.php?id=gath (thanks Paul!) the highest priority possible is 4 and lowest 1.

    This would make sense as the main_loop() thread also runs with priority 3.

    Ben.



    ------------------------------
    Benjamin Thompson
    ------------------------------



  • 3.  RE: onstat Thread priority question

    Posted 12/23/24 08:25 AM
    AFAIK
      A thread priority can range from 1 (lowest) to 4 (highest) with a default of 2.
    [https://www.oninit.com/onstat/pda.php?id=onstat%20-g%20ath]



    On 12/22/2024 5:58 PM, David Williams via IBM TechXchange Community wrote:
    01000193f0cf04cd-0cecb75e-0da1-4e58-bd16-cae416e4818f-000000@email.amazonses.com">
    Hi, onstat -g ath | egrep "prty|sqlexec|kaio" tid tcb rstcb prty status vp-class name 14 ...





Related Content