When doing an Object Compare of a full Schema, some tables are showing as being different only in terms of the COMPRESS clause i.e.
one table shows COMPRESS YES ADAPTIVE and the other table shows COMPRESS YES STATIC
When the sync script is generated, Toad is doing a DROP and reCREATE of the table, when an ALTER table would suffice.
WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for DB2 LUW
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center