alert in IBM PHPC 4.2.1: [hostmetricsloader] is aged.

In IBM PHPC 4.2.1, when you add new metric and want them to be shown in web portal, you may get the following alert
hostmetricsloader

At this point, your new metric column will be empty because the loader failed to load entries to web database.

Solution:
1. Go to dataloader folder.
$ cd /opt/pcm/web-portal/perf/conf/dataloader/

  1. Make a backup of hostmetricsloader.xml
    $ cp hostmetricsloader.xml hostmetricsloader.xml.backup

  2. Open editor to modify hostmetricsloader.xml
    $ vim hostmetricsloader.xml

  3. Find this line: Insert into LIM_HOST_METRICS. You will see your new metrics there. But if you check carefully, you should notice that actually the number of metrics is different to the number of “?” in Values row. To fix it, add new “?” as much as number of your new metrics.

Values (?, ?, ?, ?, ?, ?, ?, ?,
......
?, ?, ?, ?)]]>
  1. Same thing happened after this line: Insert into LIM_HOST_METRICS_SNAP. So, just do the same thing.

  2. Restart PERF and WEBGUI services and check the web portal.
    $ pcmadmin service restart --group PERF
    $ pcmadmin service restart --service WEBGUI

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s