I need to update a field in a table, there is an index on this field, which is not primary key.
So i decide to deactivate this index, in order to perform faster update.

seems, 2 millions records i can update around half an hour, it is ok, but when i try to enable this index, even i set pdqpriority 100, it still take too long time, any other configuration i should take into account?

if your version of IDS is 10.uc5 you can alter you table to RAW with index enabled... but caution, your updates will not be write in logical log. Your updates will be execute faster....

"RAW tables do not support referential constraints, unique constraints, and rollback."
read more about RAW tables here: http://publib.boulder.ibm.com/infoce...c/admin330.htm

thank you, unluckily the version is below 10. but it is good to know.