Skip to main content

Hi,

Our DB server is spiking at 99% really often, I tried to find the problem, but I cannot find. Only thing, I run a top session and had this below. it seems that IAM session is taking all my cpu:

 

Any ideas?

We are running IFS Cloud 23.2.5, on-premises 

Thanks,

 

Gianni Neves

Hi Gianni,

We have a few known problems with events in IAM.

Can you check how many records there are in ifsiamsys.EVENT_ENTITY and in ifsapp.IAM_LOGIN_EVENT_DETAIL and how many that are older than 30 days? The records there should be cleanded and only store the last 30 days.

We have a post about IAM_LOGIN_EVENT_DETAIL here:

/ Erik

Thank you @Eri Takada .

The table IAM_LOGIN_EVENT_DETAIL has 6 million lines older than 30 days.

The table EVENT_ENTITY has 200k lines.

Thanks,

 

Gianni neves

Hi,

 

You can use IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS database task to clean the tables and speedup the execution.

 

Regards,

Shehan

Reply


Terms & ConditionsCookie settings