IBM Spectrum LSF Analytics 9.1.4 Fix 441081 Readme

Abstract

P102089  Fix to resolve the issue where the JOB_GROUP column size is set too small in Chargeback tables.

Description

Readme documentation for IBM Spectrum LSF Analytics 9.1.4 Fix 441081 including installation-related instructions, prerequisites and co-requisites, and list of fixes.
This fix addresses the following issue:
The JOB_GROUP column size is set too small in Chargeback tables, causing Workload Slots Charge ETL failure. This fix alters the column width in two tables.

Readme file for: IBM® Spectrum LSF Analytics
Product/Component Release: 9.1.4
Update Name: Fix 441081
PMR/APAR: 40965,227,000/P102089
Fix ID: build441081_schema
Publication date:  17 Feb 2017
Last modified date: 17 Feb 20167

Contents:

• List of fixes
• Download location
• Product notifications
• Products or components affected
• System requirements
• Installation and configuration
• List of files
• Copyright and trademark information

• List of fixes

P102089

• Download Location

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

• Product notifications

To receive information about product solution and patch updates automatically, subscribe to product notifications on the My notifications page http://www.ibm.com/support/mynotifications/ on the IBM Support website (http://support.ibm.com). You can edit your subscription settings to choose the types of information you want to get notification about, for example, security bulletins, fixes, troubleshooting, and product enhancements or documentation changes.

• Products or components affected

IBM Spectrum LSF Analytics Database

• System requirements
  

ALL

• Installation and configuration

 • ANALYTICS_SERVER_TOP describes the top-level IBM Spectrum LSF Analytics server installation directory.

        For example, this directory may refer to the following:
          * C:\IBM\Spectrum LSF Analytics 

6.1 Before installation

              6.1.1    Download the patch from Fix Central.

                   * For IBM Spectrum LSF Analytics Database: build441081_schema.zip

 6.2 Installation steps

             6.2.1  Apply IBM Spectrum LSF Analytics Database patch.

                  6.2.1.1  Stop IBM Spectrum LSF Analytics Server
                            1. Log into the IBM Spectrum LSF Analytics Server as Analytics user.

                            2. Run the following command to stop IBM Spectrum LSF Analytics service:

                                * Windows ANALYTICS_SERVER_TOP\bin\perfadmin.bat stop pats

                  6.2.1.2  Apply patch for IBM Spectrum LSF Analytics Database patch to alter table RPT_CHARGE_WORKLOAD_SLOTS_DAILY and RPT_CHARGE_SUMMARY_DAILY
                             1. Log in to the Analytics database host and extract the following schema package:
                                 build441081_schema.zip.

                             2. Run the vsql command.    
                                 <VERTICA_ROOT>/bin/vsql -d ${database_name} -p ${port} -U ${user_name} -w ${password} "     
                                 where:
                                   - <VERTICA_ROOT> is the Vertica installation directory. The default is /opt/vertica
                                   - ${database_name} is the name of the database.
                                   - ${port} is the port number to connect to the database. The default is 5433
                                   - ${user_name} is the name of the Analytics database user.
                                  - ${password} is the password for the Analytics database user.

                                  For example,                
                                /opt/vertica/bin/vsql -d analyticsdb -p 5433 -U userA -w mypasswd                                 

                             3. Run the following command to create the data schema:
                                 \i build441081_schema/schema/SQL_Patch.sql

                    6.2.1.3 Start IBM Spectrum LSF Analytics Server
                           1. Log into the IBM Spectrum LSF Analytics Server as Analytics user.

                           2. Run the following command to start IBM Spectrum LSF Analytics service:

                                * Windows ANALYTICS_SERVER_TOP\bin\perfadmin.bat start pats

        6.3 After installation

              None

        6.4 Uninstallation

             6.4.1  Uninstall IBM Spectrum LSF Analytics Database patch.

                  6.4.1.1  Stop IBM Spectrum LSF Analytics Server
                            1. Log into the IBM Spectrum LSF Analytics Server as Analytics user.

                            2. Run the following command to stop IBM Spectrum LSF Analytics service:

                                * Windows ANALYTICS_SERVER_TOP\bin\perfadmin.bat stop pats

                  6.4.1.2  Uninstall patch for IBM Spectrum LSF Analytics Database patch to alter table RPT_CHARGE_WORKLOAD_SLOTS_DAILY and RPT_CHARGE_SUMMARY_DAILY
                              1. Run the vsql command.   
                                 <VERTICA_ROOT>/bin/vsql -d ${database_name} -p ${port} -U ${user_name} -w ${password} "    
                                 where:
                                   - <VERTICA_ROOT> is the Vertica installation directory. The default is /opt/vertica
                                   - ${database_name} is the name of the database.
                                   - ${port} is the port number to connect to the database. The default is 5433
                                   - ${user_name} is the name of the Analytics database user.
                                  - ${password} is the password for the Analytics database user.

                                  For example,               
                                /opt/vertica/bin/vsql -d analyticsdb -p 5454 -U userA -w mypasswd                                

                             2. Run the following command to create the data schema:
                                 \i build441081_schema/schema/SQL_Patch_rollback.sql

                    6.4.1.3 Start IBM Spectrum LSF Analytics Server
                           1. Log into the IBM Spectrum LSF Analytics Server as Analytics user.

                           2. Run the following command to start IBM Spectrum LSF Analytics service:

                                * Windows ANALYTICS_SERVER_TOP\bin\perfadmin.bat start pats

• List of files

build441081_schema
├── SQL_Patch_rollback.sql
└── SQL_Patch.sql

• 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