Readme File for IBM® Platform Symphony 6.1.0.1 Interim Fix 461828

Readme File for: IBM® Platform Symphony
Product Release: 6.1.0.1
Update Name: Interim Fix 461828
Fix ID: sym-6.1.0-build461828-mumss
Publication Date: 28 July 2017

When the TASK_ATTRIBUTES table has many records to be deleted (that is, over 20,000,000 records), the purger service requires much time to complete the operation on the SQL Server database.

At the same time, if the Platform Symphony PLC service inserts many records into the TASK_ATTRIBUTES table, the SQL Server database can throw a deadlock error, which causes the purger service to not be able to delete records.

If the purger service encounters the deadlock error every time, the size of the TASK_ATTRIBUTES table becomes increasingly larger.

This fix helps reduce the chance of deadlock errors.

Contents

1. List of fixes

2. Download location

3. Product and components affected

4. Installation and configuration

5. List of files

6. Copyright and trademark information

1. List of fixes

APAR: P102308

2. Download location

Download interim fix 461828 from the following location https://www.ibm.com/eserver/support/fixes/

3. Product and components affected

Component name, Platform, Fix ID:

PERF, Windows x86_64, sym-6.1.0-build461828-mumss

4. Installation and configuration

System requirements

Windows x86_64

Before installation

1. Log on to the master host as the cluster administrator, stop your services:

  > egosh service stop plc

  > egosh service stop purger

Installation

1. Log on to the database host as database administrator, copy the sym6.1.0_win-x64_build461828.zip and decompress the file.

2. Update the database schema in SQL Server:

a.      Within the TASK_ATTRIBUTES table, note the PK_NAME of the Primary Key value.

b.      Open the update_soam_TASK_ATTRIBUTES.sql file for editing, and locate the following line:
DROP PK__TASK_ATT__B43784D66FDE5351

c.      Change the line to the following, using your real PK_NAME:
DROP PK_NAME

d.      Run the following SQL Server command:
osql -U user_name -P password -d db_name -i update_script

For example:

osql -U sa -P password -d sym6101 -i update_soam_TASK_ATTRIBUTES.sql

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 rollback script

Notes: 

·        For information about how to update a SQL Server database, refer to the chapter "Update a SQL Server database" in the Platform Symphony Knowledge Center, or $EGO_TOP\docs\symphony\6.1\upgrade_sym\sym_upgrade_db_schema_sqlserver_update.html.

·        If there are many records in the TASK_ATTRIBUTES table, this update can take a long time.

After installation

1. Log on to the master host as the cluster administrator, start your services:

  > egosh service start plc

  > egosh service start purger

Uninstallation

1. Log on to the master host as the cluster administrator, stop your services:

  > egosh service stop plc

  > egosh service stop purger

2. Log on to the database host as database administrator, roll back the database schema in SQL Server:

a.      Run the rollback_soam_TASK_ATTRIBUTES.sql script to roll back the database schema with the following SQL Server command:
osql -U user_name -P password -d db_name -i rollbak_script

For example:

osql -U sa -P password -d sym6101 -i rollback_soam_TASK_ATTRIBUTES.sql

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

Notes: 

·        For information about how to update a SQL Server database, refer to the chapter "Update a SQL Server database" in the Platform Symphony Knowledge Center, or $EGO_TOP\docs\symphony\6.1\upgrade_sym\sym_upgrade_db_schema_sqlserver_update.html.

·        If there are many records in the TASK_ATTRIBUTES table, this update can take a long time.

 3. Log on to the master host as the cluster administrator, start your services:

  > egosh service start plc

  > egosh service start purger

    5. List of files

rollback_soam_TASK_ATTRIBUTES.sql

update_soam_TASK_ATTRIBUTES.sql

    6. Copyright and trademark information

©Copyright IBM Corporation 2017

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.