Guys,
There has been some talking about this TDS product several time on the list
and each time it was said that it is in end of life.
Is it still available ? What exactly does it do ?
if the product is end of life, what is the replacement ?
Here is what I need to accomplish:
1)
I need to generate report on the "availability" of the devices on the
network. Basically we need to know how long time each device was
Down/Unreachable each month. A nice to have would be to report on
"services" being down instead of just devices. That mean if only one of two
redundant box is down at a time then there is no outage and it should not
be reported.
I saw the email from Leslie a few days ago on the subject and I was
wondering if the solution really is to develop a script to analyse the
trapd.log and generate a report.
Is there no Tivoli tools to do that ?
does someone have an existing script that he would share ?
2)
I also need to report on latency on the network. I could of course build a
script that ping each device every 10 minutes or so. But it would do the
same that Netview is already doing..... did somebody experiment in
extracting that information from Netview ?
I see that the netmon.trace contain the date each ping is sent and received
....
Thanks,
Salutations, / Regards,
Francois Le Hir
Network Projects & Consulting Services
IBM Global Services
Phone: (514) 205 6695
----------------------------------------------------------------------------------------------------------
Date: Tue, 19 Nov 2002 20:07:44 +0200
To: nv-l@lists.tivoli.com,
"'tme10@lists.tivoli.com'"
<tme10@lists.tivoli.com>
From: =?ISO-8859-9?Q?Serkan_D=F6len?= <Serkan.Dolen@isbank.com.tr>
Subject: [TDS] Netview guides with DB2
Message-ID: <A8CFD244D41C7D438C324B6AB4B2EFCA05A072@ANKSGBIMW2KSN01>
Hi all
Sorry, I couldn't decide wihich list is more suitable so I posted to both
of
them.
I try to get availability data graphs from TDS with Netview Guides. We
received a fix from support for Netview Guides to use them with DB2.
The fix only replaces cubes.mdb, availhelper.exe and smartsetpopunix.exe.
I got error (part of it is below) while using availhelper.exe on availdata
files. I am not sure what to do next. Is availhelper.exe is corrupted
somehow or my tables.
I thought perhaps somebody had experience about this matter.
Running availability helper
SQLDriverConnect got status 1 (DSN=netview_db2;APP=Tivoli NetView
availHelper;UID=netview;PWD=netview,DSN=NETVIEW_DB2;UID=netview;PWD=netview;
DBALIAS=NETVIEW;)
(ConnectToODBC) snmpodbc: Information connecting to data source. 1.
[IBM][CLI Driver] CLI0004W Invalid connection string attribute.
SQLSTATE=01S00 szDSN is DB2CLI.DLL
select on netview.uptimeTransTable got 1
(tableExists) select call 1. [IBM][CLI Driver] CLI0005W Option value
changed. SQLSTATE=01S02 tables do not exist
executing CREATE TABLE netview.uptimeSummaryTable(dbKey int, nodeName
VARCHAR (60), ipAddress int default 0, stateStartTime datetime) got
status:-1
(createTables) select call 1. [IBM][CLI Driver][DB2/6000] SQL0204N
"DATETIME" is an undefined name. SQLSTATE=42704 executing CREATE TABLE
netview.uptimeSummaryTable(dbKey int, nodeName VARCHAR (60), ipAddress int
default 0, stateStartTime date) got status:-1
(createTables) select call 1. [IBM][CLI Driver][DB2/6000] SQL0601N The
name of the object to be created is identical to the existing name
"NETVIEW.UPTIMESUMMARYTABLE" of type "TABLE". SQLSTATE=42710 executing
CREATE TABLE netview.uptimeTransTable(ipAddress int default 0, upOrDown int
default 0, timeStart date, timeStop date, id int) got status:-1
(createTables) select call 1. [IBM][CLI Driver][DB2/6000] SQL0601N The
name of the object to be created is identical to the existing name
"NETVIEW.UPTIMETRANSTABLE" of type "TABLE". SQLSTATE=42710 calling
odbcNodeCameBackUp
calling odbcNodeWentDown
(odbcNodeChangedState) odbcNodeChangedState: Error updating record to
hstmtNetmonTrans a1f4e01 1. [IBM][CLI Driver][DB2/6000] SQL0180N The
syntax of the string representation of a datetime value is incorrect.
SQLSTATE=22007 calling odbcNodeCameBackUp
calling odbcNodeCameBackUp
calling odbcNodeWentDown
(odbcNodeChangedState) odbcNodeChangedState: Error updating record to
hstmtNetmonTrans a1f4e01 1. [IBM][CLI Driver][DB2/6000] SQL0180N The
syntax of the string representation of a datetime value is incorrect.
SQLSTATE=22007 calling odbcNodeCameBackUp
calling odbcNodeWentDown
(odbcNodeChangedState) odbcNodeChangedState: Error updating record to
hstmtNetmonTrans a1f4e01 1. [IBM][CLI Driver][DB2/6000] SQL0180N The
syntax of the string representation of a datetime value is incorrect.
SQLSTATE=22007 calling odbcNodeWentDown
Thanks
Regards
Serkan Dolen
T. Isbank
|