IBM Platform Symphony 6.1.0.1 Interim Fix 236813 Readme File

Abstract

When the RESOURCE_METRICS table has too many records to query (that is, 70,000,000), the "Cluster Slot Utilization - EGO" and "Host Resource Usage" reports are unavailable for a long time.

Description

·    When the RESOURCE_METRICS table has too many records to query (that is, 70,000,000), and the user logs in to PMC, goes to [Quick Links] -> [Reports] and click the "Cluster Slot Utilization - EGO" or "Host Resource Usage" report, the reports are unavailable for a long time.

This fix addresses the following issues:

·    When the RESOURCE_METRICS table has too many records to query (that is, 70,000,000), the "Cluster Slot Utilization - EGO" and "Host Resource Usage" reports are unavailable for a long time.

This fix patch applies only to the following platform:

·    Windows 64-bit

Readme file for: IBM® Platform Symphony

Product/Component Release: 6.1.0.1

Update Name: Fix 236813

Fix ID: sym-6.1.0.1-build236813

Publication date: 30 June 2014

Last modified date: 30 June 2014

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

APAR#P100558: 2 reports are not displayed in PMC Reports.

2. Download Location

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

3. Products or components affected

Product/Component Name:

Platform Symphony/plc

4. System requirements

SQL Server 2005

5. Installation and configuration

5.1   Prerequisites 

1.   Build #229536 installed.

5.2 Before installation

1. Stop the running service.

Log on to the master host as the cluster administrator and run:

> egosh user logon -u Admin -x Admin

> egosh service stop plc purger

5.3 Installation steps

1.    Update the database schema in the SQL Server.

> Run the script "update_ego_RESOURCE_METRICS_236813.sql" to update the database schema.

> SQL server command: osql -U user_name -P password -d db_name -i update_script

Where:

·    user_name is the user name on the database server.

·    password is the password for this user name on the database server.

·    db_name is the reporting database name.

·    update_script is the name of the update script.

 Note:

·    For information about how to update an SQL Server database, refer to the chapter "Update a SQL Server database" in the Symphony Knowledge Center.

·    If there are a large number of records in the RESOURCE_METRICS table, the update takes a long time.

5.4 After installation

1. Start the services.

Log on to the master host as the cluster administrator and run:

> egosh user logon -u Admin -x Admin

> egosh service start plc purger

5.5 Uninstallation

1. Stop the running service.

Log on to the master host as the cluster administrator and run:

> egosh user logon -u Admin -x Admin

> egosh service stop plc purger

2. Rollback the database schema in the SQL Server.

> Run the script "rollback_ego_RESOURCE_METRICS_236813.sql" to roll back the database schema.

> SQL server command: osql -U user_name -P password -d db_name -i rollback_script

Where:

·    user_name is the user name on the database server.

·    password is the password for this user name on the database server.

·    db_name is the reporting database name.

·    rollback_script is the name of the rollback script.

  Note:

·    For information about how to update an SQL Server database, refer to the chapter "Update a SQL Server database" in the Symphony Knowledge Center.

·    If there are a large number of records in the RESOURCE_METRICS table, the rollback takes a long time.

3.   Start the services.

> egosh service start plc purger

6. List of files

·    update_ego_RESOURCE_METRICS_236813.sql

·    rollback_ego_RESOURCE_METRICS_236813.sql

7. Copyright and trademark information

© Copyright IBM Corporation 2014

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.