APAR status
Closed as program error.
Error description
If you create a fragmented table with rowid column (using 'alter table ... add rowids' or 'alter fragment ... init with rowids') and the table stores a spatial data (like st_point datatype) and then you insert/load/dbimport the data into this table, the subsequent access to the table might return various errors like: - during a select statement, you may receive errors USE 12 - Unknown or unsupported geometry type (%TYPE%) found in %FUNCTION% USE 27 - Unknown or unsupported geometry data structure version (%VERSION%) found in %FUNCTION% or the data from the columns following the spatial column might be presented as corrupted. - when adding an index or a referential key you might get errors: a) 212 (Cannot add index.)/103 (ISAM error: illegal key descriptor) b) 525 (Failure to satisfy referential constraint) / 111 (ISAM error: no record found) - an update of the columns following the spatial column seems to be successfull, but the data might not get updated
Local fix
Don't use the rowids with fragmented tables storing the spatial datatypes
Problem summary
**************************************************************** * USERS AFFECTED: * * Customers altering table to add or drop rowid when the table * * has UDT, ROWTYPE or COLLECTION type columns with more than * * 4-byte alignment * **************************************************************** * PROBLEM DESCRIPTION: * * Table becomes unusable on altering it to add or drop rowids. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS-11.50.xC8 or above when available. * ****************************************************************
Problem conclusion
Problem first fixed in IDS-11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC70288
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
2010-07-29
Closed date
2011-01-20
Last modified date
2011-01-20
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 PSN
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:
20 January 2011