Database Client Notification (-usernotifytime)

Use Database Client Notification (-usernotifytime) to specify how often a client polls the database to see if schema changes are in process due to certain administrative actions.

-usernotifytime polltime

polltime

The time, in seconds, of how often a client polls for notification of administrative actions resulting in a schema change. The default is 600, indicating that clients will poll for notification every 10 minutes. The minimum non-zero value is 1; the maximum is 86400 (for 24 hours).

If no updates to schema are anticipated, due to index activation or rebuild, while the database is online, you can disable notification, or set the notification value to a very high number. If a change is required, the time between polls can be modified with PROMON or through the _DbParams VST. However, if the value is changed from 0 to a non-zero value, currently connected clients will not observe the change; only new clients will poll to receive the polltime value. Likewise, any other non-zero value changes will not be observed by currently connected clients until such time as their current poll time is reached and they poll for notification.

Note