IBM Platform Analytics 9.1.0.0 Fix 34801 Readme File


Abstract

D-APAR P101008: SLA loader required to support LSF GSLA.

Description

Readme documentation for IBM Platform Analytics 9.1.0.0 fix 34801 including installation-related instructions, prerequisites and co-requisites, and list of fixes.

SLA loader required to support LSF GSLA.


Readme file for: IBM® Platform Analytics

Product/Component Release: 9.1.0.0

Update Name: Fix 34801

Fix ID: build34801_node_linux64, build34801_schema

Publication date: 21 March 2015

Last modified date: 20 March 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

D-APAR:  P101008(Solution#216896): SLA loader required to support LSF GSLA.

 

2.   Download Location

 

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

 

3.   Products or components affected

 

Affected components include: 

  IBM Platform Analytics Node

  IBM Platform Analytics Schema

 

4.   System requirements

 

None

 


5.   Installation and configuration

  

In this document, ANALYTICS_TOP describes the top-level IBM Platform Analytics installation directory.

For example, this directory may refer to the following:

* Linux: /opt/IBM/PlatformAnalytics


5.1           Installation steps

5.1.1     Log in to the Analytics database host.
5.1.2     (Optional) Set the VERTICA_ROOT environment variable to the Vertica installation directory.
            If you have installed the Analytics database in the default location, set it to /opt/vertica.
5.1.3     Download and extract the database schema package build34801_schema.zip.
5.1.4     Navigate to the schema/Vertica directory containing your database schema scripts.
5.1.5     Run the upgrade_schema.sh script to upgrade the database:
            sh upgrade_schema.sh <user_name> <password> <database_name> <port>
            where:
                * user_name is the name of the Analytics database user.
                * password is the password for the database user.
                * database_name is the name of the database.
                * port is the TCP port number or the local socket file extension in which the
                  server is listening for connections. The default port number is 5433.
5.1.6     Download and extract patch build34801_node_linux64.zip from the IBM Platform FTP site.
            For example,
                unzip build34801_node_linux64.zip
5.1.7     Apply the patch with the patch installer.
            Run the following command and follow the prompts to apply the patch:
                * LINUX/UNIX: ANALYTICS_TOP/patch_tools/pinstall.sh     
5.1.8     Enable lsfslaloader
            Modify ANALYTICS_TOP/conf/plc/plc_lsf.xml
                Navigate to line "<DataLoader Name="lsfslaloader" Interval="300" Enable="false" LoadXML="dataloader/lsfsla.xml" />" and change "false" to "true".    
5.1.9     Add lsfgrploader
            Modify ANALYTICS_TOP/conf/plc/plc_lsf.xml
                Add line "<DataLoader Name="lsfgrploader" Interval="300" Enable="true" LoadXML="dataloader/lsfguarrespools.xml" />"  under line "<DataLoader   Name="lsfslaloader" Interval="300" Enable="true" LoadXML="dataloader/lsfsla.xml" />"    
5.1.10   Start the PLC service.
            Run the following command to start the PLC service.
                * LINUX/UNIX: perfadmin start plc

5.2          Uninstallation


5.2.1     Log in to the Analytics database host.
5.2.2     (Optional) Set the VERTICA_ROOT environment variable to the Vertica installation directory. If you have installed the Analytics database in the default location, set it to /opt/vertica.
5.2.3     Navigate to the schema/Vertica directory containing your database schema scripts.
5.2.4     Run the rollback_schema.sh script to rollback the database:
            sh rollback_schema.sh <user_name> <password> <database_name> <port>
            where:
                * user_name is the name of the Analytics database user.
                * password is the password for the database user.
                * database_name is the name of the database.
                * port is the TCP port number or the local socket file extension in which the server is listening for connections. The default port number is 5433.      
5.2.5     Run puninst.sh to uninstall the node patch.

6.   List of files


build34801_node_linux64.
|-- conf
|   `-- dataloader
|       |-- lsfguarrespools.properties
|       |-- lsfguarrespools.xml
|       `-- lsfsla.xml
|-- lsf
|   |-- 8.0
|   |   |-- lib
|   |   |   `-- perf_lsf_loader.jar
|   |   `-- linux-x86_64
|   |       `-- lib
|   |           |-- libgrp.so
|   |           `-- libsla.so
|   `-- 9.0
|       |-- lib
|       |   `-- perf_lsf_loader.jar
|       `-- linux-x86_64
|           `-- lib
|               |-- libgrp.so
|               `-- libsla.so
`-- patch_install
    |-- filelist.db
    |-- fixlist.db
    `-- patchinfo.txt

build34801_schema

`-- schema
    `-- Vertica
        |-- bin
        |   |-- LSF_SLA_restore.sql
        |   |-- LSF_SLA_rollback.sql
        |   |-- LSF_SLA_rollback_restore.sql
        |   |-- LSF_SLA_upgrade.sql
        |   |-- PATCH_INFO.sql
        |   `-- PATCH_INFO_rollback.sql
        |-- rollback_schema.sh
        `-- upgrade_schema.sh

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.