Business unit transfer activity completion might take a long time

We might encounter slow performance during transfer of business unit activity. To improve performance, you can implement the following solutions.

• Add the following indexes:
  • CREATE INDEX "IDSLDAP2"."TESTIDX1" ON "IDSLDAP2"."SN" ("SN" ASC, "EID" DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
  • CREATE INDEX "IDSLDAP2"."TESTIDX2" ON "IDSLDAP2"."OBJECTCLASS" ("EID" ASC, "OBJECTCLASS" DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
  • CREATE INDEX "IDSLDAP2"."TESTIDX3" ON "IDSLDAP2"."LDAP_DESC" ("DEID" ASC, "AEID" DESC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;
• Update the table statistics by using IBM Security Identity Manager performance tuning scripts.
• Perform the business unit transfer activity during the time of least activity on the application server.

Parent topic: Transferring a business unit