If I have a partitioned table (range partition), does the UPDATE statement change the physical storage of a record if partition key was changed by the UPDATE statement? I.e., does the affected record physically move out the old page, and will be inserted into the new page which belongs to partition 2?
For example, if I create a table PRODUCT which is partitioned by product id and it has two partitions: partition 1 has product id from 0 to 100, and partition 2 has all the left. I have a record which has product id = 30 which should be in partition 1. I then update that record by change that product id to 200 which should bring the record into different partition. My question is: does the UPDATE statement will move the record from its original page and move it into a page which belongs to partition 2? Or DB2 have a different mechanism which do not need physically change this affected record?
Could anyone provide any link which has details or the way to verify it?