In my case (DB2 9.7.0.2) liquibase runs successfully for the following changeset:
<modifyDataType tableName="ATABLE" columnName="ACOLUMN" newDataType="DECIMAL(23, 4)" />
Nevertheless, it doesn't add REORGs when running updateSQL. This changeSet should work without them on DB2 9.5, but will most likely fail on 9.7 (REORG has to be called every three alter statements).
linux
Duplicate of