Replies to This Discussion

Permalink Reply by Srinivas Adupa on May 28, 2018 at 9:21

Hey Yehuda,

First of all, comparing all the object structure is not an easy task and requires huge set of sql's and not a single one. 

You can prepare your own DML to compare parts of structure (but definitely not the whole) with any small set of sql's. 

• ▶ Reply

Permalink Reply by Yehuda shmuel on May 28, 2018 at 9:54

Thanks Srinivas,

Is there any ready utility or DLL that output the comparison result for a certain object like, table, view ,stored procedure …?  

For example db2look utility generates a DDL for a certain database for deployment but its not suggest comparison function 

• ▶ Reply

Permalink Reply by Eswar Prasad C on June 12, 2018 at 13:59

Dont think there is any utility for such a robust comparison. There are tools like IBM object comparison tool, BMC change manager, RC migrate etc to perform this compare and give u the modified DDL's

Regards

Eswar

• ▶ Reply

Permalink Reply by Ember Crooks on June 19, 2018 at 20:26

One I heard about recently for LUW, in case it helps: www.raghu-on-tech.com/2017/12/19/how-to-deep-compare-two-db2-enviro..." target="_blank">https://www.google.com/amp/s/www.raghu-on-tech.com/2017/12/19/how-to-deep-compare-two-db2-enviro...

• ▶ Reply