IBM Platform
RTM 9.1.3 FP2 337896 Readme File
Abstract
337896: This Fix Pack includes all fixed issues and solutions included in RTM 9.1.3 Fix Pack 247832, and includes 16 new fixes and five new enhancements.
Description
Readme documentation for IBM Platform RTM 9.1.3 Fix Pack 337896 including installation-related instructions, prerequisites and co-requisites, and list of fixes.
This patch includes the following new fixes and enhancements:
Enhancement:
* In the list view of the grid detail page and the heuristic job detail page:
- Added Service Level (SLA) as an available column.
- Changed the State Changes column into a column that can be hidden.
- Moved the following columns to the left: Queue, SLA, User, User Group, App and Job Group, Exit Code.
- Exit Status provides more details: Appended "App" or "Sig" prefixes to the exit code based on the exit status code.
* Added support for Graph Static Boolean Resources in the "GRID - Cluster Shared Resources" data query.
Fix:
* APAR P100836 (SUP#247733): Resolved a user filter issue on the Grid > Job Details page.
* APAR P100832 (SUP#247698): Optimized partitioned tables that are created during the maintenance period.
* APAR P100846 (SUP#247820): Resolved SQL query errors that occur when big data is loaded by the heuristics data poller.
* APAR P100807 (SUP#246955): Fix to purge array jobs in DONE and EXIT states that are not in the grid_array table.
* APAR P100875 (SUP#248284): Optimized cluster dashboard performance by refactoring the Free Memory Slots Availability Graph.
* APAR P100962 (SUP#32977): Resolved an issue with the base time not working in the grid alert plugin.
* APAR P100909 (SUP#28541): Resolved SQL errors that occur when the peak utilization or license count is null.
* APAR P101004 (SUP#35467): Resolved project graphing not working when a project name is a whitespace.
* APAR P101058 (SUP#37023): Removed PHP errors after deploying the RTM 9.1.3 Fix Pack 247832.
* APAR P101059 (SUP#37162): Resolved artifacts in certain areas of the GUI after deploying the RTM 9.1.3 CVE patch.
* APAR P101065 (SUP#35760): Resolved a SQL error that occurs when using the "Search" filter on the license daily statistics page.
* SUP#41249: Fix to resolve license poller database reconnection failure.
* Resolved column size issues in alert creation.
* Resolved the data limit default in the metadata setting.
* Resolved an alert mail sending issue when emails defined in the metadata setting are for all clusters.
* Removed the clog hard limit for the maximum number of lines (hard coded as 1000 lines).
Readme file for:
IBM® Platform RTM
Product/Component Release:
9.1.3
Update Name:
FixPack 2
Fix ID:
PlatformRTM-9.1.3-FP2
Publication date: Apr 20, 2015
Last modified date: Apr 20, 2015
Contents:
1. List of fixes
2. Download location
3. Products or components affected
4. System requirements
5. Installation and configuration
6. List of files
7. Copyright and trademark information
1.
List of fixes
Enhancement:
* In the list view of the grid detail page and the heuristic job detail page:
- Added Service Level (SLA) as an available column.
- Changed the State Changes column into a column that can be hidden.
- Moved the following columns to the left: Queue, SLA, User, User Group, App and Job Group, Exit Code.
- Exit Status provides more details: Appended "App" or "Sig" prefixes to the exit code based on the exit status code.
* Added support for Graph Static Boolean Resources in the "GRID - Cluster Shared Resources" data query.
Fix:
* APAR P100836 (SUP#247733): Resolved a user filter issue on the Grid > Job Details page.
* APAR P100832 (SUP#247698): Optimized partitioned tables that are created during the maintenance period.
* APAR P100846 (SUP#247820): Resolved SQL query errors that occur when big data is loaded by the heuristics data poller.
* APAR P100807 (SUP#246955): Fix to purge array jobs in DONE and EXIT states that are not in the grid_array table.
* APAR P100875 (SUP#248284): Optimized cluster dashboard performance by refactoring the Free Memory Slots Availability Graph.
* APAR P100962 (SUP#32977): Resolved an issue with the base time not working in the grid alert plugin.
* APAR P100909 (SUP#28541): Resolved SQL errors that occur when the peak utilization or license count is null.
* APAR P101004 (SUP#35467): Resolved project graphing not working when a project name is a whitespace.
* APAR P101058 (SUP#37023): Removed PHP errors after deploying the RTM 9.1.3 Fix Pack 247832.
* APAR P101059 (SUP#37162): Resolved artifacts in certain areas of the GUI after deploying the RTM 9.1.3 CVE patch.
* APAR P101065 (SUP#35760): Resolved a SQL error that occurs when using the "Search" filter on the license daily statistics page.
* SUP#41249: Fix to resolve license poller database reconnection failure.
* Resolved column size issues in alert creation.
* Resolved the data limit default in the metadata setting.
* Resolved an alert mail sending issue when emails defined in the metadata setting are for all clusters.
* Removed the clog hard limit for the maximum number of lines (hard coded as 1000 lines).
2.
Download Location
Download FixPack 2 from the following location:
http://www-933.ibm.com/support/fixcentral
3.
Products or components affected
Product/Component Name, Platform, File Name:
IBM Platform RTM, Linux,
RTM server framework(cacti)
RTM core plugin(grid)
RTM core plugin(license)
RTM Clog plugin
RTM metadata plugin
RTM gridalarms plugin
RTM heuristics plugin
RTM license datapoller daemon
Nectar plugin
Superlinks plugin
Syslog plugin
Thold plugin
4.
System requirements
RTM master host: Linux x86_64
5.
Installation and configuration
5.1 Before installation
1) Back up all the affected RTM files into cacti_backup_for_9_1_3_FP2.tar
# cd RTM_TOP
# tar -cvf cacti_backup_for_9_1_3_FP2.tar cacti/auth_changepassword.php \
cacti/auth_login.php \
cacti/cdef.php \
cacti/data_input.php \
cacti/data_queries.php \
cacti/data_sources.php \
cacti/data_templates.php \
cacti/graph_settings.php \
cacti/graphs_items.php \
cacti/graphs_new.php \
cacti/graphs.php \
cacti/graph_templates_inputs.php \
cacti/graph_templates_items.php \
cacti/graph_templates.php \
cacti/graph_view.php \
cacti/graph_xport.php \
cacti/host.php \
cacti/host_templates.php \
cacti/include/global_arrays.php \
cacti/include/top_graph_header.php \
cacti/include/top_header.php \
cacti/install/index.php \
cacti/lib/api_device.php \
cacti/lib/api_poller.php \
cacti/lib/data_query.php \
cacti/lib/functions.php \
cacti/lib/graph_export.php \
cacti/lib/graph_variables.php \
cacti/lib/html_form_template.php \
cacti/lib/html_tree.php \
cacti/lib/html_validate.php \
cacti/lib/import.php \
cacti/lib/rrd.php \
cacti/lib/snmp.php \
cacti/lib/template.php \
cacti/lib/utility.php \
cacti/lib/variables.php \
cacti/plugins/clog/clog_webapi.php \
cacti/plugins/gridalarms/gridalarms_alarm_edit.php \
cacti/plugins/gridalarms/gridalarms_template_edit.php \
cacti/plugins/gridalarms/includes/settings.php \
cacti/plugins/gridalarms/lib/gridalarms_functions.php \
cacti/plugins/gridalarms/notify_lists.php \
cacti/plugins/grid/database_optimization.php \
cacti/plugins/grid/database_replay_daily_stats.php \
cacti/plugins/grid/grid_add_trees.php \
cacti/plugins/grid/grid_bhosts_closed.php \
cacti/plugins/grid/grid_bhosts.php \
cacti/plugins/grid/grid_bjobs.php \
cacti/plugins/grid/grid_bmgroup.php \
cacti/plugins/grid/grid_clusters.php \
cacti/plugins/grid/grid_elim_functions.php \
cacti/plugins/grid/grid_elim_graphs.php \
cacti/plugins/grid/grid_elim_graph_templates_items.php \
cacti/plugins/grid/grid_elim_templates.php \
cacti/plugins/grid/grid_lsgload.php \
cacti/plugins/grid/grid_lsload.php \
cacti/plugins/grid/grid_pollers.php \
cacti/plugins/grid/grid_settings_system.php \
cacti/plugins/grid/grid_summary.php \
cacti/plugins/grid/include/grid_ajax.js \
cacti/plugins/grid/lib/grid_functions.php \
cacti/plugins/grid/lib/grid_partitioning.php \
cacti/plugins/grid/poller_grid.php \
cacti/plugins/grid/setup.php \
cacti/plugins/heuristics/heuristics_jobs.php \
cacti/plugins/heuristics/poller_heuristics.php \
cacti/plugins/license/include/lic_functions.php \
cacti/plugins/license/lic_dailystats.php \
cacti/plugins/license/lic_lm_fusion.php \
cacti/plugins/license/lic_pollers.php \
cacti/plugins/license/lic_servers.php \
cacti/plugins/meta/lib/metadata_api.php \
cacti/plugins/meta/metadata.php \
cacti/plugins/nectar/nectar_functions.php \
cacti/plugins/nectar/nectar_webapi.php \
cacti/plugins/nectar/setup.php \
cacti/plugins.php \
cacti/plugins/ptskin/setup.php \
cacti/plugins/superlinks/setup.php \
cacti/plugins/superlinks/superlinks-mgmt.php \
cacti/plugins/syslog/functions.php \
cacti/plugins/syslog/syslog_alerts.php \
cacti/plugins/syslog/syslog.php \
cacti/plugins/syslog/syslog_process.php \
cacti/plugins/syslog/syslog_removal.php \
cacti/plugins/syslog/syslog_reports.php \
cacti/plugins/thold/check-thold.php \
cacti/plugins/thold/includes/settings.php \
cacti/plugins/thold/listthold.php \
cacti/plugins/thold/setup.php \
cacti/plugins/thold/thold_add.php \
cacti/plugins/thold/thold_functions.php \
cacti/plugins/thold/thold_graph.php \
cacti/plugins/thold/thold.php \
cacti/plugins/thold/thold_templates.php \
cacti/resource/snmp_queries/interface.xml \
cacti/rra.php \
cacti/scripts/query_host_cpu.php \
cacti/scripts/ss_grid_proj_stats.php \
cacti/scripts/ss_grid_sres_stats.php \
cacti/scripts/ss_sql.php \
cacti/settings.php \
cacti/templates_export.php \
cacti/tree.php \
cacti/user_admin.php \
cacti/utilities.php \
rtm/bin/licpollerd
5.2 Installation steps
1).Access database to alter column base_time in table gridalarms_alarm and gridalarms_template.
# mysql cacti
mysql> ALTER TABLE gridalarms_alarm MODIFY COLUMN `base_time` int(10) unsigned DEFAULT '0';
mysql> ALTER TABLE gridalarms_template MODIFY COLUMN `base_time` int(10) unsigned DEFAULT '0';
2).Download and extract RTM 9.1.3 FixPack2 tarball to the RTM_TOP directory, including:
RTM Server package for all Linux x64:
rtm-server-9.1.3-FP2-x64.tar.gz
RTM DataPoller package for RHEL 5 x64:
rtm-poller-9.1.3-FP2-rhel5-x64.tar.gz
RTM DataPoller package for RHEL 6/7 x64:
rtm-poller-9.1.3-FP2-rhel6-x64.tar.gz
RTM DataPoller package for SLES 10/11 x64:
rtm-poller-9.1.3-FP2-sles10-x64.tar.gz
# cd RTM_TOP
# tar -zxvf rtm-server-9.1.3-FP2-x64.tar.gz
# tar -zxvf rtm-poller-9.1.3-FP2-<LinuxDistro>.tar.gz
5.3 After installation
Restart licpollerd service
# service licpollerd restart
5.4
Uninstallation
1).Roll back the patch by using the back up package
# cd RTM_TOP
# tar -xvf cacti_backup_for_9_1_3_FP2.tar
2).Access Cacti database to revert column base_time in table gridalarms_alarm and gridalarms_template.
# mysql cacti
mysql> ALTER TABLE gridalarms_alarm MODIFY COLUMN `base_time` timestamp NOT NULL default '0000-00-00 00:00:00';
mysql> ALTER TABLE gridalarms_template MODIFY COLUMN `base_time` timestamp NOT NULL default '0000-00-00 00:00:00';
6.
List of files
cacti/auth_changepassword.php
cacti/auth_login.php
cacti/cdef.php
cacti/data_input.php
cacti/data_queries.php
cacti/data_sources.php
cacti/data_templates.php
cacti/graph_settings.php
cacti/graphs_items.php
cacti/graphs_new.php
cacti/graphs.php
cacti/graph_templates_inputs.php
cacti/graph_templates_items.php
cacti/graph_templates.php
cacti/graph_view.php
cacti/graph_xport.php
cacti/host.php
cacti/host_templates.php
cacti/include/global_arrays.php
cacti/include/top_graph_header.php
cacti/include/top_header.php
cacti/install/index.php
cacti/lib/api_device.php
cacti/lib/api_poller.php
cacti/lib/data_query.php
cacti/lib/functions.php
cacti/lib/graph_export.php
cacti/lib/graph_variables.php
cacti/lib/html_form_template.php
cacti/lib/html_tree.php
cacti/lib/html_validate.php
cacti/lib/import.php
cacti/lib/rrd.php
cacti/lib/snmp.php
cacti/lib/template.php
cacti/lib/utility.php
cacti/lib/variables.php
cacti/plugins/clog/clog_webapi.php
cacti/plugins/gridalarms/gridalarms_alarm_edit.php
cacti/plugins/gridalarms/gridalarms_template_edit.php
cacti/plugins/gridalarms/includes/settings.php
cacti/plugins/gridalarms/lib/gridalarms_functions.php
cacti/plugins/gridalarms/notify_lists.php
cacti/plugins/grid/database_optimization.php
cacti/plugins/grid/database_replay_daily_stats.php
cacti/plugins/grid/grid_add_trees.php
cacti/plugins/grid/grid_bhosts_closed.php
cacti/plugins/grid/grid_bhosts.php
cacti/plugins/grid/grid_bjobs.php
cacti/plugins/grid/grid_bmgroup.php
cacti/plugins/grid/grid_clusters.php
cacti/plugins/grid/grid_elim_functions.php
cacti/plugins/grid/grid_elim_graphs.php
cacti/plugins/grid/grid_elim_graph_templates_items.php
cacti/plugins/grid/grid_elim_templates.php
cacti/plugins/grid/grid_lsgload.php
cacti/plugins/grid/grid_lsload.php
cacti/plugins/grid/grid_pollers.php
cacti/plugins/grid/grid_settings_system.php
cacti/plugins/grid/grid_summary.php
cacti/plugins/grid/include/grid_ajax.js
cacti/plugins/grid/lib/grid_functions.php
cacti/plugins/grid/lib/grid_partitioning.php
cacti/plugins/grid/poller_grid.php
cacti/plugins/grid/setup.php
cacti/plugins/heuristics/heuristics_jobs.php
cacti/plugins/heuristics/poller_heuristics.php
cacti/plugins/license/include/lic_functions.php
cacti/plugins/license/lic_dailystats.php
cacti/plugins/license/lic_lm_fusion.php
cacti/plugins/license/lic_pollers.php
cacti/plugins/license/lic_servers.php
cacti/plugins/meta/lib/metadata_api.php
cacti/plugins/meta/metadata.php
cacti/plugins/nectar/nectar_functions.php
cacti/plugins/nectar/nectar_webapi.php
cacti/plugins/nectar/setup.php
cacti/plugins.php
cacti/plugins/ptskin/setup.php
cacti/plugins/superlinks/setup.php
cacti/plugins/superlinks/superlinks-mgmt.php
cacti/plugins/syslog/functions.php
cacti/plugins/syslog/syslog_alerts.php
cacti/plugins/syslog/syslog.php
cacti/plugins/syslog/syslog_process.php
cacti/plugins/syslog/syslog_removal.php
cacti/plugins/syslog/syslog_reports.php
cacti/plugins/thold/check-thold.php
cacti/plugins/thold/includes/settings.php
cacti/plugins/thold/listthold.php
cacti/plugins/thold/setup.php
cacti/plugins/thold/thold_add.php
cacti/plugins/thold/thold_functions.php
cacti/plugins/thold/thold_graph.php
cacti/plugins/thold/thold.php
cacti/plugins/thold/thold_templates.php
cacti/resource/snmp_queries/interface.xml
cacti/rra.php
cacti/scripts/query_host_cpu.php
cacti/scripts/ss_grid_proj_stats.php
cacti/scripts/ss_grid_sres_stats.php
cacti/scripts/ss_sql.php
cacti/settings.php
cacti/templates_export.php
cacti/tree.php
cacti/user_admin.php
cacti/utilities.php
rtm/bin/licpollerd
7.
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.