- List of fixes
APAR#: P100790
- Download location
Download Fix 339223 from the following location:
http://www.ibm.com/eserver/support/fixes/
- Products or components affected
Affected components include:
- Jobs page.
- Job detail page.
- 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.
- Determine the location of your existing IBM Application Center installation.
#rpm -q --queryformat "%{INSTPREFIXES}\n" pcc-appcenter
- 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
- 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.3_standard_linux-x64.tar.Z.
- Extract pac9.1.3_standard_linux-x64.tar.Z.
- As root, log on to your IBM Platform Application Center 9.1.3 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.3-339223.x86_64.rpm
Note: Replace ${PAC_TOP} with your actual installation directory.
- 5.3 Configure Platform Application Center improve performance
- Log on to the Platform Application Center server as root.
- Set the Platform Application Center environment.
For csh or tcsh:
% source /opt/pac/cshrc.platform
For sh, ksh, or bash:
$ . /opt/pac/profile.platform
- In $GUI_CONFDIR/pmc.conf, check FINISH_JOB_TIME_TO_LIVE is set.
- Add the parameter MOVE_FINISHED_SHORT_JOBS=true in the configuration file $PERF_CONFDIR/dataloader/commonjobloader.properties.
The MOVE_FINISHED_SHORT_JOBS parameter defines whether job array elements are individually moved from the live job database table(LSF_LIVE_JOB) to the historical jobs database table (LSF_FINISH_JOB), or whether job array elements in the job are moved together.
- When MOVE_FINISHED_SHORT_JOBS=true, when the end time of a finished job array element falls within the time defined by MOVE_FINISHED_JOBS_AFTER in $PERF_CONFDIR/dataloader/commonjobloader.properties, the job array element is moved from the LSF_LIVE_JOB database table to the LSF_FINISH_JOB database table. As a result, if there are many job arrays, running array elements will be in the LSF_LIVE_JOB database table and finished array elements in the LSF_FINISH_JOB database table, improving performance.
- When MOVE_FINISHED_SHORT_JOBS=false, job array elements are not moved from the live job database table(LSF_LIVE_JOB) to the historical jobs database table(LSF_FINISH_JOB) until all job array elements finish and the end time of the job array falls within the time defined by MOVE_FINISHED_JOBS_AFTER in $PERF_CONFDIR/dataloader/commonjobloader.properties.
- 5.4 Create partitions for the LSF_FINISH_JOB and LSF_FINISH_JOB_HOST tables to improve performance
- Log in to MySQL.
For example:
>mysql -u username -p password
>use pac;
- Back up your data.
mysql>rename table LSF_FINISH_JOB to LSF_FINISH_JOB_OLD;
mysql>rename table LSF_FINISH_JOB_HOST to LSF_FINISH_JOB_HOST_OLD;
- Drop the original database tables.
mysql> drop table LSF_FINISH_JOB;
mysql> drop table LSF_FINISH_JOB_HOST;
- Configure time-based partitions for the LSF_FINISH_JOB and LSF_FINISH_JOB_HOST tables.
The create_partition.sh script modifies partition_tables.sql to create partitions for the database tables LSF_FINISH_JOB and LSF_FINISH_JOB_HOST. The number of partitions is determined by the value defined in the parameter FINISH_JOB_TIME_TO_LIVE in
$GUI_CONFDIR/pmc.conf.
Go to ${PAC_TOP}/gui/3.0/bin and run create_partition.sh as root:
#./create_partition.sh
- Create time-based partitions in the database.
mysql> source partition_tables.sql
- Restore your data to the new partitioned database tables.
mysql> insert into LSF_FINISH_JOB select * from LSF_FINISH_JOB_OLD;
mysql> insert into LSF_FINISH_JOB_HOST select * LSF_FINISH_JOB_HOST_OLD;
- Test that the new database tables work in Platform Application Center.
- Start Platform Application Center services.
perfadmin start all
pmcadmin start
- Wait one day so that data is moved from the LSF_LIVE_JOB database table to the LSF_FINISH_JOB and LSF_FINISH_JOB_HOST database tables.
- Go into Platform Application Center, submit jobs, change filter options to display jobs that are older than one day, and check that historical jobs are displayed.
- If you are satisfied that everything works, you can go to step 8 and delete the _OLD database tables.
- If you encounter issues, follow the instructions to roll back in the database tables in
"6.2 Roll back changes to the database".
- Delete the _OLD database tables.
If you are satisfied that everything works in Platform Application Center, you can drop the _OLD database tables. Note, however, that you will not be able to roll back the database table changes if you delete the _OLD database tables.
mysql> drop table LSF_FINISH_JOB_OLD;
mysql> drop table LSF_FINISH_JOB_HOST_OLD;
- Uninstallation
- 6.1 Before uninstallation
Stop all IBM Platform Application Center services:
perfadmin stop all
pmcadmin stop
- 6.2 Roll back changes to the database
- Log in to MySQL.
For example:
>mysql -u username -p password
>use pac;
- Drop the new database tables.
mysql> drop table LSF_FINISH_JOB;
mysql> drop table LSF_FINISH_JOB_HOST;
- Restore your original database tables.
mysql>rename table LSF_FINISH_JOB_OLD to LSF_FINISH_JOB;
mysql>rename table LSF_FINISH_JOB_HOST_OLD to LSF_FINISH_JOB_HOST;
- 6.3 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.3-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.3-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
/opt/pac/gui/3.0/tomcat/webapps/platform/WEB-INF/classes/com/platform/gui/pac/job/db/JobDataDBManage.class
/opt/pac/gui/3.0/bin/pmcadmin
/opt/pac/gui/3.0/bin/create_partition.sh
/opt/pac/gui/3.0/bin/partition_tables.sql
/opt/pac/gui/3.0/bin/partition_tables.sql.empty
/opt/pac/perf/conf/dataloader/commonjobloader.properties
/opt/pac/perf/lsf/9.0/conf/dataloader/commonjobloader.properties
/opt/pac/perf/lsf/8.0/conf/dataloader/commonjobloader.properties
/opt/pac/perf/lsf/7.0/conf/dataloader/commonjobloader.properties
/opt/pac/perf/lsf/9.0/lib/perf_lsf_loader.jar
/opt/pac/perf/lsf/8.0/lib/perf_lsf_loader.jar
/opt/pac/perf/lsf/7.0/lib/perf_lsf_loader.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