|
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
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
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@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of usman.taokeer@s-iii.com Sent: Friday, May 05, 2006 11:28 AM To: nv-l@lists.us.ibm.com Cc: nv-l@lists.us.ibm.com Subject: RE: [nv-l] TDW Blank Reports!!! well.. there isn't any data... what next! -----owner-nv-l@lists.us.ibm.com wrote: ----- To: <nv-l@lists.us.ibm.com> From: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang@nets.nemais.navy.mil> Sent by: owner-nv-l@lists.us.ibm.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@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of Colin Mulkerrins Sent: Friday, May 05, 2006 11:01 AM To: nv-l@lists.us.ibm.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@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of usman.taokeer@s-iii.com Sent: 05 May 2006 16:00 To: nv-l@lists.us.ibm.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. *********************************************************************************
|
