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
Best answer by Erik Dahllöf
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
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
The table IAM_LOGIN_EVENT_DETAIL has 6 million lines older than 30 days.
The table EVENT_ENTITY has 200k lines.
Thanks,
Gianni neves
+8Hi,
You can use IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS database task to clean the tables and speedup the execution.
Regards,
Shehan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
