Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    4

    Unanswered: DB2 database validation

    Hello,

    I am moving one database from one machine to another, what I want to do after this move is done, is to validate that all the data and tables are exactly the same in the new and old database, does anyone know of a good tool and or command to compare two DB2 databases.

    Thanks,
    Dak

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    What I did:
    - run your reports. They must be the same
    - random queries: bring everything back to numbers and summarize & compare (i.e. summarize all the "length of" some varchar columns). The result is nonsence, but shoud be exacly the same in both databases.
    - smart "greps" on your extract & load reports. Exclude all good-messages until you are left with an readable error-report. I mean: exclude all "rejected 0" messages you you'll see if there are any rejected rows.

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Are you using a back up image, or export/import? If it is backup image I would doubt you are going to have any problems. But like Dr_te said, run reports before and after.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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