nv-l
[Top] [All Lists]

Re: [nv-l] Switch analyzer and Oracle DB

To: nv-l@lists.us.ibm.com
Subject: Re: [nv-l] Switch analyzer and Oracle DB
From: Stephen Hochstetler <shochste@us.ibm.com>
Date: Tue, 16 Mar 2004 16:55:29 -0600
Delivery-date: Tue, 16 Mar 2004 23:12:13 +0000
Envelope-to: nv-l-archive@lists.skills-1st.co.uk
In-reply-to: <OF1DE092B7.B995CD04-ON85256E59.007B8B0A-85256E59.007BC27A@mead.com>
Reply-to: nv-l@lists.us.ibm.com
Sender: owner-nv-l@lists.us.ibm.com

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
Inactive hide details for "Christopher J Petrina" <cjp8@meadwestvaco.com>"Christopher J Petrina" <cjp8@meadwestvaco.com>


          "Christopher J Petrina" <cjp8@meadwestvaco.com>
          Sent by: owner-nv-l@lists.us.ibm.com

          03/16/2004 04:31 PM
          Please respond to
          nv-l


To

nv-l@lists.us.ibm.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@us.ibm.com>
Sent by: owner-nv-l@lists.us.ibm.com

03/16/2004 05:19 PM
Please respond to nv-l


To: nv-l@lists.us.ibm.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@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._______________________________________________________________


GIF image

<Prev in Thread] Current Thread [Next in Thread>

Archive operated by Skills 1st Ltd

See also: The NetView Web