The iidbms.exe process spikes in CPU and RAM usage.

Products

• CA Directory
• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Risk Analytics
• CA Secure Cloud SaaS - Arcot A-OK (WebFort)
• CLOUDMINDER ADVANCED AUTHENTICATION
• CA Secure Cloud SaaS - Advanced Authentication
• CA Secure Cloud SaaS - Identity Management
• CA Secure Cloud SaaS - Single Sign On
• CA Security Command Center
• CA Data Protection (DataMinder)
• CA User Activity Reporting

Issue/Introduction

Description:

The iidbms.exe process spikes in CPU and RAM usage. This causes requests to admin to periodically fail, which can lead to password mismatches and the need to contantly reboot. This process is part of Ingres, and the high resource usage generally means the database needs to be tuned.

Solution:

The problem here is most likely that the Ingres DB has not been tuned in a while. Tuning the database is necessary for improved performance and consistency. Tunes should be done at least once a month.

To tune your DB:

At a command prompt:

net stop eta_slapd
net stop eta_connector
dxserver stop all
dxtunedb -full etrustadmin
dxserver start all
net start eta_slapd (which will also start the connector)

The full tune must be done with the directory offline. It re-lays out the Ingres tables used by the directory which reclaims space from deleted entries and optimises the structure of the B-Tree tables for optimum performance.

If a gradual decrease in performance is seen, or a lot of entries are deleted, then running this option should be considered.

Environment

Release:
Component: ETRADM