In October 2010, IBM extended its Data Studio offering with a new health monitor that allows you to monitor the health of your DB2 for Linux, UNIX, and Windows databases, and view alerts, application, utilities, and storage. Data Studio Health Monitor (DSHM) is a server process that you install separately. It includes a browser-based client, but you can seamlessly launch it from the Data Studio or Optim Database Administrator Eclipse client.
The health monitoring features are also available in Optim Performance Manager 220.127.116.11, and include more advanced functionality. See the Resources section for more information about Optim Performance Manager. This tutorial will take you on a tour of the free DSHM function.
DSHM can be downloaded from developerWorks at http://www.ibm.com/developerworks/downloads/im/data/.
Installation of Data Studio Health Monitor is quick and easy, and you do not have to install as a root user. No additional software needs to be installed on the machine where DSHM is installed, or on the machines where the monitored databases reside. See the Resources section for information on the installation and configuration process. You can also choose to skip any configuration steps marked "optional", until you are ready to take advantage of them.
After you have installed Data Studio Health Monitor, you will find the scripts you need to start or stop the server in the installation /bin directory. The Config/ directory has some of the property files that are needed by the server, but you shouldn't have to manually update these files. The logs/ directory is where you will find the install logs, as well as logs created during the regular operation of the server.
Start the server. From Windows, you can start the server from the menu
option under Programs->IBM Data Studio->Start Data Studio Health
Monitor 2.2.1, or directly from Control Panel. From Linux/UNIX, you
need to use the
start.sh script from the
DSHM installation /bin directory. You do not need to run the DSHM
server as root. If your system administrator sets up an
init.d script for DSHM to be automatically
started on system startup, it is recommended that it still be started
as the install user (from
sudo), and not as
root. If you decide to start this process as a user other than the one
who installed it, just make sure you have permissions to read, write,
and execute in the installation directory (including the Config and
Connect to the DSHM server from a web browser with the Adobe
FlashPlayer plug-in installed, using a URL with the following
The default port number for DSHM is
but you can modify it at install time.
During the installation process, an administrator (usually 'admin', but you can change this) is created. The first time you log in, you will need to log in to the Web console as the administrator, using the password you provided during the installation. Figure 1 shows you the Welcome page after you log in.
Figure 1 - Data Studio Health Monitor web console on first login
From the Manage Database Connections page, as shown in Figure 2, you will identify the databases that you wish to
monitor. You can enter the database information directly, or import a
list of databases from comma-separated files. From the samples folder,
file in the install directory as an example for imports.
Once a database is added, health monitoring is automatically enabled, and you are ready to monitor your databases!
Note that the credentials provided here are used only for periodic background monitoring of the database. Any interactive connections to the database require you to enter your credentials. For more information, see the Database Privileges section.
Figure 2 - The Manage Database Connections page