RE: [nv-l] TDW Blank Reports!!!
2006-05-05 12:31:01
Guys, the TWH_MD database is irrelevant
in this case. The perl script referenced also seems to be wrong....it looks
to be for the AMY WEP not the ANM WEP).
In order to trouble shoot this type
of problem, you need to understand the data flow:
1. netmon detects a change in status
(up to down, down to up, up to unreachable, up to unmanaged.......etc)
2. netmon advised the tdwdaemon who
then compares the node name to the list of nodes it has been configured
to care about (via Smartsets) and if there is a match the tdwdaemon will
write a record to the DB2 based database called "NETVIEW" by
default.
So, are netmon and tdwdaemon running
and talking to each other ? Check the netmon.conf to see if TDWAVAILABILITY
flag is set to TRUE. Check the tdwdaemon.log to see if you are seeing ports
opened between netmon and tdwdaemon and if tdwdaemon has successfully opened
a collection with the DB2 database (java based connection)
3. Is your DB2 Server running ? Has
the NETVIEW database been created and do you see tables ? Have you checked
the contents of its tables using basic SQL queries ? If there is no data
here, then there is nothing for the ETLs to pull into the Central Data
Warehouse (TWH_CDW) and in turn move to the Reporting Datamart (TWH_MART).
This would go back to a problem with tdwdaemon getting data into the NETVIEW
database.
4. If you have verified there is data
in the NETVIEW database (again I'm referring to the DB2 database only),
then you can start looking at ETL problems. Firstly the ANM ETL1 is tasked
with moving data from the NETVIEW database to the TWH_CDW database. So
check the twg.comp table for a list of node/hostnames and Smartset names
? Do you see any.......if not there is no point looking for measurement
data since you can't have one without the other.
5. If you do see components listed,
check the twg.msmt table for measurements that related back to the NetView
related components. This would all be veryu easy if are only feeding table
into the TDW environment at present as any data in the twg.msmt table would
be a god sign. You can use SQL queries from a DB2 command prompt or the
DB2 Control Center to view these tables.
6. If you have NetView components and
measurements in the TWH_CDW database, then you can move on to the Reporting
Datamart (TWH_MART). Check the Warehouse Implementation Guide that is packaged
with the ANM v1.2.1 WEP as it documents the star schemas in the TWH_MART
database and then you will know which "dimension" tables to check
to see if node and Smartset information has made this far, and check the
"fact" tables (one for each report type I think) for the actual
raw measurement data.
If this information doesn't help you
pinpoint where the data has stopped flowing, please call NetView Support.
If you do find where data has stopped flowing, post an update and maybe
we can direct a little further, else call NetView Support.
Goodluck,
Gareth
usman.taokeer AT s-iii DOT com
Sent by: owner-nv-l AT lists.us.ibm DOT com
05/05/2006 12:05 PM
|
To
| nv-l AT lists.us.ibm DOT com
|
cc
| nv-l AT lists.us.ibm DOT com, owner-nv-l AT lists.us.ibm DOT com
|
Subject
| RE: [nv-l] TDW Blank Reports!!! |
|
Thanks a lot, if i am not mistaken this script is written to extract data
from ITM DWH! will it work for Netview's DWH as well?? Coz i dont see any
of relevant tables in the queries!
Regards,
Usman Taokeer
Si3
"Hoang, Michael D
CONT \(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil>
Sent by: owner-nv-l AT lists.us.ibm DOT com
05-05-06 08:38 PM
Please respond to
nv-l AT lists.us.ibm DOT com |
|
To
| <nv-l AT lists.us.ibm DOT com>
|
cc
|
|
Subject
| RE: [nv-l] TDW Blank Reports!!! |
|
Usman,
Modify the user name and password....run this perl script to see if there
is data in your TWD_MD database.
%TWH_TOPDIR\tools\perl\bin\perl.exe amy_check_host_data.pl
Let me know how this goes.
From: owner-nv-l AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of usman.taokeer AT s-iii DOT com
Sent: Friday, May 05, 2006 11:28 AM
To: nv-l AT lists.us.ibm DOT com
Cc: nv-l AT lists.us.ibm DOT com
Subject: RE: [nv-l] TDW Blank Reports!!!
well.. there isn't any data... what next!
-----owner-nv-l AT lists.us.ibm DOT com wrote: -----
To: <nv-l AT lists.us.ibm DOT com>
From: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil>
Sent by: owner-nv-l AT lists.us.ibm DOT com
Date: 05/05/2006 08:09PM
Subject: RE: [nv-l] TDW Blank Reports!!!
Usman,
Make sure there is data in the TWH_MD database.
From: owner-nv-l AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of Colin Mulkerrins
Sent: Friday, May 05, 2006 11:01 AM
To: nv-l AT lists.us.ibm DOT com
Subject: RE: [nv-l] TDW Blank Reports!!!
Hey Usman,
Welcome to my world. Never had any satisfaction from TDW - gave up
on it...
Regs
Colin M
-----Original Message-----
From: owner-nv-l AT lists.us.ibm DOT com [mailto:owner-nv-l AT lists.us.ibm DOT com]
On Behalf Of usman.taokeer AT s-iii DOT com
Sent: 05 May 2006 16:00
To: nv-l AT lists.us.ibm DOT com
Subject: [nv-l] TDW Blank Reports!!!
Importance: High
Hi,
TDW 1.3
WEP ANM 1.2.1
NV FP04
Win2003 std SP1
Installed Tivoli Data warehouse 1.3 and WEP 1.2, Executed ETL but when
check reports on crystal server there is no data, the ETL processs was
successfull, but yet i dont see any data when i execute any of the reports.
Any reason ... what can i check to trouble shoot this ... the installation
went smooth followed all the steps.
Regards,
Usman Taokeer
Si3.
*********************************************************************************
This e-mail and its attachments, is confidential and is
intended for the addressee(s) only. If you are not the intended recipient,
disclosure, distribution or any action taken in reliance on it is prohibited
and may be unlawful. Please note that any information expressed in this
message or its attachments is not given or endorsed by An Post unless otherwise
indicated by an authorised representative independently of this message.
An Post does not accept responsibility for the contents of this message
and although it has been scanned for viruses An Post will not accept responsibility
for any damage caused as a result of a virus being passed on.
*********************************************************************************
amy_check_metric_data.pl
Description: Binary data
|
|
|