Re: [nv-l] TDW Database creation
2004-11-18 11:39:17
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 AT attglobal DOT net
"Christopher J Petrina"
<cjp8 AT meadwestvaco DOT com>
Sent by: owner-nv-l AT lists.us.ibm DOT com
11/18/2004 03:58 PM
Please respond to
nv-l AT lists.us.ibm DOT com |
|
To
| nv-l AT lists.us.ibm DOT 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 AT us.ibm DOT com>
Sent by: owner-nv-l AT lists.us.ibm DOT com
11/17/2004 10:50 AM
Please respond
to
nv-l AT lists.us.ibm DOT com |
|
To
| nv-l AT lists.us.ibm DOT 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 AT us.ibm DOT com
IBM Software Group - Tivoli Brand
Research Triangle Park, North Carolina.
"Christopher J Petrina"
<cjp8 AT meadwestvaco DOT com>
Sent by: owner-nv-l AT lists.us.ibm DOT com
11/17/2004 10:16 AM
|
To
| nv-l AT lists.us.ibm DOT 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 AT MeadWestvaco DOT 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 AT MeadWestvaco DOT com.
_______________________________________________________________________
|
|
|