To: | nv-l@lists.us.ibm.com |
---|---|
Subject: | Re: [nv-l] Switch analyzer and Oracle DB |
From: | "Christopher J Petrina" <cjp8@meadwestvaco.com> |
Date: | Wed, 17 Mar 2004 09:42:29 -0500 |
Delivery-date: | Wed, 17 Mar 2004 15:08:42 +0000 |
Envelope-to: | nv-l-archive@lists.skills-1st.co.uk |
Reply-to: | nv-l@lists.us.ibm.com |
Sender: | owner-nv-l@lists.us.ibm.com |
I have changed my ovtopmd back to using the flat files. My assumption I guess was you could use one or the other but not both, in regards tot he flat files or Database. What I would like to do is do some period dumps of information mainly SNMPMIB gathering on devices such as syslocation sysdesc, sysOID and things like that on all devices in Netview. There is a way I take it to use both flat files and database. I set the config of relational database for use with the snmpcollect information. To see if I have this right, I can use the flat files for the ovtopmd stuff, but at the same time I can use the Oracle database to store my snmpcollect information? Am I correct Thanks Chris Petrina
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@us.ibm.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@meadwestvaco.com>
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
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@us.ibm.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._______________________________________________________________ ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service._______________________________________________________________ |
<Prev in Thread] | Current Thread | [Next in Thread> |
---|---|---|
|
Previous by Date: | RE: [nv-l] Another newbie Question - SNMP vs ICMP polling (setup), John Sobrinho |
---|---|
Next by Date: | [nv-l] incorrect symbol type, Christopher J Petrina |
Previous by Thread: | Re: [nv-l] Switch analyzer and Oracle DB, Stephen Hochstetler |
Next by Thread: | Re: [nv-l] Switch analyzer and Oracle DB, Stephen Hochstetler |
Indexes: | [Date] [Thread] [Top] [All Lists] |
Archive operated by Skills 1st Ltd
See also: The NetView Web