In my view the short answer to this question is "yes" and the long answer is
(supposed to be) "at least as much as the UNIX version does, and more because
events are kept there by default, in whatever RDBMS your SQL Server/ ODBC
drivers support". At least that is how I understand it, and because I am a
real rookie with NT, ODBC and all that, I urge all those users familiar with
that stuff to respond.
1. Events on NT are kept in a relational database, either MS-Access (the
default) or whatever RDBMS your SQL Server on NT is configured for. There was
a problem with using SQL Server at 5.1.1 when it came time to do a purge, so
some users stopped doing that and went back to MS-Access. But this problem has
been fixed and an efix is available from Support if you need it.
2. You can manually load topology up to that RDBMS any time you want, according
to my notes, by using the topo2sql.exe
You can also do this from the GUI: Programs --> NetView --> Tasks --> Export
Topology, and the you can view it.
You can also automate the topo upload with the "at" command I am told.
3. I thought there was a similar command to upload snmpCollect data too (so that
the NT product would at least as much functionality as the UNIX one with regard
to RDBMS) but as I don't deal with this on a regular basis, I cannot confirm
that now.
Anyone else tried this? Want to look in /usr/ov/bin for a likely executable?
I could be wrong here but I urge you to go look first.
I know the User's Guide is very deficient in this area but development decided,
when they could not get additional resources for documentation updates for 5.1,
that they would provide function anyway, and try to address the lack of doc in
the next one (5.2??). Some of this function was even available in 5.0a I
believe.
James Shanks
Tivoli (NetView for UNIX) L3 Support
Xu He <xuhe@YAHOO.COM> on 07/09/99 08:25:13 AM
Please respond to Discussion of IBM NetView and POLYCENTER Manager on NetView
<NV-L@UCSBVM.UCSB.EDU>
To: NV-L@UCSBVM.UCSB.EDU
cc: (bcc: James Shanks/Tivoli Systems)
Subject: Re: Does Netview 5.1.1 on NT support RDBMSes???
Unfortunately, I have the answer you probably don't
want to hear. For the main databases under
\usr\ov\databases\openview, the format for the ovwdb,
topology, and mapdb is the same as the older versions.
I did remember hearing from someone that it's still
in Btrieve format. However, the event database is in
RDBMS Compliant, it can be in either Access or MS SQL
format. I think Tivoli was trying to convert the
database to RDBMS, from the two other DSN (snmpcollect
and Topology) it created in Windows ODBC Settings. I
did query the those DSNs and notice it was empty. In
theory, I think you can write the event database to
another RDBMS, but I haven't tested it. With the
current version, I think the default MS Access
database is sufficient for storing the events.
Xu He
--- Don Seitz <don_seitz@INS.COM> wrote:
> I have been asked, and cannot find it specifically
> written out, but does
> Netview 5.1.1 on NT support any relational
> databases, like: Oracle,
> Sybase...etc?????
>
> Thanks for your clarification
> Don Seitz
>
===
Xu He
Consulting Services Engineer
Network Solutions, Inc
http://www.netsol.com/consulting
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
|