The following files in the non-SLAC '/home/iepm/v3src/mysql' directory are provided as examples of the sql that can be used to load the data bases. Note that at SLAC the dirctory is '/afs/slac/package/netmon/bandwidth-tests/v3src/mysql'.
add-fzk-node.sql
The sql template can be modified to add new nodes to the NODES table. Defaults are available for some, and if the default is accecptable, the parameter does not need to be specfied. Refer to the NODES table for current information on the fields in the table.
add-fzk-monhost.sql
This sql template can be modified to add new nodes to the MONHOST table. Note that the node must have first been added to the NODES table.
add-fzk-toolspecs.sql
This sql template is an example of how to add the toolspecs for a new node to a monitoring host TOOLSPECS table. Note that the two parameters 'src.aliasv4' and 'dst.aliasv4' must be customized to the relevant node aliases. 'src.aliasv4' is the monitoring host alias, and 'dst.aliasv4' is the target host alias. Also note that the 'datatoanalyze' and the 'tooloptn' fields must not have a carriage return in them.