IBM Platform HPC Version 4.1.1.1 Fix 382171 Readme File

Abstract

This fix addresses an issue in Platform HPC 4.1.1.1 where the data purger service does not purge data at default intervals, and causes the database size to grow.

Description

Readme documentation for IBM® Platform HPC Version 4.1.1.1 Fix 382171, including installation-related instructions and prerequisites.

The data purger service does not remove the records from certain database tables, such as the lim_host_metrics table, and the database grows to an unreasonable size. Applying this fix will resolve this issue for the data purger service. Note that applying this fix does not delete any existing records. Refer to the section "Manually clean up the old data" for required steps to purge old data from the database.  

Readme file for: IBM® Platform HPC
Product/Component release: 4.1.1.1
Update name: Fix 382171
Fix ID: phpc-4.1.1.1-build382171
Publication date: 13 Jan 2016
Last modification date: 13 Jan 2016

Contents

  1. List of fixes
  2. Download location
  3. Products or components affected
  4. System requirements
  5. Installation and configuration
  6. List of files
  7. (Optional)Manually clean up the old data
  8. Copyright and trademark information

1. List of fixes

P101551.

2. Download location

Fix 382171 can be downloaded from IBM Fix Central at http://www.ibm.com/support/fixcentral.

3. Products or components affected

Fix 382171 affects the following versions of Platform HPC: 4.1.1.1.

4. System requirements

Platform HPC 4.1.1.1 must be installed on management node.

5. Installation and configuration

Applying this fix involves the following steps:

5.1 Download the "phpc-4.1.1.1-build382171" fix package from IBM Fix Central.

5.2 Upload the fix tar file to the Platform HPC management node.

5.3 On the Platform HPC management node, extract the fix tar file.

# mkdir -p /opt/pcm/phpc_4.1.1.1_build382171
# tar -zxvf phpc_4.1.1.1_382171_fix.tar.gz -C /opt/pcm/phpc_4.1.1.1_build382171

5.4 Install the fix.

# pcmhatool failmode -m manual
# sh /opt/pcm/phpc_4.1.1.1_build382171/patch_install.sh
# pcmhatool failmode -m auto
# sh /opt/pcm/phpc_4.1.1.1_build382171/patch_install.sh

      Note: After installing the patch_install.sh script, a backup file is created. The backup file includes a jar package and a psql function file.

# ll /opt/pcm/phpc_4.1.1.1_build382171/backup
total 544
-rwxr-xr-x 1 root root  54404 Jan  8 03:44 perf_ptc.jar.orig
-rw-r--r-- 1 root root 497244 Jan  8 03:44 psql_functions_backup.dump

6. List of files

create_partitions.sql

purge_data.sql

perf_ptc.jar

patch_install.sh

7. (Optional)Manually clean up the old data

Fix 382171 does not remove existing database records.

To delete data from a table such as the lim_host_metrics table, run the following command:

# psql -U postgres xcatdb -c "TRUNCATE public.lim_host_metrics"

To delete specific records by specifying a date, for example, all records before 2015-10-01, do the following:

         1. Delete the records before 2015-10-01 from the lim_host_metrics table.

# psql -U xcatadm xcatdb -c "delete from public.lim_host_metrics where time_stamp <'2015-10-01'"
         
         2. Then, execute the VACUUM ANALYSE command on the lim_host_metrics table.

# psql -U postgres xcatdb -c "VACUUM ANALYSE lim_host_metrics"

8. Copyright and trademark information

© Copyright IBM Corporation 2016
US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
IBM, the IBM logo, ibm.com®, IBM Spectrum Scale, and LSF are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Other company, products, or service names may be trademarks or service marks of others.