Re: [nv-l] TDW Database creation

[wolfgang.bergbauer@attglobal.net]

Hi Chris,

I just did a grep on the directories:

Look at /usr/OV/install/tools/tdwconfig/netview_tdw.sql

It should be possible to adapt that
file to your needs.

Kind regards,

Wolfgang
------------------------------------------------------------------
Wolfgang Bergbauer
Network and System Management Consultant
Cell phone: +49 172 534 9131
E-mail: wolfgang.bergbauer@attglobal.net

"Christopher J Petrina" <cjp8@meadwestvaco.com>
Sent by: owner-nv-l@lists.us.ibm.com

11/18/2004 03:58 PM

Please respond to
nv-l@lists.us.ibm.com

To	nv-l@lists.us.ibm.com
cc
Subject	Re: [nv-l] TDW  Database creation

We are using NV 7.1.4 FP 1 on AIX 5.2 
throiugh researching issues with TDW, we have found that the TDW GUI installation
uses SMS (System Management Storage) and not DMS (Database Management Storage)
 Much less efficient.  Also it places the database structure
in the home file system, we have a specific file structure system we want
to use.   But since I have no where to add or change where the database
writes to, I cannot change it to optimize the performance of our AIX boxes
and how we have them created and defined specifically for the NETVIEW TDW
Operational database.

Gareth Holl <gholl@us.ibm.com>
Sent by: owner-nv-l@lists.us.ibm.com

11/17/2004 10:50 AM

Please respond to
nv-l@lists.us.ibm.com

To	nv-l@lists.us.ibm.com
cc
Subject	Re: [nv-l] TDW  Database creation

The NetView warehouse database is a DB2 based database. Whether your database
server is remote or local with respect to the NetView Server, you still
need to have a DB2 instance created locally. It is the DB2 instance that
controls where the databases (all of them) are stored, not the tdwdaemon
GUI config panel or the underlying database schema scripts.

Optimization of the entire instance or individual databases can be performed
after the database is created. What kind of optimization were you talking
about that might need you to alter the database schema scripts ?

What exactly do you find limiting about the setup GUI ? What version of
NetView are you using ? What platform ? 

Gareth Holl
Staff Software Engineer
gholl@us.ibm.com

IBM Software Group - Tivoli Brand
Research Triangle Park,  North Carolina.

"Christopher J Petrina" <cjp8@meadwestvaco.com>
Sent by: owner-nv-l@lists.us.ibm.com

11/17/2004 10:16 AM

Please respond to
nv-l

To	nv-l@lists.us.ibm.com
cc
Subject	[nv-l] TDW  Database creation

Greetings all, 

 Have a question on the TDWDAEMON set up. 

The GUI setup is very limiting in the creation of the Netview Operational
database for TDW.   Is there a way that I can create the database
myself and then start the tdwdaemon? 
 Which schema and/or scripts are being called when the GUI executes.
The setup installs the database in the home directory of the db user.  There
is no optimizing of the database.   
We do not give much space in the home directory file structure, and we
have specific file tructures for databases that we would like to use.

-Thank you 
CHris Petrina 

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service._______________________________________________________________

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure. The
information is intended to be used solely by the recipient(s)
named. If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited. If you have
received this transmission in error, please notify MeadWestvaco
immediately at postmaster@MeadWestvaco.com.
_______________________________________________________________________

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service._______________________________________________________________

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service._______________________________________________________________

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure. The
information is intended to be used solely by the recipient(s)
named. If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited. If you have
received this transmission in error, please notify MeadWestvaco
immediately at postmaster@MeadWestvaco.com.
_______________________________________________________________________