nv-l
[Top] [All Lists]

Re: [nv-l] NetView and DB2

To: Scott Hammons <s.hammons@ais-nms.com>, NetView mailing list <nv-l@lists.tivoli.com>
Subject: Re: [nv-l] NetView and DB2
From: Jane Curry <jane.curry@skills-1st.co.uk>
Date: Wed, 07 May 2003 20:25:08 +0100
Delivered-to: mailing list nv-l@lists.tivoli.com
Delivery-date: Wed, 07 May 2003 20:29:47 +0100
Envelope-to: nv-l-archive@lists.skills-1st.co.uk
In-reply-to: <000d01c314b9$fcd9bfe0$743b58aa@aisconsulting.biz>
List-help: <mailto:nv-l-help@lists.tivoli.com>
List-post: <mailto:nv-l@lists.tivoli.com>
List-subscribe: <mailto:nv-l-subscribe@lists.tivoli.com>
List-unsubscribe: <mailto:nv-l-unsubscribe@lists.tivoli.com>
Mailing-list: contact nv-l-help@lists.tivoli.com; run by ezmlm
References: <000d01c314b9$fcd9bfe0$743b58aa@aisconsulting.biz>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3a) Gecko/20021212
I have tested this in the lab and got it working but I certainly wouldn't say I had stress-tested it in production.

DB2 RIMs are tricky.  Here's the way I have it.
Create an Op Sys user, db2inst1, password ibmdb2. Make sure you can login with it. Ditto a user db2as. Make /home/db2 the home directory of db2inst1. Install DB2 as this user which creates a db2 instance called dbinst1. Add the db2inst1 userid as a login to a well-privileged Tivoli Administrator.

You need to manually create the RIM for NetView - I do this as db2inst1. In the example, my rim host is poppet.skills-1st.co.uk. The -d is the database - this should be netview. The -u is the user with which you installed db2 - that's my db2inst1. The -H says where is the base directory of your DB2 installation. -S TCPIP seems to be standard. -I is the home directory of the user that installed db2. I believe in db2-speak (which I speak badly!) this is the instance home ie. the home base directory in which your instance and databases sit. The final netview is the name of your rim object.

wcrtrim -v DB2 -h poppet.skills-1st.co.uk -d netview -u db2inst1 -H
/usr/lpp/db2_07_01 -s TCPIP -I /home/db2 netview

You will be asked for a password - that's the password for your -u user so I use ibmdb2.
Check with wrimtest -l netview

Once you have installed the NetView Database code, change to /usr/OV/scripts and run serversetup to configure relational databases, this creates the file /usr/OV/conf/dbconf.dat. If you edit this file, it has a line specifying the RIM - in my example it will originally say netview@poppet.skills-1st.co.uk. I always edit this line to remove the hostname - the RIM line should be exactly the same as your rim object, ie netview.

In summary, very tricky but it is possible to make it work. Feel free to come back to me if you want.

Cheers,
Jane

Scott Hammons wrote:

Hi listers,
Has anyone experienced any issues with using DB2 to store the IP Topology, trapdlog and snmp collect data? Also, according to the database guide the user id should be changed to the name of the machine where NetView is installed. Is this correct? Additionally, the example of the RIM object shows a user of NetView. This would lead me to believe the userid should be NetView not the name of the machine. Experiences (good or bad) are appreciated. Thanks, Scott Scott Hammons
Senior Consultant
Advanced Integrated Solutions, Inc.
www.ais-nms.com <http://www.ais-nms.com>

--
Tivoli Certified Consultant & Instructor
Skills 1st Limited, 2 Cedar Chase, Taplow, Bucks, SL6 0EU, UK
Tel: +44 (0)1628 782565
Copyright (c) 2003 Jane Curry <jane.curry@skills-1st.co.uk>.  All rights 
reserved.



---------------------------------------------------------------------
To unsubscribe, e-mail: nv-l-unsubscribe@lists.tivoli.com
For additional commands, e-mail: nv-l-help@lists.tivoli.com

*NOTE*
This is not an Offical Tivoli Support forum. If you need immediate
assistance from Tivoli please call the IBM Tivoli Software Group
help line at 1-800-TIVOLI8(848-6548)


<Prev in Thread] Current Thread [Next in Thread>

Archive operated by Skills 1st Ltd

See also: The NetView Web