Page History

The Guthrie NODEDETAILS table contains a list of all the nodes involed involved in PingER analysis done from SLAC.  It is stored in the SLACPROD Oracle instance IEPM.NODEDETAILS under the IEPM user/schema.

...

...

Inside the UI, the country and continent (region) are set and restricted to a pop-up list of values. The pop-up list is based on a separate table called COUNTRY. New countries can be added to the list by creating new rows in the COUNTRY table with SQL INSERT statements. See Updating NODEDETAILS with SQLPlus

Example:

SQL> insert into country (country_id, country, continent, tld)
  2  values (country_seq.nextval, 'Bermuda', 'Latin America', 'bm');
1 row created.
SQL> commit;
Commit complete;
SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning and Real Application Testing options
52cottrell@pinger:~>

The COUNTRY table is not used except by the list of values values in the UI. Note that if a country name needs to be changed or if a country was placed in the wrong region, it must be updated on all the nodes in the NODEDETAILS table as well as on the COUNTRY table.

To update the COUNTRY table to fix the list of values, get the COUNTRY_ID for the location that needs correction:

select country_id, country, continent from country
where country like 'Demo%';

Then update the COUNTRY table:

update country set country = 'Democratic Republic of Congo'
where country_id = 461;

Finally fix any incorrect entries in the actual NODEDETAILS table by putting the correct country in the set clause and the incorrect value in the where clause.

update nodedetails set country = 'Democratic Republic of Congo'
where country = 'Democratic Repulic of Congo';

To re-assign a country from one region to another, change the CONTINENT value in both tables.

update country set continent = 'Europe' where country = 'Latvia';

update nodedetails set continent = 'Europe' where country = 'Latvia';

...