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 number
IC63136
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-10
Closed date
2009-10-29
Last modified date
2009-10-29
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
29 October 2009