nv-l
[Top] [All Lists]

Re: [nv-l] NetView 7.1.3 ignores MS SQL server

To: nv-l@lists.us.ibm.com
Subject: Re: [nv-l] NetView 7.1.3 ignores MS SQL server
From: James Shanks <jshanks@us.ibm.com>
Date: Tue, 24 Feb 2004 16:15:40 -0500
Delivery-date: Tue, 24 Feb 2004 21:23:57 +0000
Envelope-to: nv-l-archive@lists.skills-1st.co.uk
In-reply-to: <001b01c3f98e$bb404710$7a6c14d4@kovar>
Reply-to: nv-l@lists.us.ibm.com
Sender: owner-nv-l@lists.us.ibm.com

Unfortunately  you cannot use SQL Server with NetView for Windows unless the SQL Server is both installed and running at the time of the NetView install.  The proper schemas and so on are only created at install time.

There is no way to cause NetView to switch to SQL Server after the fact.  So you will have to re-install NetView to use it, if it was not available before.   And there is no provision for anything remote.  

NetView topology is not kept in the SQL databases by default, though traps are, because NetView for Windows does not use an RDBMS for topology data himself .  Internally it uses the same spares file structure as the UNIX version.  You can look in the \usr\ov\databases\odbc directory and see which relational databases are populated.

The utility nvdbexport is used to export data to an SQL Server database for further analysis or report generation.  It is not a way to cause NetView to use the SQL server instead of Access.  Per the NetView User's Guide, the definition for nvdbexport states:

This utility exports the NetView object database into an SQL database for either Microsoft Access or Microsoft SQL Server. You can either export the entire database into a set of tables, or use the configuration file to customize the table formats and populate them with entries based on rules. For example, you can create a table containing just the critical nodes and relevant fields, such as IP Hostname and sysContact. Then use an SQL report writer to generate reports.

Hope this helps


James Shanks
Level 3 Support  for Tivoli NetView for UNIX and Windows
Tivoli Software / IBM Software Group



"Libor Kovar" <kovar@gcsystem.cz>
Sent by: owner-nv-l@lists.us.ibm.com

02/22/2004 04:56 PM
Please respond to
nv-l

To
<nv-l@lists.us.ibm.com>
cc
Subject
[nv-l] Netview 7.1.3 ignores MS SQL server





Hello,
could someone advice me with this please ?

We installed Netview 7.1.3 on Windows 2000 server, where MS SQL server was installed locally before for that purpose.
It should therefore use MS SQL for storing data.
The install log says , SQL database was created succesfully,
but Netview seems not to use it, because after topology discovery, SQL databases  remain empty.
(Despite of that fact, Netview seems to work properly).

Further, can I tell Netview to use ODBC connection to remote MS SQL server later ?

Many thanks
Libor Kovar



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

Archive operated by Skills 1st Ltd

See also: The NetView Web