The log scan code uses Adaptive Server alarm resources to wake up the log scan thread when new log records are appended to the log. The current default number of alarms configured for the Adaptive Server is 40. This should be enough when there are only a few LTMs running against the Adaptive Server.
If the Adaptive Server runs out of alarms during the log scan, Adaptive Server error 9123 is displayed in the LTM error log:
Message: 9123, State: 1, Severity: 16 -- ’Unable to set a wakeup alarm for the logtransfer process.The logtransfer scan of database ’MY_PDB1’ will not honor the specified timeout of 10 seconds.’
The LTM treats this as a recoverable error, because the error should disappear when Adaptive Server alarms become available. However, if there are many LTMs running against databases on the Adaptive Server, the system administrator should increase the configured number of alarms by executing the following command:
buildmaster -ycnalarm=200 -ddbs_master
This example sets the number of alarms on the Adaptive Server master device dbs_master to 200.
