Chris

I think there is a way for you to get the best of both worlds. I believe that your desire is to generate reports of toplogy...and still run Switch Analyser. To make this happen, you must change your current setting so that ovtopmd goes back and uses NetView's flat files.

Before you generate your toplogy reports, clear the tables, then load a new topology snapshot. You will find that NetView runs a lot slower when working with a relational database for topology. Thus, leave ovtopmd using the flat files. This also leaves your Switch Analyser working just fine.

clear old topology ---- ovtoposql -C -v
take a snapshot -- ovtopoconv -R -v

now, run all the reports you want to. Remember that ovtopodump does not read from the database, instead use command ipgettopoinfo (see the NetView 7.1 Database Guide manual (available online). http://publib.boulder.ibm.com/tividd/td/netview/SC31-8898-00/en_US/PDF/dvil1mst.pdf

This should give you reports from topology info, a fast NetView and layer 2 info for Switch Analyser.

Stephen Hochstetler shochste AT us.ibm DOT com
International Technical Support Organization at IBM
Office - 512-838-6198 (t/l 678) FAX - 512-838-6931
http://www.redbooks.ibm.com
"Christopher J Petrina" <cjp8 AT meadwestvaco DOT com>

"Christopher J Petrina" <cjp8 AT meadwestvaco DOT com> Sent by: owner-nv-l AT lists.us.ibm DOT com 03/16/2004 04:31 PM Please respond to nv-l

To nv-l AT lists.us.ibm DOT com cc Subject Re: [nv-l] Switch analyzer and Oracle DB

I did tell ovtopmd to use the relational database. Cause I want all my data to go to the oracle database. Support says that there is an E-FIX for DB2 with regards to this and is checking to see whether or not there is an oracle fix as well. I guess my question back is why would I NOT want to change where ovtopmd sends its information. I guess I can see that not agreat deal of useful information would be held int he database with regards to topology. ie basically the only thing in the database for toppo would be node and node location within the map.
would that be a correct assumption.

-Chris

Stephen Hochstetler <shochste AT us.ibm DOT com> Sent by: owner-nv-l AT lists.us.ibm DOT com 03/16/2004 05:19 PM Please respond to nv-l

To: nv-l AT lists.us.ibm DOT com cc: Subject: Re: [nv-l] Switch analyzer and Oracle DB

Chris,

After you did the ovtopoconv -R -v I would hope that you left the configration of ovtopmd alone. In other words, you DID NOT tell ovtopmd to start using the relational database. Thus, ovtopmd is still using the flat files.

If this is the case, does your NetView come up and maps work ok? After they are up, what is the result of the ovtopdump command?

Stephen Hochstetler shochste AT us.ibm DOT com
International Technical Support Organization at IBM
Office - 512-838-6198 (t/l 678) FAX - 512-838-6931
http://www.redbooks.ibm.com
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service._______________________________________________________________