Is there way to compare two DB2 schema objects (Tables, Columns, ) of Stage and Production

[debrath banerjee]

Is there way to compare two DB2 schema objects (Tables, Columns, ) of Stage and Production

We have to understand what is the difference between Production Database and Stage. What columns or Tables or any other changes missing in Production.

Help me with any solution or free version tool or query which could help.

Thanks

[Thiruswamy]

Yes, we can compare. Which version, LUW/ZOS?

[AngocA]

The only way to compare objects is by generating the DDL. The was to extract this is with db2look, but this tool generates the objects according to the creation time, thus the order could not be the same.

Also, you can extract the DDL of an object via a stored procedure. In this way, you can generate a set of objects, and then check the result.

[Jeremy Rickard]

Instead of db2look you could diff relevant columns of relevant catalog views (such as syscat.columns) using SQL EXCEPT and INTERSECT operators.

The only real problem would be collocating the data in the same database. Either you would have to import a copy to staging tables with the same structure, or maybe federate for less effort? ("maybe" since I don't recall trying, is it possible to create a nickname on a catalog view?)

By the way, I thought this forum was dead! It seems a shame that IBM have promoted StackOverflow in the Knowledge Center instead of Groups/Usenet.


Jeremy Rickard

[Thiruswamy]

There is ways to compare both DDL and Data of table on each row level also. First, we need to which version whether LUW/ZOS. There is some limitation on version level.

Rgds,
Thiru

[Andreas Lerch]

Hello

some days ago a friend sends me this link:

http://jmerrell.com/2011/06/01/db2-except-sql-function/

I don't know if thats work, but you can try

Andreas Lerch


Am 20.03.20 um 00:34 schrieb debrath banerjee: