No, ODBC is an NT thing, not a UNIX thing. I thought Jeffery was very
careful in pointing out that what he had to say was about NetView for NT.
There is no default relational database in UNIX. If you want one, then you
have to buy one. And if you want to use it with NetView for UNIX, then you
will need to obtain Tivoli's RIM as well. Since there is no native
relational db in UNIX, and every one of them is different, then you either
must provide an interface tool (like RIM) or try to support the various
popular RDMS vendors in the NetView code itself. That's what was done in
version prior to Version 5, and it did not work well. The RDMS vendors
kept changing their libraries and APIs and NetView could not keep up, so it
could only support certain versions. RIM offers us more flexibility.
But without a native relational database, you must find a reporting package
designed especially for NetView's snmpCollect or trap data, whatever you
want to report on. There are several available which have been mentioned
on this forum before (Tavve has one, Empire has one, and there are others).
James Shanks
Tivoli (NetView for UNIX) L3 Support
Ziyad A Choudhury <ziyad@US.IBM.COM> on 10/14/98 11:33:42 AM
Please respond to Discussion of IBM NetView and POLYCENTER Manager on
NetView et alia <NV-L@UCSBVM.UCSB.EDU>
To: NV-L@UCSBVM.UCSB.EDU
cc: (bcc: James Shanks)
Subject: Re: snmpcdmp (snmpColDump)
Hi there,
This ODBC solution for Netview/ NT does it also apply to other versions for
UNIX for example AIX 4.2. I mean does the system also save the data in ODBC
format and can I also access the data via crystal reports.......
Rgds
Ziyad Choudhury
B 965 / 1L-07
522 South Rd.
Poughkeepsie, NY 12601
Systems Management Integrator
Network Architecture and Planning, Service Delivery Center - North
IBM Global Services
Certified Netware Engineer
E-Mail:: ZIYAD@US.IBM.COM
Phone: ( 914) -433-1124
Pager: 1-800-759-8352 Pin 1772452
---------------------- Forwarded by Ziyad A Choudhury/Southbury/IBM on
10/14/98
11:24 AM ---------------------------
NV-L@UCSBVM.UCSB.EDU on 10/14/98 11:04:46 AM
Please respond to NV-L@UCSBVM.UCSB.EDU
To: NV-L@UCSBVM.UCSB.EDU
cc:
Subject: Re: snmpcdmp (snmpColDump)
Vince Rosso@TRANSALTA
14/10/98 08:48 AM
This sounds great if you're running Netview on NT, but in our shop at this
time they are sticking with Netview on DIgital UNIX. Are there as many
varied and simple solutions in the UNIX environment?
(Embedded
image moved Jeffrey_Snover@TIVOLI.COM
to file: 10/14/98 06:27 AM
pic10578.pcx)
Please respond to Discussion of IBM NetView and POLYCENTER Manager on
NetView et alia <NV-L@UCSBVM.ucsb.edu>
To: NV-L@UCSBVM.ucsb.edu
cc: (bcc: Vince Rosso)
Subject: Re: snmpcdmp (snmpColDump)
>I think we all have the same problem producing reports. The easiest way
>to produce reports from routers seems to be mrtg
With NetView/NT, the collected SNMP data is stored directly into a
relational database.
As such, you can use most any reporting tool to directly access the data
via ODBC. Crystal
Reports works just fine using this technique. Also remember that you have
the NVDBEXPORT
command. This is a meta-data driven export program that moves OVWDB data
into
a set of relational database tables. There are a set of defaults but it is
meta-data driven
so if you don't like the tables we create or the fields we export - just
change them.
So now you can get Topo data, OVWDB data, SNMP collect data, and Event data
in
relational databases and spend a couple hundred dollars to get a superstar,
off-the-shelf reporting package to access this data directly. Go for it.
Jeffrey
PS: What is MRTG?
pic10578.pcx
Description: Binary data
|