we have IDM 3.0.1 running JDBC driver connected to SQL2005. Everything is
working fine. We are updating employee manager relation into database by
adding managerCN to user account.

The problem is when manager account got renamed, we need to rename
managerCN field value in the database for all user accounts who are
reporting to manager.
Is anyone done this or the best way to do it.

For a rename event and if user is also manager, change destination
attribute value to new name of manager to all the user who have
managerCN=old manager name.

your help is much appriciated