IBM Platform Application Center 9.1.3 Fix 329143 Readme

Abstract

This fix resolves the following issue: when the swap space used by a job on an execution host exceeds 2,147,483,647, the Jobs page displays the MYSQL exception message: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException.

Description

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

This fix addresses the following issue:

    -  When the swap space used by a job on an execution host exceeds 2,147,483,647, the Jobs page displays the MYSQL exception message:
       com.mysql.jdbc.exceptions.jdbc4.MySQLDataException.

Readme file for: IBM® Platform Application Center
Product/Component Release: 9.1.3.0
Update Name: Fix 329143
Fix ID: pac9.1.3_standard_linux-x64.tar.Z
Publication date: 19 January 2015
Last modified date:  20 January 2015

Contents:

• 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#: P100913

• Download Location

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

• Products or components affected

 Affected components include: Jobs

• System requirements

None

• Installation and configuration

5.1 Before installation

           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.

             1.    Determine the location of your existing IBM Application Center installation.
#rpm -q --queryformat "%{INSTPREFIXES}\n" pcc-appcenter

             2.    As root, log on to your IBM Platform Application Center 9.1.3 host. Backup the exiting installation directory, for example:
#cp -rfp /opt/pac /opt/pac.bak

             3.    Backup database if you use local MySQL.
                    Export local IBM Platform Application Center mysql database use command:
#mysqldump -u pacuser -p pac --add-drop-table > /root/pacdata.sql

             4.    Download the fix file: pac9.1.3_standard_linux-x64.tar.Z.

             5.    Extract  pac9.1.3_standard_linux-x64.tar.Z.

             6.    As root, log on to your IBM Platform Application Center 9.1.3 host.

             7.    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


             8.    Install the fix.
rpm -Uvh --prefix ${PAC_TOP} --nopreun pcc-appcenter-9.1.3-329143.x86_64.rpm
Note: Replace ${PAC_TOP} with your actual installation directory.

5.3 After installation

             1.    Start IBM Platform Application Center services

    perfadmin start all
                   pmcadmin start

             2.    Merge ${PAC_TOP}/gui/conf/pmc.conf.old into ${PAC_TOP}/gui/conf/pmc.conf according to your old configuration.

             3.    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.

• 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.

             1.    Determine the location of your existing IBM Application Center installation.
#rpm -q queryformat %{INSTPREFIXES}\n pcc-appcenter

             2.    Download the RPM package for a version previous to the Fix, for example, pcc-appcenter-9.1.3-123456.x86_64.rpm.

             3.    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


             4.    Install the IBM Platform Application Center RPM package, for Example:
#rpm -Uvh --prefix ${PAC_TOP} --oldpackage --nopreun --noscripts pcc-appcenter-9.1.3-123456.x86_64.rpm
Note: Replace ${PAC_TOP} with your actual installation directory.

             5.    If administrator has done some customization on code, copy back the changed code from backup directory.

             6.    Start IBM Platform Application Center services

    perfadmin start all
                   pmcadmin start

             7.    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}/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/batchservice/Job.class

• 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