WPs of a system on which ILM is activated never start up completely and are hung on gathering statistics, while STATISTIC_TIME=0:
U00005365 Gathering database statistics for table 'AH' (partition: '180').
Release : 21.0.3
Component : AUTOMATION ENGINE
ILM activated
The fact that the calculation takes a long time is not a bug, you just have to wait until it is done.
However, the fact that AE tries to gather ILM statistics while the option is switched off (STATISTIC_TIME=0), is a defect.
This is a bug where the AE tries to gather ILM statistics while the option is switched off (STATISTIC_TIME=0).
As a workaround, you have 2 options:
update UC_DBSYN
set DBSYN_Content=concat('--',(select DBSYN_Content from UC_DBSYN where DBSYN_Type='GATHER_TABLE_STAT'))
where DBSYN_Type='GATHER_TABLE_STAT'
If you encounter this issue please contact Broadcom Support
Solution: This bug is fixed in version 21.0.6 of the Automation Engine.
Update to this version to have this problem solved when using ILM.