HP Systems Insight Manager 5.2 Update 2 Technical Reference Guide

17 Reference information
HP Systems Insight Manager (HP SIM) uses a Microsoft SQL Server 2000 Service Pack 3, MSDE or MIcrosoft
SQL Server 2005 Express Edition (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.
CAUTION: 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)
IMPORTANT: Back up the database on a regular basis and monitor the size of the database to expand it
as necessary. See Backing up and restoring data files for HP SIM data files in a Windows environment white
paper at http://h18013.www1.hp.com/products/servers/management/hpsim/infolibrary.html and Backing
up and restoring data files for HP SIM data files in an HP-UX and Linux environment white paper at http://
h18013.www1.hp.com/products/servers/management/hpsim/infolibrary.html for more information.
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.
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.
View_deviceAssociations. This view is used in building searches, mainly used internally.
licenseCounts. This view is used to show license count data in the license report.
deviceTypesEnum. This view links the devices_table productType field with an (English) string representing
the system type.
deviceSubTypesEnum. This view links the nodeSubTypesEnum table enumOrd field with an (English) string
representing the system subtype.
NOTE: The database and views are not deleted when you uninstall HP SIM.
See “Reporting views” to see the available Reporting Views.
Database tables
The following sections provide the contents of the database. The tables describe the information collected
by HP SIM and the database table structures that store the information. The following tables are available:
Predefined views 663