Francois,
Yeah, I just looked at the tables and they are all there with their
corresponding views.
As I said previously I am probably just losing it :-)
Thanks for the help...
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 18:09
To: nv-l@lists.us.ibm.com
Subject: RE: [nv-l]Creating Netview Relational Database
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.
************************************************************************
***********
|