Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2011
    Posts
    9

    Unanswered: How to compare two table layout

    Hi,

    We have 4 different schema in same database, all schema contains similar table structures but we have found some layout differences in some of table.

    Is there any command which compare table layout of same table from two difference schema?

    This is for DB2 9

    Thanks,

    rwe

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Optim Database Administrator has this feature I believe. Possibly Toad as well - check their web site.

  3. #3
    Join Date
    Sep 2006
    Posts
    97
    ODA had this option Select the schema and right click on it you have option compare schema.

    Quest Toad for db2, DBARTISA's Change manager has this option.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Or you can use db2look to generate DDL for different schemas and then do a "diff" on them.

  5. #5
    Join Date
    Jul 2011
    Posts
    9
    Thanks for reply...Currently we don't have Toad or any other tool... but getting table ddl and doing diff can give me answers..

    Thanks for your quick reply...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •