Installing Database 6.0 does not in itself delete any database tables.
It only replaces the scripts in /usr/OV/scripts that are used to create the
database tables. The idea is for these scripts to be run, after the
installation of the component, to drop and recreate the database tables in
order to update the tables with any changes to the schema. Now, in answer
to your first question, the database table structure has not changed since
5.1.2, so since you are moving from 5.1.2 to 6.0.2 you can save this last
step by not running these new scripts. This, in answer to your second
question, will mean that your existing Oracle data will remain unaffected.
However, having said that, the actual Database 6.0 component should
still be installed. This is because there are several fixes included in
this new code that have been applied to the functions that insert data into
and select data from the database, files such as nvColToSQL and
nvDataSumCol, for example. Simply installing Database 6.0 will not remove
any data from your Oracle database but will lay down the most up-to-date,
supported RIM functions.
Recreating the RIM object is an issue which is totally separate from
the installation of Database 6.0. But it is not difficult to do if the RIM
object data from before the migration is saved (see it with the command
wgetrim <rim_object_name>) and then after migration used to create a new
RIM object with the wcrtrim command.
Frank
James Shanks
05/23/2001 07:09 PM
To: Frank Curcio/Tivoli Systems@Tivoli Systems
cc:
From: James Shanks/Tivoli Systems@Tivoli Systems
Subject: [NV-L] Netview upgrade - Databse
Frank -
Can you give some advice here?
Thanks
James Shanks
Team Leader, Level 3 Support
Tivoli NetView for UNIX and NT
---------------------- Forwarded by James Shanks/Tivoli Systems on
05/23/2001 07:12 PM ---------------------------
"Chan, Jack" <jack.chan@nz.unisys.com>@tkg.com on 05/23/2001 06:29:47 PM
Please respond to IBM NetView Discussion <nv-l@tkg.com>
Sent by: owner-nv-l@tkg.com
To: "'IBM NetView Discussion'" <nv-l@tkg.com>
cc:
Subject: [NV-L] Netview upgrade - Databse
I am still confused about the Netview migration, about the Databse
component.
I know now I need to re-create the RIM and reconfigure Netview to use
Oracle
after the migration. but..
Questions I still have is:
- Has the tables structure changed from Netview 5.1.2 to Netview 6 /6.02?
- I am using Oracle databse to store SNMP collection.
- will instaling the Netview Database component affect/modify/delete
the ORACLE tables I have at the moment?
In the Installation and conifg guide 6.0(pg46), it suggested if I am
migrating from 5.1, then I need to transfer the DB to flat files, and then
clear all the DB tables, re-import the flat files to the DB.
Since I am on 5.1.2, should I just igore the above?
And on the same page they have a separate paragraph for migrating from
5.1.x
(it applies to me!), but it tells you only to re-create the RIM. That's why
I am so confused!!!
Please help,
Jack.
-----Original Message-----
From: James_Shanks@tivoli.com [mailto:James_Shanks@tivoli.com]
Sent: Tuesday, 22 May 2001 11:33 p.m.
To: IBM NetView Discussion
Subject: RE: [NV-L] Netview on solaris upgrade
The database component is not the same thing as the database, what you are
calling the "flat files in NetView". The database component is that
portion of the product code which will enable and perform RDBMs access.
The migration step preserves your "flat files" and re-installs them under
the new NetView. That is why you do a migration as opposed to a new
installation. The tables in Oracle might be affected if changes to them
were made between Version 5.1 and Version 6.0, but otherwise not. That's
all part of your installation process. And why you have to re-create the
RIM object.
Bottom line here, Jack, is that you cannot pick and choose. If you want to
migrate, you have to follow the instructions and do it as we tell you to in
the Release Notes and in the manuals. No user options here. Scary or not,
there is only one way to do this. You can make additional backups if you
like but you cannot skip any steps.
James Shanks
Team Leader, Level 3 Support
Tivoli NetView for UNIX and NT
"Chan, Jack" <jack.chan@nz.unisys.com>@tkg.com on 05/21/2001 04:40:15 PM
Please respond to IBM NetView Discussion <nv-l@tkg.com>
Sent by: owner-nv-l@tkg.com
To: "'IBM NetView Discussion'" <nv-l@tkg.com>
cc:
Subject: RE: [NV-L] Netview on solaris upgrade
Hi Frank,
Thanks for your input. Really appreciated
How does installing the Database 6.0 component deletes and re-create the
tables in Oracle?? (I am using Oracle to collect SNMP at the moment) Sounds
a bit scary, or do you mean installing Databse 6.0 will delete all the flat
files that NetView uses?
Jack.
-----Original Message-----
From: Frank_Curcio@tivoli.com [mailto:Frank_Curcio@tivoli.com]
Sent: Monday, 21 May 2001 11:51 p.m.
To: nv-l@tkg.com
Cc: James_Shanks@tivoli.com
Subject: Re: [NV-L] Netview on solaris upgrade
I can answer the questions pertaining to relational databases and
NetView:
Migrating NetView does indeed blow away the RIM object, so it must be
re-created after installation of the upgrade. This means that NetView must
also be re-configured to use the relational database. These steps are the
same in 6.0 as they were in 5.1 so the 5.1 Database Guide is still a valid
resource to consult for the steps to do this.
As for the Database 6.0 component, it may and should be installed on
top of the 5.1 Database component to make sure all the latest RIM software
is available. Note that this will drop and re-create the NetView tables,
so any data that is to be kept from before the upgrade will have to be
backed up using native database backup tools prior to upgrading.
HTH,
Frank
"Chan, Jack" <jack.chan@nz.unisys.com>@tkg.com on 05/17/2001 05:01:43 PM
Please respond to IBM NetView Discussion <nv-l@tkg.com>
Sent by: owner-nv-l@tkg.com
To: "'nv-l@tkg.com'" <nv-l@tkg.com>
cc:
Subject: [NV-L] Netview on solaris upgrade
Hi all,
I am quite new to Netview.
Does anyone has experience of upgrading Netview
5.1.2 to 6 on Solaris? I have read the Installation and Config guide v6. I
have some questions in mind:
- the installation and config guide v6.0 (pg46) indicated that I need to
recreate the RIM after upgrade. Does the migration deletes the RIM??!!
- do I need to re-configure Netview to use Oracle after the migration? It
is
currently using Oracle to store SNMP collect data.
- On the Netview 6.0 CD I can only find the Tivoli Netview Database 6.0.
There is no Tivoli Netview Database update from 5x to 6.0, do I only
upgrade
the server to 6.0 and leave the databse component at 5.1? or should I
install databse 6.0 on top of 5?
- If I choose the migrate ALL files option, does that migrate any
miscellaneous user
files under /usr/OV/? or they will just remain there after the upgrade?
- any other things I should beware of about migrating Netview from 5.1.2 to
6.0?
Ansers to any of these questions would be appreciated.
Jack Chan
jack.chan@unisys.com
Enterprise Systems Management
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l
|