Release Notes
Abstract
Readme file for 7.1.6-TIV-ITM_DB2-FP0000 release.
© Copyright International Business Machines Corporation 2023.
All rights reserved.
Content
Contents
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
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.- 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
KudGrantPermissionscript that auto-assigns all the required permissions to Db2 servers, tables, functions, and objects.
- 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
Abstract: Fixed watchdog issue on Windows platform for Db2 agent.
Abstract: Appropriate memory deallocation to avoid undefined behavior issues.
Abstract: Solved Application verifier and PageHeap errors.
Abstract: Fixed the crash issue due to memory corruption when Db2 agent terminates.
Abstract: Fixed Db2 agent crash issue at the time of mutex unlock operation.
Abstract: Fixed Tivoli ITM Db2 agent abends issue during normal shutdown.
Abstract: Db2 agent generates large number of warnings in db2diagnostic log file while connecting to standby databases.
Abstract: Fixed Db2 agent crash issue while checking regex on Ubuntu 18 s390x.
5.0 Architecture and prerequisites
https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=84E377F00ABF11E6B4A6CF14C90731CD&osPlatforms=AIX|HP|IBM%20i|Linux|Solaris|Windows&duComponentIds=S001&mandatoryCapIds=62|5&optionalCapIds=30|71|45|16|69
6.0 Image directory contents
ITCAM Apps Agent for Db2 M076PML.AUTORUN.INFDeployLnk.sh[InstallITM][REPORTS]install.sh[license]noticessilent_install.txt[Deploy]README.TXT[WINDOWS]kcirunas.cfgnon_ibm_licensesilent_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
- 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.
- 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.inifile on Unix/Linux system, this file needs be backed up before the fix installation. After this fix is installed, edit the latestud.inifile and merge your modifications into thisud.inifile.
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.
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.
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
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
None11.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 |
Product Synonym
KUD
Was this topic helpful?
Document Information
Modified date:
19 December 2023
UID
ibm16619669