Informix

 View Only
  • 1.  Recovery thread monitoring

    Posted Mon March 21, 2022 07:14 AM
    Since the update to 14.10, we're having to scale back our recovery threads counts because of how much faster they are, and them ending up in ready state and setting off alerting. However, there appears to be no way to actually confirm how many threads are assigned other than reading the onconfig and assuming that it's been applied.

    Is there a way to properly tell if the ON_RECVRY_THREADS and OFF_RECVRY_THREADS parameters have been set, and how many threads are assigned to either pool of activity?

    ------------------------------
    Thomas Sherlock
    ------------------------------


  • 2.  RE: Recovery thread monitoring

    IBM Champion
    Posted Mon March 21, 2022 08:13 AM
    You can confirm how many threads are configured (and will be used) with onstat -g cfg on_recvry_threads and onstat -g cfg off_recvry_threads

    These values are not tunable, so cannot be changed without a restart, but the onstat -g cfg <parameter> command will show the effective value, i.e. what was defined with the last restart and not what is simply in the config file at the time.


    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------