IC63136: MIGRATION TO IDS 11 CAN FAIL WITH ERRORS -312/-100 FOR A NON-DEFAULT LOCALE DATABASE WHEN THE INSTANCE HAS BEEN REVERTED

APAR status

• Closed as program error.

Error description

• If an IDS 10.00 instance contains a database with a non-default
  locale like de_DE.8859-1, has a stored procedure with
  a default value for at least one argument defined, is migrated
  to IDS 11.x, reverted back to IDS 10.00, and then migrated
  again to IDS 11.x, the migration process will fail with the
  following errors in the online message log.
  
  Converting database migtest ...
  Conversion failed with SQLCODE = -312 ISAMCODE = -100
  The conversion of the database migtest has failed.
  Conv/rev: Failed to convert component SQL to component version
  29
  Conversion failed for component SQL : entity_ver 29 != target
  version 31
  Assert Failed: Conv/rev: Failed to convert for component SQL
  

Local fix

• If the database in IDS 10.00 has rows in the sysdefaults system
  catalog with column "class" having a value of "P" after the
  reversion from IDS 11, this will lead to the duplicate key
  error (-100) during the migration. Before the migration to IDS
  11 these rows can be deleted from sysdefaults. However, it is
  stronly recommended to contact technical support before making
  manual changes to the system catalog of a database.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Conversion/Reversion users with non-default locale database  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * User converts from 10.00 to 11.XX, then reverts back to      *
  * 10.00, and finally converts to 11.XX. The last conversion    *
  * fails with error -312 and ISAM error -100.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC6.  Sysdefaults table was not
  being cleaned up correctly. There were leftover rows with class
  'P'. These rows are now cleaned up correctly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP