Online Help for Administrators > Monitoring SHR > Monitoring the SHR database

Monitoring the SHR database

SHR uses the Sybase IQ database for managing and storing the data that is collected from the various HP product center repositories. Workflow operations are performed on the collected data after which the data is stored in the data store for analysis purposes. Unlike traditional databases, which store data in rows, Sybase IQ stores data by columns, which can be stored separately and across multiple disks. This method of data storage ensures easier and faster data access, improved storage management, faster aggregations, and improved analytical performance.

In Sybase IQ, indexes have been redesigned to improve data retrieval performance. Traditionally, indexes are often used as a reference mechanism that pointed to the storage area that contained the row data. However, in Sybase IQ, indexes actually represent and store the data so that the data can be used for accelerating a wide variety of queries. Another unique feature in Sybase IQ is its multiplexing capability, which is used to manage large query loads on the database.

At an application level, Sybase IQ distributes data across multiple disks by representing each device as a dbspace. A dbspace can be an operating system file (dbfile) or a raw disk partition. Dbspaces can contain both user data and internal database structures used for startup, recovery, backup, and transaction management.

A database that you create using a Sybase IQ server is called an IQ database. Each IQ database that you create includes three stores:

Note: The size of the total database space depends on the volume and retention policies you select while creating the schema.

Sybase IQ is the platform on which PMDB, the database repository for all SHR-related data, is created. The data is stored in the database in designated table, which are created when you create the database schema during the post-installation stage of SHR.

Monitoring the database health and availability

The Database Monitoring page of the Administration Console provides a detailed status of the health and availability of SHR database. Monitoring the database helps you to:

Using the Database Monitoring page, you can view the database details.


© 2010 - 2013 Hewlett-Packard Development Company, L.P.