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
|