IC70288: ACCESSING A FRAGMENTED TABLE WITH SPATIAL DATA RETURNS ERRORS 'USE 12','USE 27',212,525 OR CORRUPTED DATA IF THE TABLE HAS ROWID

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 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