RE: [nv-l]Creating Netview Relational Database

[Francois Le Hir <flehir@ca.ibm.com>]

Colin,

Can you check that all tables and views that should be created by the
topology sql script are present ? did the script execute without error ?
(you can use the db2 command line and do "connect to netview" and "list
tables" to see what is there.)
I am not a dba either but the error you have looks to me like a view is
missing. I just had a look at the topology sql script and see that
"nodeclass" should be a table and nodeclass2_view should be a view. can you
check if it is defined in your netview database ?

Salutations, / Regards,

Francois Le Hir
Network Projects & Consulting Services
IBM Global Services
Phone: (514) 964 2145


                                                                           
             "Colin                                                        
             Mulkerrins"                                                   
             <Colin.Mulkerrins                                          To 
             @anpost.ie>               <nv-l@lists.us.ibm.com>             
             Sent by:                                                   cc 
             owner-nv-l@lists.                                             
             us.ibm.com                                            Subject 
                                       RE: [nv-l]Creating Netview          
                                       Relational Database                 
             03/23/2005 11:17                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                   nv-l                                                    
                                                                           
                                                                           





Francois,

Thanks for that.  I created the RIM called netview@server064 (server064
is the name of the test server with netview and the RDBMS installed)
using db2inst1 and that seems to work (I can wrimtest to it). I had to
add a connect statement into the create topology sql script to allow the
script to connect into the database at all and I started getting error
messages like below

DB21034E  The command was processed as an SQL statement because it was
not a
valid Command Line Processor command.  During SQL processing it
returned:
SQL0204N  "DB2INST1.NODECLASS2_VIEW" is an undefined name.
SQLSTATE=42704

Of course these may be only informational but I am not a db2 expert and
the manual is not very clear (it says to run the sql as netview).

I suppose that I will just blang ahead ignoring the messages and see if
it works...

Any vacancies in the 'Home for the Tivoli bewildered'?

Regards

Colin Mulkerrins
Enterprise Systems Management
An Post




-----Original Message-----
From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com]
On Behalf Of Francois Le Hir
Sent: 23 March 2005 15:08
To: nv-l@lists.us.ibm.com
Subject: Re: [nv-l]Creating Netview Relational Database


Colin,

netview_db2_admin_create.sql is indeed 9 lines. It just create the
netview database. Depending on what you want to send to the relational
database, you need to use an other script to create tables
(netview_db2_schema_trapd_create.sql for the traps ....)

netview is the name of the database that is created. if I remember
correctly it is also the name of the RIM object. Did you create the RIM
? (see man page of wcrtrim or the documentation). The user id used to
access db2 is usually db2inst1 (depending on the instance you use). You
will use that user id and the password when creating the RIM.

Salutations, / Regards,

Francois Le Hir
Network Projects & Consulting Services
IBM Global Services
Phone: (514) 964 2145




             "Colin

             Mulkerrins"

             <Colin.Mulkerrins
To
             @anpost.ie>               <nv-l@lists.us.ibm.com>

             Sent by:
cc
             owner-nv-l@lists.

             us.ibm.com
Subject
                                       [nv-l]Creating Netview Relational

                                       Database

             03/23/2005 09:37

             AM





             Please respond to

                   nv-l









People,

AIX 4330-11 NetView 7.1.4 FP02

I am trying to create a relational database for NetView in db2.  When I
ran netview_db2_admin_create.sql it created the database but did not
create a userid.  Reading the documentation (nv714 Database Guide)
appears to indicate that it should also create a userid (called
netview).  This userid should be used in creating the tables and views
later... I think

Am I losing it, or is the sql script incomplete?  Could someone forward
a cut of the create script (my script is 9 lines)

or let me know if I have indeed lost it and an address for the 'home for
the Tivoli bewildered'  :-(?)

Thanks

Regards


Colin Mulkerrins
Enterprise Systems Management
An Post




************************************************************************
***********

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.
************************************************************************
***********