JR34874: MIGRATING VERSION 8 DATABASE (ORIGINALLY CREATED IN VERSION 7) TO VERSION 9 WILL HAVE ITS SPATIAL COLUMN METHODS CORRUPTED.

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Customers migrating version 8 database (which was originally
  created in version 7) to Version 9, will experience internal
  corruption in the methods associated with the spatial column.
  Spatial column is a special structured type column. The methods
  associated with this type are executed when an operation is
  performed on this column.  It is this column
  .
  The main issue here is that these methods created in v7.2 or
  earlier, which are then migrated to version 8.* will suffer an
  internal corruption when migrating to v9.1, v9.5, or v9.7.
  This corruption in turn affects the spatial extenders because of
  their use of structured types (spacial columns).
  .
  This will cause different issues in different release of version
  9.  Here are the outcome of select query performed on such
  column on version 9.1
  .
  1. Version 9.1 has an "internal" corruption, which must be fixed
     so that the databases can be successfully upgraded later to
     version 9.5 and onwards. In version 9.1 you will get the
     correct data, but the corruption in the structure is still
     present.
  .
  This APAR will address and fix the corruption caused during
  migration from version 8 (for database created in version 7) to
  version 9 releases described above. This APAR does not fix
  corruption if you have already migrated to version 9 without
  this fix.
  

Local fix

Problem summary

• Customers migrating version 8 database (which was originally
  created in version 7) to Version 9, will experience internal
  corruption in the methods associated with the spatial column.
  Spatial column is a special structured type column. The methods
  associated with this type are executed when an operation is
  performed on this column.  It is this column
  .
  The main issue here is that these methods created in v7.2 or
  earlier, which are then migrated to version 8.* will suffer an
  internal corruption when migrating to v9.1, v9.5, or v9.7.
  This corruption in turn affects the spatial extenders because of
  their use of structured types (spacial columns).
  .
  This will cause different issues in different release of version
  9.  Here are the outcome of select query performed on such
  column on version 9.1
  .
  1. Version 9.1 has an "internal" corruption, which must be fixed
     so that the databases can be successfully upgraded later to
     version 9.5 and onwards. In version 9.1 you will get the
     correct data, but the corruption in the structure is still
     present.
  .
  This APAR will address and fix the corruption caused during
  migration from version 8 (for database created in version 7) to
  version 9 releases described above. This APAR does not fix
  corruption if you have already migrated to version 9 without
  this fix.
  

Problem conclusion

• Defect   => wsdbu00599082
  Fixed in => V9.1 + FP9
  Module   => engn_sqrl
  

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:

  JR34916 IC64696

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP