One WP hangs during startup | U00005365 Gathering database statistics

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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').

Environment

Release : 21.0.3

Component : AUTOMATION ENGINE

ILM activated

Cause

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.

Resolution

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:

• Wait
• Put a comment in front of the content of DBSYN_Content in the UC_DBSYN table where DBSYN_Type is equal to GATHER_TABLE_STAT:

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.