Our on-prem IFS Cloud database server is regularly spiking to ~99% CPU, and a top-sessions check points at IAM-related sessions as the cause. Where should I look?

All FAQ questions / Security and access

Answer

Check how many rows exist in ifsiamsys.EVENT_ENTITY and ifsapp.IAM_LOGIN_EVENT_DETAIL, and specifically how many are older than 30 days — IAM is meant to retain only the last 30 days of login-event data in these tables, and a known cleanup gap can leave them growing unbounded, which drives up CPU as IAM repeatedly scans over the bloated tables. Clearing out the stale rows (per IFS's guidance for this specific known issue) is the fix, rather than treating it as a general capacity problem.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions