Observation: Key Columns Updated

You updated a key column of a non-unique index. This requires DB2 to update the rows of the base table for which you defined the index and all instances of that key column in the index itself. If the index contains many duplicate values, the time required by DB2 to perform the UPDATE increases proportionately.