IBM Platform Application Center 9.1.3 Fix 331920 Readme
Abstract
This fix resolves the following issue: after migrating Platform Application Center 9.1.2 to 9.1.3, the log file ${PAC_TOP}/perf/logs/dataloader/bad_record contains repeated errors about "Duplicate entry" in the table SHARED_RESOURCE_USAGE.
Description
Readme documentation for IBM Platform Application Center 9.1.3 Fix 331920 including installation-related instructions, prerequisites and co-requisites, and list of fixes.
This fix addresses the following issue:
- After migrating Platform
Application Center 9.1.2 to 9.1.3, the log file
${PAC_TOP}/perf/logs/dataloader/bad_record contains repeated errors
about "Duplicate entry" in the
table SHARED_RESOURCE_USAGE.
Readme
file for: IBM® Platform Application Center
Product/Component
Release: 9.1.3.0
Update
Name: Fix 331920
Fix
ID:
pac9.1.3_standard_linux-x64.tar.Z
Publication
date: 15
February 2015
Last
modified date: 2 March 2015
Contents:
APAR#: P100954
Download Fix 331920 from the following location: http://www.ibm.com/eserver/support/fixes/
Affected components include: Perf loader
None
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-331920.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.
5.4 Modify primary key of table SHARED_RESOURCE_USAGE and SHARED_RESOURCE_USAGE_HOSTLIST mannually
Complete these steps only
if you have already migrated your database from 9.1.2 to 9.1.3.
Otherwise, migrate your database with the updated SQL scripts
included
in this package.
1. For MySQL, run the following sql statements.
> alter table SHARED_RESOURCE_USAGE drop primary key;
> alter table SHARED_RESOURCE_USAGE add primary key (TIME_STAMP_GMT, RESOURCE_NAME, CLUSTER_NAME, INSTANCE_ID);
> alter table SHARED_RESOURCE_USAGE_HOSTLIST drop primary key;
> alter
table SHARED_RESOURCE_USAGE_HOSTLIST add primary key (TIME_STAMP_GMT,
RESOURCE_NAME, HOST_NAME, CLUSTER_NAME,
INSTANCE_ID);
2. For Oracle, run the following sql statements.
> alter table SHARED_RESOURCE_USAGE drop constraint PK_SHARED_RESOURCE_USAGE;
> alter
table SHARED_RESOURCE_USAGE add constraint PK_SHARED_RESOURCE_USAGE
primary key (TIME_STAMP_GMT, RESOURCE_NAME,
CLUSTER_NAME, INSTANCE_ID);
> alter table SHARED_RESOURCE_USAGE_HOSTLIST drop constraint PK_SHARED_RES_USAGE_HOSTLIST;
> alter
table SHARED_RESOURCE_USAGE_HOSTLIST add constraint
PK_SHARED_RES_USAGE_HOSTLIST primary key (TIME_STAMP_GMT,
RESOURCE_NAME,
HOST_NAME, CLUSTER_NAME, INSTANCE_ID);
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.
${PAC_TOP}/gui/DBschema/MySQL/Patch/pac912_to_913.sql
${PAC_TOP}/gui/DBschema/Oracle/Patch/pac912_to_913.sql
© 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