IBM Support

Readme for 7.1.6-TIV-ITM_DB2-FP0000

Release Notes


Abstract

Readme file for 7.1.6-TIV-ITM_DB2-FP0000 release.

© Copyright International Business Machines Corporation 2023.
All rights reserved.

Content

Component: IBM® Tivoli® Composite Application Manager for Applications V7.2.1.2: Tivoli® Composite Application Manager Agent for DB2 07.16.00.00
Component ID: 5724B96DO
Publication Date: 12 September 2022
Last modified date: 08 December 2023

Contents

1.0 General description
2.0 Download Package
3.0 Enhancements
4.0 Defect Fixes
5.0 Architecture and prerequisites
6.0 Image directory contents
7.0 Installation instructions
8.0 Additional installation information
9.0 Known problems and workarounds
10.0 Additional product information
11.0 Copyright and trademark information
12.0 Notices

1.0 General description

This fix provides the enhancements that are listed in the Enhancements section and resolves the defects listed in the Defect Fixes section also includes the superseded fixes listed in section 4.1 below.

2.0 Download Package

IBM Tivoli Composite Application Manager Agent for DB2 07.16.00.00 can be downloaded from IBM Passport Advantage website by using the part number, M076PML.
 
IBM Tivoli Composite Application Manager for Applications V7.2.1.2: IBM Tivoli Composite Application Manager Agent for DB2 v7.1.6, Multiplatform, Multilingual (M076PML).
 
When this image file is downloaded from the IBM Software Support website or from Passport Advantage, the following rules apply:
  • You can install the image file locally on a system that hosts a licensed copy of IBM Tivoli Monitoring for Databases.
  • You can install the image file locally on a system that does not host a licensed copy of IBM Tivoli Monitoring for Databases.
  • You can populate agents to the depot.
  • You can deploy agents remotely to the existing or new installations.

3.0 Enhancements

  • Added 6.3.0.7-TIV-ITM-SP0012 ITM support for Db2 agent.
  • Added the KudGrantPermission script that auto-assigns all the required permissions to Db2 servers, tables, functions, and objects.
3.1 Currency support for new versions of OS platforms
  • Added currency support for Windows server 2022.
  • Added currency support for AIX 7.3.
  • Removed SUSE 10 and SUSE 11 support from V716 release onwards.
  • Added the KudGrantPermission script that auto-assigns all the required permissions to Db2 servers, tables, functions, and objects.

4.0 Defect Fixes

Defect: 144408
Abstract: Fixed watchdog issue on Windows platform for Db2 agent.
Defect: 146332
Abstract: Appropriate memory deallocation to avoid undefined behavior issues.
Defect: 146140
Abstract: Solved Application verifier and PageHeap errors.
Defect: 145812
Abstract: Fixed the crash issue due to memory corruption when Db2 agent terminates.
Defect: 145939
Abstract: Fixed Db2 agent crash issue at the time of mutex unlock operation.
Defect: 145562/145811
Abstract: Fixed Tivoli ITM Db2 agent abends issue during normal shutdown.
Defect: 146233
Abstract: Db2 agent generates large number of warnings in db2diagnostic log file while connecting to standby databases.
Defect: 146432
Abstract: Fixed Db2 agent crash issue while checking regex on Ubuntu 18 s390x.
4.1 Superseded fixes
7.1.5-TIV-ITM_DB2-FP0000

5.0 Architecture and prerequisites

5.1 Prerequisites for this fix pack None

6.0 Image directory contents

Electronic Part Number: ITCAM Apps Agent for Db2 M076PML.
This fix image contains the following files and directories:
  • AUTORUN.INF
  • DeployLnk.sh
  • [InstallITM]
  • [REPORTS]
  • install.sh
  • [license]
  • notices
  • silent_install.txt
  • [Deploy]
  • README.TXT
  • [WINDOWS]
  • kcirunas.cfg
  • non_ibm_license
  • silent_config.txt
  • [unix]

Note: If you are working in a UNIX environment, use install.sh file to install. If you are working in a Windows environment, you can choose setup.exe in the directory [WINDOWS].

7.0 Installation instructions

When this image file is downloaded from the IBM Software Support website or from Passport Advantage, the following rules apply:
  • You can locally install on a system that already hosts a licensed copy of IBM Tivoli Monitoring for Databases.
  • You can locally install on a system that does not already host a licensed copy of IBM Tivoli Monitoring for Databases.
  • You can populate agents to the depot.
  • You can remotely deploy agents to existing or new installations.
7.1 Before installing the fix
  • For this readme file, the symbol ‹ CANDLEHOME › is the IBM Tivoli Monitoring installation directory.
  • The default value for ‹ CANDLEHOME › is '/opt/IBM/ITM' on Unix or Linux systems.

    The default value for ‹ CANDLEHOME › is 'C:\IBM\ITM' on Windows systems.

  • If you customized the Monitoring Agent for Db2 ud.ini file on Unix/Linux system, this file needs be backed up before the fix installation. After this fix is installed, edit the latest ud.ini file and merge your modifications into this ud.ini file.
7.2 Local agent installation and update (including silent installation)

1. Transfer the appropriate archive file (M076PML.tar.gz or .iso) to a temporary directory on the system that contains the agent code to be updated. For this readme, the symbol <TEMP> represents the fully qualified path to this directory.
    Note: On Windows, the path includes the drive letter. 

2. Expand the archive file by using the tar command on UNIX systems or an unzip utility on Windows systems. It creates a directory structure that contains fixes for all of the supported platforms.

3. Use the procedures in the "IBM Tivoli Monitoring, Version 6.3 Installation and Setup Guide" to install the agent.

4. Use the procedures in the specific Database Monitoring Agent User's Guide to complete the installation and configuration.
 
5. The bit of agent binary after upgrade remains the same as pre-upgrade on x86 and 64bit Windows. It does not support 32bit upgrade to 64bit binary.

Note: Support for 32bit Db2 Agent on Windows is obsoleted.
The installer for current version can only be used to install or upgrade 64bit Windows Db2 Agent.

7.3 Remote agent update

1. Transfer the appropriate archive file (M076PML.tar.gz or .iso) to a temporary directory on the IBM Tivoli Enterprise Monitoring Server system. In this readme file, the symbol <TEMP> represents the fully qualified path to this directory.
Note: On Windows, the path includes the drive letter. 

2. Expand the archive file by using the tar command on UNIX systems or an unzip utility on Windows systems. It creates a directory structure that contains fixes for all the supported operating systems.

3. To add these bundles into the remote deploy depot, use the tacmd addBundles command found in $CANDLEHOME/bin on UNIX systems or in %CANDLE_HOME%\bin on Windows systems.

For more information on the tacmd addBundles command, see Appendix A. Commands reference of the "IBM Tivoli Monitoring Administrator's Guide."

On a UNIX system: the fix is expanded to <TEMP>/ M076PML:
     > $CANDLEHOME/bin/tacmd addBundles -i <TEMP>/M076PML/WINDOWS/Deploy -t ud -f
     > $CANDLEHOME/bin/tacmd addBundles -i <TEMP>/M076PML/unix -t ud -f 

     where:
        -i is the directory that contains the deployment bundles to be added to the depot.
        -t is the product code of the product to add, in this case ud represents the Monitoring Agent for Db2
        -f performs the actions without asking for confirmation

 On a Windows system: the fix is expanded to <TEMP>/M076PML:
    > %CANDLE_HOME%\bin\tacmd addBundles -i <TEMP>\M076PML\WINDOWS\Deploy -t ud -f
    > %CANDLE_HOME%\bin\tacmd addBundles -i <TEMP>\M076PML\unix -t ud -f 

     where:
        -i is the directory that contains the deployment bundles to be added to the depot. 
        -t is the product code of the product to add, in this case ud represents the Monitoring Agent for Db2
        -f performs the actions without asking for confirmation

4. To log in to the Tivoli Enterprise Monitoring Server and deploy the fix to the appropriate nodes where the agent is running, use the following tacmd commands.

For more information on the tacmd login and updateAgent commands, see Appendix A. Command reference of the "IBM Tivoli Monitoring Administrator's Guide."

On a UNIX system: 
    > $CANDLEHOME/bin/tacmd login -s <server>
                                -u <itmuser> 
                                -p <password>
                                   
    > $CANDLEHOME/bin/tacmd listSystems

    
The output shows the managed system name for the OS agent on the remote system to be updated. Use this value as the target of the tacmd updateAgent command.                                    
                                   
    > $CANDLEHOME/bin/tacmd updateAgent -t ud 
                                      -n <Managed system name>
                                      -v 07160000

On a Windows system:
    > %CANDLE_HOME%\bin\tacmd login -s <server>
                                    -u <itmuser> 
                                    -p <password>

    > %CANDLE_HOME%/bin/tacmd listSystems

The output shows the managed system name for the OS agent on the remote system to be updated. Use this value as the target of the tacmd updateAgent command.   
                                    
    > %CANDLE_HOME%\bin\tacmd updateAgent -t UD 
                                        -n <Managed system name>
                                        -v 07160000

                                          
If there are not prior version kud agent on remote system, then use the following tacmd addSystem command.
    
    > %CANDLE_HOME%\bin\tacmd addSystem -t UD 
                                      -n <Managed system name> 
                                      -p INSTANCE="<Db2 instance name>"           
                       
Note:
- The <Db2 instance name> is the Db2 instance name to be monitored on remote system.
- The component (-t) for the updateAgent command is specified as two characters (ud), not three characters (kud).
- The node (-n) for the updateAgent command is the managed system name of the operating system (OS) agent to be updated. The target node for an updateAgent command is always an OS agent.

-The following error might occur when executing the updateAgent command on Linux and UNIX endpoints; however, the agent is successfully updated. This error does not occur on Windows endpoints.

         KUICUA011I: Updating the UD agents.

         KUICUA015E: The updateAgent command did not complete because an error occurred.
         Refer to the following error returned from the server:

         The monitoring server encountered an error while updating the
         managed system type.

         The kuiras1.log file may provide more information about this error. 
         If you require further assistance resolving the error, contact IBM Software
         Support.

         A timeout occurred while waiting for an agent task to complete on
         {node name}.

         The agent task did not complete within the configured time out period.

         Verify that the target system is online. Increase the time out value and try the operation again.

7.4 Agent support update
Use the following steps to update the Tivoli Enterprise Monitoring Server, Tivoli Enterprise Portal Server, or Tivoli Enterprise Portal
 
Desktop:

 1. Transfer the appropriate archive file (M076PML.tar.gz or .iso) to the Tivoli Enterprise Monitoring Servers, IBM Tivoli Enterprise Portal Servers or Tivoli Enterprise Portal desktops. 
    
 2. Expand the archive file by using the tar command on UNIX systems or an unzip utility on Windows systems. 
On Unix/Linux systems,
      > tar -xvf M076PML.tar.gz

This step creates a directory structure that contains fixes for all of the supported platforms.

 3. Use the procedures in the "IBM Tivoli Monitoring, Version 6.3 Installation and Setup Guide."

 4. Use the procedures in the specific Database Monitoring Agent User's Guide to complete the installation and configuration.

 5. If the Tivoli Enterprise Monitoring Server being updated is remote (not a Hub Tivoli Enterprise Monitoring Server), then restart the Tivoli Enterprise Monitoring Server.

8.0 Additional installation information

8.1 Verifying the update

1. To verify that the agent is updated correctly, use the "tacmd" command to view the current version of the agent after the agent is restarted. You are required to log in to a Tivoli Enterprise Monitoring Server before viewing the agent version. 

For example:
On Unix/Linux systems, where $CANDLEHOME is the IBM Tivoli Monitoring installation directory. The default location is /opt/IBM/ITM

      > $CANDLEHOME/bin/tacmd login -s <server>
                                -u <itmuser> 
                                -p <password>

       where:
              <server> is the fully qualified hostname or IP address of the TEMS host
              <itmuser> is the user account on the TEMS host having sysadmin privileges
              <password> is the itmuser password.

      > $CANDLEHOME/bin/tacmd listSystems -t ud

 On Windows systems, where %CANDLE_HOME% is the IBM Tivoli Monitoring installation directory, the default location is C:\IBM\ITM
      > %CANDLE_HOME%\bin\tacmd login -s <server>
                                    -u <itmuser> 
                                    -p <password>

      where:
              <server> is the fully qualified hostname or IP address of the TEMS host
              <itmuser> is the user account on the TEMS host having sysadmin privileges
              <password> is the itmuser password.

      > %CANDLE_HOME%\bin\tacmd listSystems -t ud

When the agent update is successful, the agent version will be 07.16.00.00

Note: The component (-t) for the tacmd listSystems command is specified as two characters (ud), not three characters (kud).
 
2. To verify that the agent support files are updated correctly, use the kincinfo command on Windows systems or the cinfo command on Linux or UNIX systems to dump the component versions on each of the following systems: Tivoli Enterprise Portal Server, Tivoli Enterprise Monitoring Server, and Tivoli Enterprise Portal desktop. 

Note: The kincinfo and cinfo command output examples in the sections that follow show all components that can be updated.  If you do not have all of these components installed, then components that are not installed are not displayed in the output of these commands.  
    
    Sample output for the cinfo command on a UNIX or Linux systems
    --------------------------------------------------------------------------
    To validate that all components have been installed, run the following command:

     ./cinfo
     
    This command offers you four options on the CINFO menu shown in the example that follows.  Choose the option that meets your needs.
      

*********** Tue Sep  6 12:59:22 EDT 2022 ******************

User: root Groups: system bin sys security cron audit lp

Host name : paix875      Installer Lvl:06.30.07.18

CandleHome: /opt/IBM/ITM

***********************************************************

...Product inventory

ax      IBM Tivoli Monitoring Shared Libraries

         aix526  Version: 06.30.07.20

gs      IBM GSKit Security Interface

         aix526  Version: 08.00.55.17

jr      Tivoli Enterprise-supplied JRE

         aix526  Version: 08.07.05.00

ud      IBM Tivoli Composite Application Manager Agent for DB2

         aix526  Version: 07.16.00.00

ui      Tivoli Enterprise Services User Interface

         aix526  Version: 06.30.07.18

   Sample output of the kincinfo command on a Windows System
   --------------------------------------------------------------------------

   To validate that all components have been installed, run the following command:
    
       For example:
       > %CANDLE_HOME%\InstallITM\kincinfo -i
    
       >kincinfo -i

   kincinfo output:

   Windows: Monitoring Agent for DB2:

UD        KUD(64-bit) CMA/IBM Tivoli Composite Application Manager Agent for DB2

          WIX64 Version: 07.16.00.00 Build: 22361

UE        KUE(32-bit) CMA/Tivoli Enterprise Services User Interface Extensions

          WINNT Version: 06.30.07.13 Build: d2105a

UI        KUI(32-bit) CLI/Tivoli Enterprise Services User Interface

          WINNT Version: 06.30.07.18 Build: 

9.0 Known problems and workarounds

Problem: tacmd addBundles command fails for Solaris platform with command "./tacmd addBundles -i <installer_directory>/unix -t ud -p sol286"

Workaround: Use the command "./tacmd addBundles -i <installer_directory>/unix -t ud -p sol286 -n"

Problem: When the Db2 agent is stopped abruptly, the watchdog process fails to start the Db2 agent.
Workaround: Start the Db2 agent manually.

Problem: Db2 Agent configuration with instance owner fails in case of installation is secured by secureMain and agent configuration is done by root user for the first time.
The agent configuration fails with following error:
   **********
   KCIIN0524E Error attempting to build a merge file
   java.io.FileNotFoundException: /opt/IBM/ITM/tmp/.ud.rc (Permission denied)
   **********
   KCIIN0230E Unable to prompt for input...   
Workaround: When installation is secured by secureMain, manually assign write permission to the owner and the admin group for file .ud.rc.

Problem: User may face "Permission denied" issue while starting the agent after install/upgrade locally or remotely on Linux/Unix platforms.

Workaround: Provide "chmod -R 775 JRE config logs tmp auditlogs" permissions from candlehome directory.


Problem: If Customized SQL query contains the “order by” clause, then the relevant workspace does not show data and the Db2 server logs the following error in log file:
   The statement or command failed because it requires functionality 
   that is not supported on a read-enabled HADR standby database. 
   Reason code = "5".
Workaround: Db2 v11.1.0.0 server or its earlier versions do not support order by clause on standby. Hence Db2 agent cannot collect data for customized SQL workspace. To overcome this problem, you need to upgrade to Db2 v11.1.2.2 server that provides support for “order by” clause on standby.

For more information, see http://www-01.ibm.com/support/docview.wss?uid=swg1IT22612

    
Problem: When Db2 07.11.00.00 agent is pointed to ITM setup having Db2 07.16.00.00 support, HADR details workspace shows no data on UI.
Workaround: Upgrade Db2 agent from 07.11.00.00 to 07.16.00.00.

10.0 Additional product information

None

11.0 Copyright and trademark information

A current list of IBM trademarks is available on the web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

12.0 Notices

This information was developed for products and services offered 
in the United States. IBM may not offer the products, services, or
features discussed in this document in other countries. Consult 
your local IBM representative for information on the products and 
services currently available in your area. Any reference to an 
IBM product, program, or service is not intended to state or imply 
that only that IBM product, program, or service may be used. Any 
functionally equivalent product, program, or service that does not 
infringe any IBM intellectual property right may be used instead. 
However, it is the user's responsibility to evaluate and verify
the operation of any non-IBM product, program, or service.
IBM may have patents or pending patent applications covering subject
matter described in this document. The furnishing of this document 
does not grant you any license to these patents. You can send license
inquiries, in writing, to:
IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.
The following paragraph does not apply to the United Kingdom or 
any other country where such provisions are inconsistent with local law:
INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION 
"AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, 
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF 
NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
Some states do not allow disclaimer of express or implied warranties
in certain transactions, therefore, this statement may not apply to you.

Trademarks and service marks
------------------------------------
IBM, the IBM logo, and ibm.com are trademarks or registered trademarks of 
International Business Machines Corporation in the United States, other 
countries, or both. If these and other IBM trademarked terms are marked 
on their first occurrence in this information with a trademark symbol, 
these symbols indicate U.S. registered or common law trademarks owned by 
IBM at the time this information was published. Such trademarks may also 
be registered or common law trademarks in other countries. A current list 
of IBM trademarks is available on the Web at "Copyright and trademark 
information" at www.ibm.com/legal/copytrade
Java and all Java-based trademarks and logos are trademarks or registered 
trademarks of Sun Microsystems, Inc. in the United States, other 
countries, or both.
Linux is a registered trademark of Linus Torvalds in the United States,
other countries, or both.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of 
Microsoft Corporation in the United States, other countries, or both.
Unix is a registered trademark of The Open Group in the United States 
and other countries.
Other company, product, or service names can be trademarks or service 
marks of others.

Document change history

Version Date Description of change
1.0 12 September 2022 Initial Version
2.0 08 December 2023 Added the 'Download Package' section

[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JRN","label":"Tivoli Composite Application Manager for Applications"},"ARM Category":[{"code":"a8m500000008b8sAAA","label":"ITCAM-for-Applications-\u003EDB2 Agent Internal"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Product Synonym

KUD

Document Information

Modified date:
19 December 2023

UID

ibm16619669