- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: odbc master connection
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-08-2007 09:17 PM
тАО08-08-2007 09:17 PM
odbc master connection
What is the purpose of having a connection to the master database and how will the functionality of HP SIM be influenced/impaired if I remove this connection?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2007 09:02 AM
тАО08-09-2007 09:02 AM
Re: odbc master connection
Where are you seeing these ODBC connections?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2007 05:28 PM
тАО08-09-2007 05:28 PM
Re: odbc master connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2007 06:33 AM
тАО08-10-2007 06:33 AM
Re: odbc master connection
HP Systems Insight Manager (HP SIM) uses a Microsoft SQL Server 2000 Service Pack 3, MSDE (Windows Install), or PostgreSQL SQL 7.4.x (HP-UX or Linux install) database to store collected event and system data.
The database can be on the same system as the management application or on a different system that has network access to the database server. However, configuration of HP SIM database tables cannot be performed on a remote system. HP SIM uses the Java DataBase Connectivity (JDBC) and the Open DataBase
Connectivity (ODBC) on Windows systems to communicate with the database.
During installation, the necessary database systems and transaction log systems are created before creating and populating the database.
***************************************
Only the HP SIM application should add or delete from these tables. Any other modifications to these tables cause cache coherency problems for the application.
***************************************
The database contains:
├в ┬в Events
├в ┬в Discovered systems
├в ┬в System status
├в ┬в User preferences
├в ┬в Detailed system information
├в ┬в Language text (English only)
Reports can be created in Microsoft Access, Excel, Crystal Reports, or any standard reporting tool that can access the database. The database schema is published to make creating the reports easier.
Predefined views
Several predefined views are shipped with HP SIM. These views can be used to search the database for different information such as data collection information, event data and license data.
1)Notices_view. This view can be used to list events in the system along with their descriptions. It does not contain the specifics of an event, but it can be useful for some simple reports. It returns the system name,event severity, cleared status, received time, cleared time and event description.
2)View_deviceAssociations. This view is used in building searches, mainly used internally.
3)licenseCounts. This view is used to show license count data in the license report.
4)deviceTypesEnum. This view links the devices_table productType field with an (English) string representing the system type.
5)deviceSubTypesEnum. This view links the nodeSubTypesEnum table enumOrd field with an (English) string representing the system subtype.
The database and views are not deleted when you uninstall HP SIM.
Connection to the database will resultin abnormal Functionality of HP SIM.
Cheers !
James.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2007 06:34 AM
тАО08-10-2007 06:34 AM
Re: odbc master connection
Yo !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2007 05:57 PM
тАО08-12-2007 05:57 PM
Re: odbc master connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-14-2007 12:16 AM
тАО08-14-2007 12:16 AM
Re: odbc master connection
When HP SIM is installed, the two odbc connections are created, but it is not used. Maybe for the setup scenario, but after that it can be removed.
The full impact of this is unsure.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-15-2007 08:05 PM
тАО08-15-2007 08:05 PM