IBM Spectrum LSF RTM 10.2 Fix 600164 Readme


Abstract
Prevents the blocking of queries when the structure is incorrect in the grid_guarantee_pool_hosts table.


Description

Readme documentation for IBM Spectrum LSF RTM 10.2 Fix 600164 including installation-related instructions, prerequisites and co-requisites, and list of enhancements.

This fix resolves the following issue:
An incorrect structure on the grid_guarantee_pool_hosts table causes queries to be blocked.


Readme file for: IBM® Spectrum LSF RTM

Product/Component Release: 10.2

Update Name: Fix 600164

Fix ID: rtm-10.2-build600164

Publication date: Jan. 29, 2021

Last modified date: Jan. 29, 2021


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 P104063


2.   Download location


Download Fix 600164 from the following location: http://www-933.ibm.com/support/fixcentral


3.   Products or components affected


RTM Database


4.   System requirements 


N/A


5.   Installation and configuration


 • In this document, RTM_TOP describes the top-level IBM Spectrum LSF RTM Server installation directory.

        For example, this directory may refer to the following:
          * /opt/IBM/


5.1    Before installation

 

    N/A


5.2    Installation steps


    1) Run following SQL in RTM database

       

        ALTER TABLE grid_guarantee_pool_hosts MODIFY COLUMN owner varchar(40) NOT NULL DEFAULT '';
        ALTER TABLE grid_guarantee_pool_hosts ADD INDEX clusterid_host(clusterid, host);

        ALTER TABLE grid_guarantee_pool_hosts ADD INDEX clusterid_owner(clusterid, owner);



5.3    After installation


    N/A

 

5.4    Uninstallation


    1)  Run following SQL in RTM database


       ALTER TABLE grid_guarantee_pool_hosts MODIFY COLUMN owner varchar(255) NOT NULL DEFAULT '-';
        ALTER TABLE grid_guarantee_pool_hosts DROP INDEX clusterid_host;

        ALTER TABLE grid_guarantee_pool_hosts DROP INDEX clusterid_owner;



6.   List of files


N/A


7.   Copyright and trademark information

© Copyright IBM Corporation 2021


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 http://www.ibm.com/legal/copytrade.shtml.