Troubleshooting
Problem
One of the steps required to migrate from InfoSphere Master Data Management Server for Product Information Management version 6 to InfoSphere Master Data Management Collaboration Server version 10 is running the migrateFrom600FP.sh script located under $TOP/bin/migration directory. The migration script states to have completed successfully. However, there is a list of missing indexes reported in the console output.
Symptom
Cause
This has been identified as a product defect under APAR JR43088
Diagnosing The Problem
The last step of the migrateFrom600FP.sh script invokes a database verification, the report will contain missing indexes.
Sample excerpt of the output generated by the migration script "migrateFrom600FP.sh":
-------------------------------------------------------
Summary of the migration
-------------------------------------------------------
Migration to IBM InfoSphere Master Data Management Collaboration Server Version 10.0.0 was successful.
=======================================================
Analyzing schema '<schema>'
This may take several minutes. Do not kill the session.
=======================================================
Generating database verification report...
....
Missing Indexes
========================================================================================
| CTG_1_UK CTG_COMPANY_IDCTG_NAME
| DOA_0_UK DOA_DOC_IDDOA_CMP_IDDOA_NAME
| IUTL_LCK_0 LCK_JVM_IDLCK_THREAD_IDLCK_TYPE
| IWFL_STD_0 STD_WFL_IDSTD_CMP_ID
| LCK_0_PK LCK_OBJECT_IDLCK_OBJECT_TYPELCK_JVM_IDLCK_THREAD_IDLCK_TYPE
|_______________________________________________________________________________________
Resolving The Problem
To correct the missing indexes run the SQL statements below from $TOP directory. Use these steps only if your back end database is DB2.
Index CTG_1_UK CTG_COMPANY_IDCTG_NAME
perl $PERL5LIB/runSQL.pl --sql_command="alter table tctg_ctg_catalog drop constraint ctg_1_uk ;"
perl $PERL5LIB/runSQL.pl --sql_command="drop index ictg_ctg_2;"
perl $PERL5LIB/runSQL.pl --sql_command="alter table tctg_ctg_catalog add constraint ctg_1_uk unique (ctg_company_id, ctg_name);"
perl $PERL5LIB/runSQL.pl --sql_command="create index ictg_ctg_2 on tctg_ctg_catalog ( ctg_name, ctg_company_id) ALLOW REVERSE SCANS;"
Index DOA_0_UK DOA_DOC_IDDOA_CMP_IDDOA_NAME
perl $PERL5LIB/runSQL.pl --sql_command="alter table TDOC_DOA_DOC_ATTRIBUTES drop constraint doa_0_uk ;"
perl $PERL5LIB/runSQL.pl --sql_command="drop index idoc_doa_0;"
perl $PERL5LIB/runSQL.pl --sql_command="alter table tdoc_doa_doc_attributes add constraint doa_0_uk unique (doa_doc_id, doa_cmp_id, doa_name);"
perl $PERL5LIB/runSQL.pl --sql_command="create index idoc_doa_0 on tdoc_doa_doc_attributes ( doa_name, doa_doc_id, doa_cmp_id) ALLOW REVERSE SCANS;"
Index IUTL_LCK_0 LCK_JVM_IDLCK_THREAD_IDLCK_TYPE
Index LCK_0_PK LCK_OBJECT_IDLCK_OBJECT_TYPELCK_JVM_IDLCK_THREAD_IDLCK_TYPE
perl $PERL5LIB/runSQL.pl --sql_file=$TOP/src/db/schema/dbscripts/db2/recreate_lck_mdc.sql
Index WFL_STD_0 STD_WFL_IDSTD_CMP_ID
perl $PERL5LIB/runSQL.pl --sql_file=$TOP/src/db/schema/dbscripts/db2/std_pk.sql
To confirm there are no more missing indexes / changed tables you can run the command below:
$TOP/bin/db/verify_tables_indexes.sh and verify the console output.
You may now proceed with next migration steps as documented in the InfoCenter Migrating from V6.0.0 to V10.0.0.
Related Information
Product Synonym
WPC
MDMCS
MDMPIM
MDM Server for PIM
WebSphere Product Center
InfoSphere MDM Server for PIM
InfoSphere Master Data Management Collaboration Server
InfoSphere Master Data Management Server for Product Information Management
Was this topic helpful?
Document Information
More support for:
InfoSphere Master Data Management Collaboration Server
Software version:
10.0
Operating system(s):
AIX, Linux, Solaris
Document number:
206637
Modified date:
16 June 2018
UID
swg21598714