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
Modified date:
16 June 2018
UID
swg21598714