As part of the work we are doing with the ripe-81 database format and tools we have been looking at various aspects of the RIPE database as it stands as compared to what we see within the "real world" (in this case we use the BGP routing table of Amsterdam-EBS1.ebone.net) in terms of autonoumous system numbers. We have a program that generates lists of networks assigned to an AS currently in the database and also one that will "on the fly" do the same thing for a cisco BGP routing table. We have found some interesting results and some we wish to share with you at this stage to maybe get some of this corrected. We compared the BGP derived information with what is in the database. Obviously, a lot of non-Europe routes are not in the database so these are not flagged. The main things of interest are the following. 1) networks in the database flagged as LOCAL and being routing. Can the providers look at these please. Often, people forget to update there entry when they start routing them. 2) networks having an existing AS-number in database but reflected differently in the routing tables (the can sometimes be a config error, even typos in databse ny the looks of it). 3) networks being routed but not yet allocated (here we only look at 193 networks). Please check if you forgot to send in an update/assignment. 4) networks in BGP routing tables with more than more originating AS. These need to be look at and configured accordingly. See Section 5 on Autonomous systems in ripe-81 for reasoning as to why these should only originate in one AS. We intend soon to generate this information daily on our ftp archive for both the database information and router derived information. We will have a more extensive progress report fairly soon as the various other aspects of the ripe-81 work including a "call for policy" information. However, work is progressing extremely well. Sorry if the distribution is quite large but I feel there is information that has relevence to all these groups in the mail. --Tony Bates, RIPE NCC 1) networks in the database flagged as LOCAL and being routing 141.22.0.0 is flagged LOCAL (database) and announced by AS1275 (BGP) 141.56.0.0 is flagged LOCAL (database) and announced by AS517 (BGP) 145.41.0.0 is flagged LOCAL (database) and announced by AS1103 (BGP) 146.105.0.0 is flagged LOCAL (database) and announced by AS1849 (BGP) 164.15.0.0 is flagged LOCAL (database) and announced by AS2111 (BGP) 192.12.54.0 is flagged LOCAL (database) and announced by AS1103 (BGP) 192.16.183.0 is flagged LOCAL (database) and announced by AS1104 (BGP) 192.16.183.0 is flagged LOCAL (database) and announced by AS1890 (BGP) 192.26.121.0 is flagged LOCAL (database) and announced by AS790 (BGP) 192.36.33.0 is flagged LOCAL (database) and announced by AS1653 (BGP) 192.36.34.0 is flagged LOCAL (database) and announced by AS1653 (BGP) 192.36.149.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.70.55.0 is flagged LOCAL (database) and announced by AS701 (BGP) 192.70.56.0 is flagged LOCAL (database) and announced by AS701 (BGP) 192.71.15.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.71.28.0 is flagged LOCAL (database) and announced by AS1729 (BGP) 192.71.39.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.71.85.0 is flagged LOCAL (database) and announced by AS1729 (BGP) 192.71.168.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.71.194.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.76.147.0 is flagged LOCAL (database) and announced by AS1270 (BGP) 192.83.13.0 is flagged LOCAL (database) and announced by AS544 (BGP) 192.84.13.0 is flagged LOCAL (database) and announced by AS1930 (BGP) 192.84.15.0 is flagged LOCAL (database) and announced by AS1930 (BGP) 192.102.158.0 is flagged LOCAL (database) and announced by AS517 (BGP) 192.108.72.0 is flagged LOCAL (database) and announced by AS786 (BGP) 192.121.25.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.121.70.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.121.163.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.124.249.0 is flagged LOCAL (database) and announced by AS1275 (BGP) 192.129.8.0 is flagged LOCAL (database) and announced by AS786 (BGP) 192.133.1.0 is flagged LOCAL (database) and announced by AS760 (BGP) 192.138.204.0 is flagged LOCAL (database) and announced by AS1930 (BGP) 192.165.173.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.165.191.0 is flagged LOCAL (database) and announced by AS1257 (BGP) 192.173.65.0 is flagged LOCAL (database) and announced by AS760 (BGP) 193.59.1.0 is flagged LOCAL (database) and announced by AS1887 (BGP) 193.59.8.0 is flagged LOCAL (database) and announced by AS1887 (BGP) 193.59.9.0 is flagged LOCAL (database) and announced by AS1887 (BGP) 193.59.10.0 is flagged LOCAL (database) and announced by AS1887 (BGP) 193.59.11.0 is flagged LOCAL (database) and announced by AS1887 (BGP) 193.63.65.0 is flagged LOCAL (database) and announced by AS786 (BGP) 193.84.60.0 is flagged LOCAL (database) and announced by AS1902 (BGP) 193.84.61.0 is flagged LOCAL (database) and announced by AS1902 (BGP) 193.87.96.0 is flagged LOCAL (database) and announced by AS1922 (BGP) 193.96.9.0 is flagged LOCAL (database) and announced by AS1270 (BGP) 193.96.10.0 is flagged LOCAL (database) and announced by AS1270 (BGP) 193.96.11.0 is flagged LOCAL (database) and announced by AS1270 (BGP) 193.98.97.0 is flagged LOCAL (database) and announced by AS1270 (BGP) 193.166.24.0 is flagged LOCAL (database) and announced by AS1739 (BGP) 193.166.25.0 is flagged LOCAL (database) and announced by AS1739 (BGP) 193.166.31.0 is flagged LOCAL (database) and announced by AS1741 (BGP) 2) networks having an existing AS-number in database but reflected differently in the routing tables (the can sometimes be a config error). 128.86.0.0 in AS786 (database) and AS1755 (BGP) 128.130.0.0 in AS697 (database) and AS679 (BGP) 131.130.0.0 in AS590 (database) and AS760 (BGP) 131.173.0.0 in AS590 (database) and AS1754 (BGP) 132.146.0.0 in AS1752 (database) and AS1290 (BGP) 132.165.0.0 in AS590 (database) and AS777 (BGP) 132.166.0.0 in AS590 (database) and AS777 (BGP) 132.167.0.0 in AS590 (database) and AS777 (BGP) 132.168.0.0 in AS590 (database) and AS777 (BGP) 132.230.0.0 in AS553 (database) and AS1754 (BGP) 134.47.0.0 in AS1770 (database) and AS224 (BGP) 134.214.0.0 in AS590 (database) and AS789 (BGP) 138.70.0.0 in AS137 (database) and AS1717 (BGP) 139.92.0.0 in AS590 (database) and AS1754 (BGP) 139.128.0.0 in AS137 (database) and AS1717 (BGP) 139.191.0.0 in AS1267 (database) and AS1717 (BGP) 139.191.0.0 in AS1267 (database) and AS559 (BGP) 140.77.0.0 in AS590 (database) and AS789 (BGP) 141.28.0.0 in AS174 (database) and AS517 (BGP) 141.43.0.0 in AS1324 (database) and AS517 (BGP) 141.47.0.0 in AS174 (database) and AS517 (BGP) 141.54.0.0 in AS1324 (database) and AS517 (BGP) 141.137.0.0 in AS137 (database) and AS1717 (BGP) 143.169.0.0 in AS590 (database) and AS1717 (BGP) 143.205.0.0 in AS760 (database) and AS1111 (BGP) 143.224.0.0 in AS760 (database) and AS2036 (BGP) 146.110.0.0 in AS760 (database) and AS2012 (BGP) 147.196.0.0 in AS1899 (database) and AS1717 (BGP) 151.89.0.0 in AS1267 (database) and AS1717 (BGP) 151.90.0.0 in AS1267 (database) and AS1717 (BGP) 153.96.0.0 in AS1324 (database) and AS517 (BGP) 153.97.0.0 in AS1324 (database) and AS517 (BGP) 156.18.0.0 in AS590 (database) and AS789 (BGP) 157.24.0.0 in AS1714 (database) and AS1741 (BGP) 158.152.0.0 in AS1849 (database) and AS1290 (BGP) 159.84.0.0 in AS1717 (database) and AS789 (BGP) 160.103.0.0 in AS1717 (database) and AS789 (BGP) 161.3.0.0 in AS590 (database) and AS789 (BGP) 161.41.0.0 in AS1923 (database) and AS719 (BGP) 192.12.193.0 in AS137 (database) and AS513 (BGP) 192.35.150.0 in AS1274 (database) and AS1275 (BGP) 192.41.218.0 in AS137 (database) and AS1717 (BGP) 192.42.143.0 in AS174 (database) and AS1754 (BGP) 192.44.2.0 in AS174 (database) and AS517 (BGP) 192.44.11.0 in AS174 (database) and AS517 (BGP) 192.44.15.0 in AS174 (database) and AS517 (BGP) 192.44.32.0 in AS174 (database) and AS517 (BGP) 192.44.33.0 in AS174 (database) and AS517 (BGP) 192.44.34.0 in AS174 (database) and AS517 (BGP) 192.44.35.0 in AS1324 (database) and AS517 (BGP) 192.54.104.0 in AS174 (database) and AS517 (BGP) 192.54.197.0 in AS590 (database) and AS789 (BGP) 192.55.105.0 in AS2004 (database) and AS1890 (BGP) 192.58.53.0 in AS1741 (database) and AS544 (BGP) 192.65.184.0 in AS513 (database) and AS1755 (BGP) 192.65.185.0 in AS513 (database) and AS1755 (BGP) 192.70.69.0 in AS789 (database) and AS513 (BGP) 192.70.89.0 in AS1899 (database) and AS1717 (BGP) 192.70.90.0 in AS1899 (database) and AS1717 (BGP) 192.76.246.0 in AS1274 (database) and AS1755 (BGP) 192.82.157.0 in AS760 (database) and AS1112 (BGP) 192.92.104.0 in AS137 (database) and AS1717 (BGP) 192.92.105.0 in AS137 (database) and AS1717 (BGP) 192.92.106.0 in AS137 (database) and AS1717 (BGP) 192.93.155.0 in AS590 (database) and AS789 (BGP) 192.101.28.0 in AS174 (database) and AS517 (BGP) 192.102.147.0 in AS1324 (database) and AS517 (BGP) 192.102.176.0 in AS1324 (database) and AS517 (BGP) 192.106.1.0 in AS1267 (database) and AS1717 (BGP) 192.106.207.0 in AS1267 (database) and AS1717 (BGP) 192.106.217.0 in AS1267 (database) and AS1717 (BGP) 192.106.222.0 in AS1267 (database) and AS1717 (BGP) 192.106.223.0 in AS1267 (database) and AS1717 (BGP) 192.106.228.0 in AS1267 (database) and AS1717 (BGP) 192.106.229.0 in AS1267 (database) and AS1717 (BGP) 192.106.235.0 in AS1267 (database) and AS1717 (BGP) 192.106.239.0 in AS1267 (database) and AS1717 (BGP) 192.106.240.0 in AS1267 (database) and AS1717 (BGP) 192.106.244.0 in AS1267 (database) and AS1717 (BGP) 192.106.249.0 in AS1267 (database) and AS1717 (BGP) 192.106.250.0 in AS1267 (database) and AS1717 (BGP) 192.134.29.0 in AS590 (database) and AS789 (BGP) 192.134.91.0 in AS1899 (database) and AS1717 (BGP) 192.153.173.0 in AS1853 (database) and AS1755 (BGP) 193.1.192.0 in AS2110 (database) and AS1213 (BGP) 193.1.193.0 in AS2110 (database) and AS1213 (BGP) 193.48.8.0 in AS590 (database) and AS777 (BGP) 193.48.137.0 in AS1717 (database) and AS789 (BGP) 193.48.140.0 in AS1717 (database) and AS789 (BGP) 193.48.145.0 in AS1717 (database) and AS789 (BGP) 3) networks being routing but not yet allocated (here we only look at 193 networks). 193.0.0.0 not in database 193.0.1.0 not in database 193.0.2.0 not in database 193.0.4.0 not in database 193.0.5.0 not in database 193.59.44.0 not in database 193.59.45.0 not in database 193.59.46.0 not in database 193.59.47.0 not in database 193.61.100.0 not in database 193.61.101.0 not in database 193.64.34.0 not in database 193.68.160.0 not in database 193.74.254.0 not in database 193.84.50.0 not in database 193.84.51.0 not in database 193.112.27.0 not in database 193.120.248.0 not in database 193.128.85.0 not in database 193.166.40.0 not in database 193.166.64.0 not in database 193.166.66.0 not in database 193.196.9.0 not in database 4) networks in BGP routing tables with more than more originating AS. *** conflict 129.247.0.0 in AS1270 *** conflict 129.247.0.0 in AS1275 *** conflict 134.93.0.0 in AS1270 *** conflict 134.93.0.0 in AS1754 *** conflict 134.104.0.0 in AS1270 *** conflict 134.104.0.0 in AS1754 *** conflict 134.106.0.0 in AS1270 *** conflict 134.106.0.0 in AS1754 *** conflict 134.107.0.0 in AS1270 *** conflict 134.107.0.0 in AS1754 *** conflict 134.222.0.0 in AS286 *** conflict 134.222.0.0 in AS701 *** conflict 138.199.0.0 in AS1104 *** conflict 138.199.0.0 in AS1270 *** conflict 139.191.0.0 in AS1717 *** conflict 139.191.0.0 in AS559 *** conflict 141.2.0.0 in AS1275 *** conflict 141.2.0.0 in AS1754 *** conflict 147.196.0.0 in AS1717 *** conflict 147.196.0.0 in AS1899 *** conflict 148.6.0.0 in AS1955 *** conflict 148.6.0.0 in AS513 *** conflict 158.152.0.0 in AS1290 *** conflict 158.152.0.0 in AS1849 *** conflict 159.72.0.0 in AS1257 *** conflict 159.72.0.0 in AS1729 *** conflict 192.16.183.0 in AS1104 *** conflict 192.16.183.0 in AS1890 *** conflict 192.16.188.0 in AS1103 *** conflict 192.16.188.0 in AS1755 *** conflict 192.16.189.0 in AS1103 *** conflict 192.16.189.0 in AS1104 *** conflict 192.16.192.0 in AS1104 *** conflict 192.16.192.0 in AS786 *** conflict 192.42.129.0 in AS1103 *** conflict 192.42.129.0 in AS1104 *** conflict 192.70.89.0 in AS1717 *** conflict 192.70.89.0 in AS1899 *** conflict 192.70.90.0 in AS1717 *** conflict 192.70.90.0 in AS1899 *** conflict 192.87.4.0 in AS1104 *** conflict 192.87.4.0 in AS1755 *** conflict 192.124.28.0 in AS1275 *** conflict 192.124.28.0 in AS1754 *** conflict 192.134.91.0 in AS1717 *** conflict 192.134.91.0 in AS1899