Informix

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Mon March 21, 2022 07:13 AM
From: Thomas Sherlock
Subject: Recovery thread monitoring

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
------------------------------

#Informix