IBM Support

How to kill a Data Sync request in ITIM

Question & Answer


Question

If a data synchronization has failed for some reason, sometimes IBM Tivoli Identity Manager will report the sync as still running. In this case, it will probably have to be manually stopped. How does one tell ITIM that the sync is stopped?

Answer

If ITIM continually reports that Data Synchronization is running, then you should check the STATUS column of the SYNCHRONIZATION_HISTORY table - one of the rows will have a STATUS of "Started".

This is what ITIM uses to determine if Data Synchronization is in progress or not. Most likely the actual processing finished long ago with some kind of error that was not reflected in the SYNCHRONIZATION_HISTORY table.

The database administrator can correct this situation by updating the status of the "Started" synchronization entry to "Failed".

EXAMPLE:
bash# db2 "connect to <insert_itim_db_name> user <insert_dbuser> using <insert_dbuser_password>"
bash# db2 "update synchronization_history set status='Failed' where status='Started'"
bash# db2 "commit"
bash# db2 "connect reset"

[{"Product":{"code":"SSRMWJ","label":"IBM Security Identity Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.0;5.1;7.0","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Product Synonym

ITIM TIM ISIM SIM

Document Information

Modified date:
16 June 2018

UID

swg21303678