One of the easiest ways is start with select count(*) on each table, if the
counts are different, so are the tables.

After that unload each table and compare using dff or if on the mainframe a
compare utility.

Michael Vanner



"Parry Colin "
<db2udbdba-ezmlms
hield-x1183648.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
03/23/2007 11:15
AM Fax to

Subject
Comparing DB2 tables ??










Does anybody know how we can compare the contents of two DB2 tables ??

Regards

Colin

> *Colin Parry
> GIS/TS/DBAs
> Computer Centre, Bootle
> *int: (8810) 3961
> *ext: 0151-966 3961
> *fax: 0151-966 2913
> * e-mail: colin.[Email address protected]
>
>


ALLIANCE & LEICESTER PLC - IMPORTANT NOTICE:

This communication, and the information it contains
a) is intended for the addressee named above and for no other person or
organisation, and
b) may be confidential and/or legally privileged and/or protected in law.

Access to this communication by anyone other than the addressee is
unauthorised. Unauthorised use, copying or disclosure of all or part of
this communication
is strictly prohibited and may be unlawful.

Unless the contrary is clear from its context, this communication does not
create or modify any contract.

If you are not the intended recipient, please contact the sender
immediately
by return e-mail and destroy all copies of this communication.

This communication may contain personal data. If so, you are required to
observe the provisions of any relevant data protection legislation in any
processing of such data.

Although this company has taken reasonable steps to ensure that this
communication and any attachments are free from computer virus, you are
advised to take your own steps to ensure that they are actually virus free.

Alliance & Leicester plc is authorised and regulated by the Financial
Services Authority. Our FSA register number is 189099.

Alliance & Leicester plc, Registered office : Carlton Park, Narborough,
Leicester LE19 0AL.
Company No: 3263713. Registered in England.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





------------------------------------------------------------------------------
This email is confidential.
If you are not the intended recipient, please notify
the sender by return email and delete this message
from your mail box without reading or copying it or
any attachments. While Lombard Canada Ltd. runs
anti-virus software on all servers and all PCs, it
cannot be held responsible for any infected files that
you may receive. Lombard Canada Ltd. advises all
recipients to virus scan any file attachments.
==============================================================================


DB2 & UDB email list listserv db2-l LazyDBA home page