IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Hello,
I'm looking for a DLL that will output the whole difference between two DB2 databases, do you aware of any module that applies this?
Yehuda
Tags:
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.
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
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
Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
Started by Patricia Zakhar in What's hot ? on Monday. 0 Replies 2 Likes
Now Generally AvailableIBM Db2 Analytics Accelerator Version 7.5! The latest version of the Db2 Analytics Accelerator, which delivers the highly anticipated Integrated Synchronization capability, is now generally available. The Db2 Analytics…Continue
Started by Surekha Parekh in What's hot ?. Last reply by carol Goldberg Nov 7. 1 Reply 0 Likes
Db2 for z/OS Master class with John Campbell and the SWAT team returns! June 24-28, 2019 at IBM Hursley near Winchester, UKSeptember 23-27, 2019 at IBM Silicon Valley Lab in San Jose, California…Continue
Tags: Events, MasterClass, JohnCampbell
© 2019 Created by Surekha Parekh.
Powered by