IBM Support

IBM Application Performance Management 8.1.3.0 8.1.3.0-IBM-IPM-MSSQL-AGENT-IF0001 Readme

Readme file for: Monitoring Agent for Microsoft SQL Server for IBM Performance Management 8.1.3.0 Interim Fix 1
Product/Component Release: 8.1.3.0
Update Name: 8.1.3.0-IBM-IPM-MSSQL-AGENT-IF0001
Fix ID: 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001, 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN64-IF0001
Publication Date: 16 November 2017
Last modified date: 16 November 2017

Download location

IMPORTANT NOTE: To download this update, you must first login to IBM Fix Central. Once logged in, you may select from the individual download packages. When selecting fixes, ensure your download options are set to "Include requisites: Yes".
http://www.ibm.com/support/fixcentral/

Below is a list of components, platforms, and file names that apply to this Readme file.

Fix Download for Windows

Product/Component Name: Platform: Fix:
IBM Application Performance Management Windows
8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001
IBM Application Performance Management Windows
8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN64-IF0001

Prerequisites and co-requisites

General description
This is a cumulative interim fix for the Monitoring agent for Microsoft SQL Server provided with IBM Performance Management family of products, Version 8.1.3.0
It includes fixes for the Monitoring agent for Microsoft SQL Server and upgrades the agent from version 06.31.09.00 to version 06.31.09.01 and it's application support to 6.3.1.0901.

Platforms and prerequisites
The Monitoring Agent for Microsoft SQL Server is supported on the platforms documented here.

The interim fix for the Microsoft SQL Server agent is intended to be applied to the Monitoring Agent for Microsoft SQL Server version 06.31.09.00 which is provided with:

IBM Monitoring, Version 8.1.3.0
IBM Application Performance Management, Version 8.1.3.0
IBM Application Performance Management Advanced, Version 8.1.3.0.

Known issues

None

Known limitations

None

Installation information

Prior to installation

The Microsoft SQL Server agent version 06.31.09.00 must be installed and running before applying the agent interim fix.

Installing

Installing the Monitoring Agent for Microsoft SQL Server application support

  1. Download koq_sda_6.3.1.0901.jar file from IBM Fix Central to a temporary directory (e.g. /tmp/if01-patch) on the computer where you installed the Performance Management server.

  2. Run the following commands on the IBM Performance Management server:

    1. cd <APM-SERVER-HOME>/ccm
    2. ./install_app_support.sh -force <path to the koq_sda_6.3.1.0901.jar file>

      For example: ./install_app_support.sh -force /tmp/if01-patch/koq_sda_6.3.1.0901.jar

  3. Perform these steps on the Performance Management console:

    1. Edit each application that contains the Microsoft SQL Server agent and delete the agent from the application
    2. Save the application.
    3. Then edit the application a second time and add the agent components back to the application.

Installing the agent interim fix

  1. Download the patch bundle from Fix Central for each OS type where your agent is installed:
    • If the agent is installed on 32-bit Windows, download 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001.tar
    • If the agent is installed on 64-bit Windows, download 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN64-IF0001.tar
  2. Unpack the bundle on each computer system where the agent is already installed by using unzip on Windows.
    e.g.
    unzip 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001.tar
  3. Enter the created directory
  4. Run the apmpatch.sh/bat tool as the same user who installed the agent.
    apmpatch.bat <APM-AGENT-HOME>

    where the <APM-AGENT-HOME> value specifies the directory where the agent is installed. This value is a required parameter for Windows.

Performing the necessary tasks after installation of the interim fix

A successful installation modifies the Microsoft SQL Server agent version to 06.31.09.01. Ensure that the /bin/cinfo -t output for the Monitoring Agent for Microsoft SQL Server is '06.31.09.01'.

The agent interim fix installation logs are written to the following directory:

<APM-AGENT-HOME>/logs/

Troubleshooting installation problems from the Support site

For more detailed information, refer to the Troubleshooting and support Guide:
http://www.ibm.com/support/knowledgecenter/SSHLNR_8.1.3/com.ibm.pm.doc/install/trouble_intro.htm

Uninstalling if necessary

This maintenance package cannot be rolled back. If necessary you can uninstall and reinstall the monitoring agent and patches.

For detailed instructions to uninstall monitoring agents, please refer to the IBM Performance Management guide, here:
http://www.ibm.com/support/knowledgecenter/SSHLNR_8.1.3/com.ibm.pm.doc/install/uninstall_agents.htm

Additional information

The Secure Hash Algorithm 1 (SHA1) checksum of the image is as follows:
SHA1(8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001.zip)= 047e0fdd2f6743d1b6eb733a53c669545780b909
SHA1(8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN64-IF0001.zip)= 121a03fe2cee8fc0b0e35ba502af8ada7a7841af
SHA1(koq_sda_6.3.1.0901.jar) = 2f97ccf0727fe294cbff99c63a47170a8eee032a

Image Contents
The following files implement this fix.

- 8.1.3.0-IBM-IPM-MSSQL-AGENT-IF0001.readme.html - This README file


- koq_sda_6.3.1.0901.jar - File for updating application support on IBM Performance Management server)

- 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001.zip - For extracting patch files use the WinZip or similar zip utility.

Extracting the above bundle (.zip) creates the following directory and patch files:

8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN32-IF0001/
|-- apmpatch.bat
|-- patches
|-- patch.properties

- 8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN64-IF0001.zip - For extracting patch files use the WinZip or similar zip utility.

Extracting the above bundle (.zip) creates the following directory and patch files:

8.1.3.0-IBM-IPM-MSSQL-AGENT-WIN64-IF0001/
|-- apmpatch.bat
|-- patches
|-- patch.properties

New Features

The following changes are included in Microsoft SQL Server agent interim fix:

  • 127511: Add tolerance support for SQL Server 2016
  • Defect fixes and other stability improvements


List of fixes

The following problems are addressed by this interim fix.

APARs

  • None.

Agent defects:
  • 127609: The collector process is crashing while accessing invalid parameter of the request.
  • 127610: Memory leak in Table Detail attribute group.
  • 127611: Crash observed while iterating container.
  • 127612: Collector crashed with SQl Agent 8.1.4.0

Enhancements:
  • None

Superseded fixes:
  • None

APARS and defects included from superseded fixes:
  • None


Document change history


Version Date Description of change
1.0 14 November 2017 Initial Version
1.1 16 November 2017 Minor corrections

Document information

More support for: IBM Application Performance Management

Reference #: 00003599

Modified date: 16 November 2017