To be honest, I wouldn't do this in perl. I would do this in the database. You could probably federate the bunch of them and do some sort of SELECT COUNT(*) FROM T1 WHERE PRIMKEY NOT IN (SELECT PRIMKEY FROM T2, T3, T4, T5, T6, T7) or something. But that's probably not really fast either.

Instead, invest in replication technology if your vendor doesn't come with any by default. (I know DB2 has replication technology, but I think it's an add-on cost.) And get that vendor to show you how to be convinced that everything is synchronised. If you're doing this for high-availability (doesn't sound like it - 6 fail-over servers seems a bit high), then invest in HA data replication (HADR) and set it up - and, again, ask your vendor to prove it's working (or at least to show you how to prove it's working).

I'm sure you could do this in perl. But I wouldn't. And I use perl for almost everything - just ask my teammates.

In reply to Re: Comparing tables over multiple servers by Tanktalus
in thread Comparing tables over multiple servers by mnlight

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.