IM InfoSphere Identity Insight, Version 8.0

Database tables that affect system performance

If system performance seems slow, Database Administrators can run database statistics against several entity database tables to improve both pipeline performance and the Visualizer user experience.

Pipeline tables

If pipeline performance seems slow, try running database statistics against the following entity database tables:
  • DQM_NAME_DICT
  • NAME
  • ADDRESS
  • NUMS
  • ATTRIBUTES
  • EMAIL_ADDR
  • DSRC_ACCT
  • SEP_RELATIONS
  • SEP_ROLES
  • ENTITY
  • DISCLOSED_RELATIONS
  • UMF_LOG
  • UMF_EXCEPT

Visualizer tables

If Visualizer users complain that the Visualizer performance seems slow, try running database statistics against the following entity database tables:
  • ER_ENTITY_SCORE
  • ER_HISTORY
  • ER_RELOCATION
  • ER_DETAIL
  • ER_ACCT_SCORE
  • ER_ENTITY_STATE
  • ER_FORCED_LOG
  • SEP_CONFLICT
  • SEP_CONFLICT_REL
  • SEARCH
  • APP_ACTIVITY_CODES
  • APP_ACTIVITY_HISTORY
  • APP_CONFLICT_GROUP
  • APP_INBOX
  • APP_ROLE
  • APP_SEND
  • MATCH_MERGE_RULES
  • CONFLICT_RULES
In addition, because the Visualizer also uses a background pipeline to perform several Visualizer tasks (such as adding entities, finding entities by entity resolution, and disclosing relationships), Database Administrators should also run database statistics against the database tables listed in the Pipeline tables section.


Feedback

Last updated: 2009