IBM Platform HPC Version 4.2 Fix 396607 Readme File

Abstract

This fix addresses an issue in Platform HPC 4.2 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.2 Fix 396607, 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.2
Update name: Fix 396607
Fix ID: phpc-4.2-build396607
Publication date: 18 May 2016
Last modification date: 18 May 2016

List of fixes
Download location
Products or components affected
System requirements
Installation and configuration
List of files
(Optional)Manually clean up the old data
Copyright and trademark information

1. List of fixes

P101688.

2. Download location

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

3. Products or components affected

Fix 396607 affects the following versions of Platform HPC:

4.2.

4. System requirements

Platform HPC 4.2 must be installed on management node.

5. Installation and configuration

Applying this fix involves the following steps:

5.1 Download the "phpc-4.2-build396607" 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.2_build396607

# tar -zxvf phpc_4.2_396607_fix.tar.gz -C /opt/pcm/phpc_4.2_build396607

5.4 Install the fix.

If the high availability is enabled, run the following commands on the active management node:

# pcmhatool failmode -m manual
# sh /opt/pcm/phpc_4.2_build396607/patch_install.sh
# pcmhatool failmode -m auto

Otherwise, if the high availability is not enabled, run the following commands:

# sh /opt/pcm/phpc_4.2_build396607/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.2_build396607/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 396607 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.