This fix resolve the following issue: the automatic data purging error "The value is not a valid time stamp" causes some job data records to not be deleted from the database.

Readme documentation for IBM Platform Application Center 9.1.4.1 Fix 57834 including installation-related instructions, prerequisites and co-requisites, and list of fixes.

This fix resolves the following issues:
- Some job data records are not deleted from the database due to the error "The value is not a valid time stamp". This error is listed in the purger.log.host_name file.

• List of fixes
• Download location
• Products or components affected
• System requirements
• Installation and configuration
• Uninstallation
• List of files
• Copyright and trademark information

• List of fixes

  APAR#: P101332

• Download location

  Download Fix 57834 from the following location: http://www.ibm.com/eserver/support/fixes/

• Affected components:

  - Automatic job data purging

• System requirements

  Linux_x86_64

• Installation and configuration
  • 5.1  Before installation

    Check and record the version and build number of IBM Platform Application Center. this is in case of rolling back the fix.

    pmcadmin -V
    

    Stop all IBM Platform Application Center services:

    perfadmin stop all
    pmcadmin stop
  • 5.2  Installation steps

    The following steps assume IBM Platform Application Center is installed in /opt/pac.
    Replace with your actual installation directory.

    • Determine the location of your existing IBM Application Center installation.
      #rpm -q --queryformat "%{INSTPREFIXES}\n" pcc-appcenter
    • Back up the existing:
      #cp -rfp /opt/pac /opt/pac.bak
    • Complete this step only if you are using a local MySQL database.
      Export your local IBM Platform Application Center MySQL database by using the following command:
      #mysqldump -u pacuser -p pac --add-drop-table > /root/pacdata.sql
    • Download the fix file: pac9.1.4.1_standard_linux-x64.tar.Z.
    • Extract pac9.1.4.1_standard_linux-x64.tar.Z.
    • As root, log on to your IBM Platform Application Center 9.1.4.1 host.
    • Set your IBM Platform Application Center environment:
      For csh or tcsh:
      % source /opt/pac/cshrc.platform
      For sh, ksh, or bash:
      $ . /opt/pac/profile.platform
    • Install the fix.
      rpm -Uvh --prefix ${PAC_TOP} --nopreun pcc-appcenter-9.1.4.1-57834.x86_64.rpm
      Note: Replace ${PAC_TOP} with your actual installation directory.
  • 5.3  Upgrade steps

    If you have a local database your database is automatically updated for you. If you have a remote database, update your existing database schema from 9.1.4 to 9.1.4.1.

    • As root, extract the schema package.
      tar -xvf pcc-appcenter-9.1.4.1-dbschema.tar
    • Connect to your database with your existing user name and password, then run the appropriate scripts according to the previous version of Platform Application Center that you have installed.
      To update your database schema from 9.1.4 to 9.1.4.1:
      mysql -u root -p $rootpassword
      mysql>use pac
      mysql>source DBschema/MySQL/Patch/pac914_to_9141.sql;
      
  • 5.4  Start IBM Platform Application Center services.

    perfadmin start all
    pmcadmin start

• Uninstallation
  • 6.1  Before uninstallation

    Stop all IBM Platform Application Center services:

    perfadmin stop all
    pmcadmin stop
  • 6.2  Roll back the fix

    The following steps assume IBM Platform Application Center is installed in /opt/pac.
    Replace with your actual installation directory.

    • Determine the location of your existing IBM Application Center installation.
      #rpm -q queryformat %{INSTPREFIXES}\n pcc-appcenter
    • Download the RPM package for a version previous to the Fix, for example, pcc-appcenter-9.1.4.1-123456.x86_64.rpm.
    • Set your IBM Platform Application Center environment:
      For csh or tcsh:
      % source /opt/pac/cshrc.platform
      For sh, ksh, or bash:
      $ . /opt/pac/profile.platform
    • Install the IBM Platform Application Center RPM package. For example:
      #rpm -Uvh --prefix ${PAC_TOP} --oldpackage --nopreun --noscripts pcc-appcenter-9.1.4.1-123456.x86_64.rpm,
    • If you have made any customizations, reapply your customizations from the backup directory.
    • Start IBM Platform Application Center services
      perfadmin start all
      pmcadmin start
    • Clear your browser cache before logging into IBM Platform Application Center.
      This is required on every browser that will access IBM Platform Application Center. Otherwise, IBM Platform Application Center will not work properly.
• List of files
  

  ${PAC_TOP}/perf/1.2/lib/perf_purger.jar
  

• Copyright and trademark information

  ©Copyright IBM Corporation 2015
  
  U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  
  IBM®, the IBM logo and ibm.com® are 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