Updating index columns

When you update index columns, you must consider two things.

  • When updating a field in a table, DB2 does not use any index containing this field to receive the rows. This includes the fields listed in the FOR UPDATE OF list in the DECLARE CURSOR statement. It is independent of whether the field is updated.
  • A table space that today is nonpartitioned can be recreated with more than one partition. SQL updates are not allowed against a partitioning key field. That means that programs doing updates of these fields must be changed to use DELETE and INSERT statements instead.


dfhtk82.html | Timestamp icon Last updated: Monday, 5 June 2017