DB consistancy checking tools

On Fri, Mar 03, 2000 at 12:42:00PM +0100, Thor-Henrik Kvandahl wrote:
> 
> Hi Matthew.
> 
> Can I congratulate with a son or daughter now ?
> 
> Here are some ideas to a future Task Force.
> 
> I have some ideas about consistency in the Ripe Whois DB and in the LIRs
> own assignment files/DB, and also in between them. If we want to come up
> with some tools/hints for LIR's to keep on top of their entries, I suggest
> that we also include tools/hints to check the consistency between the LIRs
> own assignment files/DB and the Ripe Whois DB. One way to do this is to
> download the inetnum db from ftp.ripe.net, extract the LIRs inetnums,
> do a consistency check of the inetnums, and finally do a consistency check
> between the inetnums and the assignment files/DB (and why not do a
> consistency check between the inetnums and all customer routes ?).
> 
> I guess there are not many LIRs doing this today (except us). The drawback
> with this solution is that we have to download the whole inetnum db 
> (12,5Mb) and extract all our inetnums.
> 
> Here's an idea that belongs to the db-gw, but it is related to the idea
> described above: To ease the load on the RIPE NCC ftp/whois server and our
> servers, any LIR should be able to request an automatic extract every 24
> hours of their allocated blocks.

This command will extract all more specific objects under 148.122/16:

whois -h whois.ripe.net -F -r -T inetnum -M 148.122/16

Xystein Nerhus, KPNQwest Norway