Foglight® for DB2 LUW 5.9.5.10
Developed and tested for Foglight Management Server 5.9.2, 5.9.3, 5.9.4, and 5.9.5
Release Notes
December 2019
Welcome to Foglight for DB2 LUW
Resolved issues and enhancements
Getting started with Foglight for DB2 LUW
Foglight® for DB2 LUW utilizes a lightweight agent that provides real-time monitoring of all layers of an enterprise application (systems, networks, Internet, and databases) and captures pertinent infrastructure application usage, service, and availability level data used to continually assess the state of an DB2® LUW installation. Using this collected data, Foglight Management Server provides a multi-dimensional view of resource utilization for capacity planning, problem determination, and trend analysis, both real-time and historically.
These Release Notes cover the resolved issues, known issues, workarounds, and other important information about the 5.9.5.10 release of Foglight for DB2 LUW. Review all sections before starting the installation.
Version 5.9.5.10 contains the following new features and updates:
The following is a list of issues addressed and enhancements implemented in this release.
Defect ID |
Resolved Issue |
DB2FOG-503 |
Fixed an issue that the Storage Capacity in Whole Database - Summary dashboard should use average instead of sum. |
DB2FOG-501 |
Fixed an issue that the Top 10 Tablespaces are not ordered as expected. |
DB2FOG-491 |
Fixed an issue that the SQL Performance dashboard requires specific user role to display. |
DB2FOG-489 |
Fixed an issue that the Memory Utilization for DB2 instance memory pool showing bigger than 100%. |
DB2FOG-484 |
Fixed an issue that the Avg.Request Time calculation is wrong. |
DB2FOG-481 |
Fixed an issue that DB2 - Database Log Message Summary could not be triggered. |
DB2FOG-69 |
Fixed an issue that the auto storage size for database and partition level should be calculated by auto tablespace size. |
GVFOG-182 |
Fixed an issue that the Workload chart in Global view has different unit (sessions/s) from the one (seconds/s) in Overview. |
The following is a list of issues known to exist at the time of this release.
Defect ID |
Known Issue |
FOGDG-858 |
DB instance is still synchronized and displayed in FMS federation master even though it is stopped for some reason and not displayed in the FMS federation child. |
FOGDG-1030 |
Popup message is not clear enough when installing cartridge 5.9.4.10
on FMS version lower than 5.9.2. |
DB2FOG-511 |
Could not support TLSv1.2 in grant permission during the upgrade. |
DB2FOG-431 |
In Upgrade Wizard, when upgrade finishes (click "Finish"
button), there will be low chance that the page will navigate back to
the beginning of the Wizard. |
DB2FOG-428 |
If the monitored DB2 server is v9.7.0.10 or v9.7.0.11, the following metrics are not available: Memory Wait, Memory Wait Rate, pureScale Wait, pureScale Wait Rate, Total CPU Wait, Memory Wait (seconds), and pureScale Wait (seconds). |
DB2FOG-424 |
The popup message is not clear enough to tell the reason when it
fails to install cartridge 5.9.4.10 on FMS version lower than 5.9.2. |
DB2FOG-406 |
DB2 UnixAgentPlus needs to be deleted before adding new DB2 UnixAgent when upgrading DB2 cartridge to 5.9.4.10. |
DB2FOG-345 |
DB2 SQL Performance doesn't support DB2 version lower than v9.7.0.10 (excluding 9.7.0.10). |
DB2FOG-175 |
If you select either of DB_DB2, DB_DB2_UI, DB_Global_View_UI cartridges then click Reset on the Cartridge Inventory dashboard, the upgrade wizard will prompt again. Workaround: Do the following: 1. Navigate to the Administration > Rules & Notifications > Manage Registry Variables dashboard. 2. Search for "DB2_Is_Fglams_Required_Upgrade". 3. Change its value to "-1". |
DB2FOG-165 |
If your DB2 version is 10.1, granting user permission may fail due to inconsistent parameter(). |
DB2FOG-88 |
The Management Server 5.7.1 stops responding when clicking charts on the Tablespaces dashboard. Workaround: Upgrade the Management Server to 5.7.5 or later. |
DDB-5387 |
For DB2 version 9.7 and above, the following metrics are not available due to DB2 limitations: AGENT_USR_CPU_TIME_MS, AGENT_SYS_CPU_TIME_MS, LAST_RESET. |
DDB-5376 |
For DB2 version 9.7 and 10.1, some statistics information about db2 background processes is not collected due to DB2 limitation. |
DDB-5146 |
The DB2 installer does not support foreign languages on Windows
machine.
Once the agent was activated, the following errors may be occurred:
|
DDB-3669 |
The Foglight for DB2 LUW 5.6.5.5 Upgrade Wizard does
not support the upgrade of external agents if the Agent Manager is not
version 5.6.2 or later. |
DDB-2860 |
An Agent Manager that is installed on a Windows fail-over cluster as a service that runs on the active node cannot monitor databases that are located on the same cluster. This is an Agent Manager limitation. |
DDB-2745 |
The Memory Summary panel and the corresponding alarm display "null" when there are no child pools under a memory pool. |
DDB-2706 |
If you have a Foglight for DB2 LUW agent that has never been used to collect data and you upgrade to Foglight for DB2 LUW 5.6.4 or later, you will not be able to activate and use the agent seamlessly. To activate and use the Foglight for DB2 LUW agent seamlessly, you must first create an Infrastructure agent and then manually set up resource mapping for that agent. For information on how to create an Infrastructure agent, see the Infrastructure Cartridge documentation. For information on how to set up resource mapping, see the Foglight Administration and Configuration Help. |
DDB-2637 |
When the legacy Cartridge for DB2 LUW and Foglight for
DB2 LUW 5.5.x are installed on the same Foglight Management Server and
you upgrade the latter to Foglight for DB2 LUW 5.6.4 or later, the
online help for the legacy version is no longer available. |
DDB-2073 |
For DB2 version below 9.7, the CPU collected and displayed for a monitored instance is the CPU for only the monitored databases under that instance. The instance CPU does not include the CPU for any databases that are under the instance, and are not monitored. |
DDB-1671 |
When monitoring an instance running on Windows using a Foglight Agent Manager that is running on a non-Windows platform, open file descriptors are not closed correctly. Workaround: On the Foglight Agent Manager machine, the "description" limit is configured to "1024". This value should be defined as "unlimited" or to a larger number, for example "65535". |
GVFOG-60 |
The "Error executing script" error shows in the server log, if user clicks any tab or component on the Global View. |
GVFOG-37 |
The Databases dashboard does not appear after user upgrades the Foglight for DB2 LUW to 5.7.5.37 using SPM installer. |
N/A |
Need to wait for more than ten minutes between the upgrade of the Foglight Management Server and Foglight for DB2 LUW. |
N/A |
The tasks listed below cannot be accomplished from the central Foglight Management Server (the federation master):
|
N/A |
This release of Foglight for DB2 LUW supports adding databases to existing instances only using the Databases Management view in the Databases Administration dashboard. |
The following is a list of third party issues known to exist at the time of this release.
Defect ID |
Known Issue |
FOGDG-650 |
The Foglight Agent Manager (FglAM) failed to restart when upgrading DB Cartridge, which is due to "Could not obtain a deployment lock" error. Workaround: Perform the procedure described in the Knowledge Article 266110. |
DDB-1683 |
WMI-related issue Problem: WMI support is affected by the firewall on versions of Windows prior to Windows 7. Workaround: For Windows versions prior to Windows Server 2008/Vista, use the following steps:
For Windows Vista and Windows Server 2008: According to Microsoft (http://support.microsoft.com/kb/929851), the default dynamic port range for TCP/IP has changed in these versions. The new default start port is 49152 and end port is 65535. Subsequently, monitoring instances that run under these operation systems can be carried out by using either one of the following options:
|
N/A |
Monitoring a DB2 instance which resides on Windows Server 2008R2 or higher requires the following workaround:
|
Defect ID |
Known Issue |
N/A |
Some base values are not updated when using the Win32_PerfRawData_PerfDisk_LogicalDisk WMI class to calculate performance data in Windows Vista or in Windows Server 2008, because this class does not contain the PercentDiskTime_Base metric. Workaround: A hotfix is available on Microsoft's Web site, at http://support.microsoft.com/kb/961435/en-us. |
To upgrade Foglight for DB2 LUW, follow the instructions in the Managing DB2 Database Systems User and Reference Guide.
A direct upgrade to Foglight for DB2 5.9.5.10 is only available from version 5.7.5.x or later. Customers that are running 5.7.x of the product must first upgrade to version 5.7.5.x and then upgrade to version 5.9.5.10. A direct upgrade to Foglight for DB2 5.7.x is only available from version 5.5.8 or later. Customers that are running earlier versions of the product must first upgrade to version 5.5.8 and then upgrade to version 5.7.x.
For example, if your Foglight for DB2 LUW is version 5.5.8 and you are going to upgrade to version 5.9.5.10, the upgrade path will be 5.5.8 > 5.7.x > 5.7.5.x (or later) > 5.9.5.10.
Foglight for DB2 LUW 5.9.5.10 requires:
The following Foglight product versions and platforms are compatible with this release.
Product Name |
Product Version |
Platform |
Foglight Management Server |
5.9.2 5.9.3 5.9.4 5.9.5 |
All platforms supported by these versions of the Foglight Management Server |
Foglight Agent Manager |
5.9.2 5.9.3 5.9.4 5.9.5 |
All platforms supported by these versions of the Foglight Agent Manager |
Before installing Foglight for DB2, ensure your system meets the following minimum hardware and software requirements:
Before installing Foglight for DB2 LUW, ensure that your system meets the hardware and software requirements detailed in Foglight System Requirements and Platform Support Guide.
Customers running large deployments (that is, with more than 20 agents) should consult the Foglight for DB2 LUW Hardware Sizing Guide.
The following UNIX programs must be accessible to the user logged on to the UNIX and Linux computers:
In addition, the following platform-specific programs must be available:
For information on the required privileges, refer to the Foglight for DB2 LUW Getting Started Guide.
The operating system platforms and versions of DB2 that are supported for monitoring by Foglight for DB2 LUW are the following.
Operating System | Version | OS Architecture | 32-bit | 64-bit | DB2 LUW Version | |||||
ESE version 9.5 | ESE version 9.7 | Version 9.8 (pureScale) | Version 10.1 | Version 10.5 | Version 11.1 | |||||
Linux Red Hat Enterprise |
5.x 6.x 7.x |
IBM z Systems | √ | √ | √ | √ | √ | √ | √ | |
POWER System - Big Endian | √ | |||||||||
x86-64, x86-32 | √ | √ | ||||||||
Suse Linux Enterprise | 10 |
x86-64 x86-32 |
√ | √ | √ | √ | √ | √ | √ | √ |
11 | ||||||||||
12 | ||||||||||
Ubuntu Linux | 8.04 LTS | x86-64 | √ | √ | √ | √ | √ | √ | ||
10.04 LTS | ||||||||||
12.04 LTS | ||||||||||
14.04 LTS | ||||||||||
14.10 | ||||||||||
Microsoft Windows | Server 2003 Server 2003 R2 |
x86-64 | √ | √ | √ | √ | √ | |||
Server 2008 Server 2012 Server 2012 R2 Server 7 Server 8 |
x86-64 | √ | √ | √ | √ | √ | √ | |||
Windows 7 Windows 8 |
x86-32 | √ | √ | √ | √ | √ | √ | |||
Windows 8.1 | x86-64, x86-32 | √ | √ | √ | √ | √ | √ | |||
Solaris | 9 | SPARC | √ | √ | √ | |||||
10 |
SPARC x86-64 |
√ | √ | √ | √ | √ | √ | |||
11 | SPARC | √ | √ | √ | √ | |||||
AIX | 5.3 | POWER System - Big Endian | √ | √ | √ | |||||
6.1 7.1 |
POWER System - Big Endian | √ | √ | √ | √ | √ | √ | √ |
Note: DB2 Version 9.1.0 is no longer supported.
Foglight for DB2 LUW supports the monitoring of instances that are installed on Linux on System z. The supported monitored instance versions are the same as specified in the list above for the Linux platform.
Note: IBM® DB2® pureScale is currently not supported for Linux on IBM System z.
Foglight for DB2 LUW supports monitoring an environment configured to use HADR by creating agents to monitor each one of the nodes separately (applies for both primary nodes and secondary).
Foglight for DB2 LUW supports a physical partition. When monitoring a physical partition, ensure you create the agent using the agent installer on the coordinator host.
Foglight for DB2 LUW supports monitoring a workgroup edition instance.
Foglight for DB2 LUW supports monitoring an instance that is installed in an OS cluster environment.
To enable monitoring, follow the instructions on “Host connectivity settings”
screen in the installation wizard:
• Mark the "instance residing on an OS
cluster".
• Make sure the virtual host name point to the virtual host name.
This name will be used to install the DB2 agent and the IC agent.
Foglight for DB2 LUW supports monitoring a pureScale environment (except on Linux on IBM System z).
This section provides a list of references which address the most commonly faced issues relating to remote connectivity, allowing for easy troubleshooting using the vendor's information knowledgebase:
Foglight includes a licensing capability that restricts access to those features that are defined in the license. Any Management Server installation requires a license that grants access to server-specific parts of the browser interface and the features associated with them. Foglight cartridges are also license-protected. While some cartridges are covered by the base Foglight license (such as Foglight Agent Manager cartridges and the Foglight for Infrastructure), others may require an additional license.
Foglight for DB2 is covered by the base Foglight license that allows cartridges to be installed.
To activate a trial or a purchased commercial license:
The Foglight for DB2 release package contains the following:
Refer to the Foglight for DB2 LUW Getting Started Guide for installation instructions and prerequisites.
Determine your environment hardware requirements using the Foglight for DB2 LUW Hardware Sizing Guide.
Additional information is available from the following:
This section contains information about installing and operating this product
in non-English configurations, such as those needed by customers outside of
North America. This section does not replace the materials about supported
platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. In this
release, all product components should be configured to use the same or
compatible character encodings and should be installed to use the same locale
and regional options. This release is targeted to support operations in the
following regions: North America, Western Europe and Latin America, Central and
Eastern Europe, Far-East Asia, Japan.
This release has the following
known capabilities or limitations: The server will be enabled for Global
Operation, but not localized to any particular locale.
We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation™.
Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.
For sales or other inquiries, visit https://www.quest.com/company/contact-us.aspx/.
Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.
The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:
Quest, the Quest logo, Foglight, and Join the Innovation are trademarks and registered trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest Software trademarks, please visit our website at www.quest.com/legal. Red Hat, JBoss, the JBoss logo, and Red Hat Enterprise Linux are registered trademarks of Red Hat, Inc. in the U.S. and other countries. CentOS is a trademark of Red Hat, Inc. in the U.S. and other countries. Fedora and the Infinity design logo are trademarks of Red Hat, Inc. Microsoft, .NET, Active Directory, Internet Explorer, Hyper-V, Office 365, SharePoint, Silverlight,SQL Server, Visual Basic, Windows, Windows Vista and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. AIX, IBM, PowerPC, PowerVM, and WebSphere are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. Java, Oracle, Oracle Solaris, PeopleSoft, Siebel, Sun, WebLogic, and ZFS are trademarks or registered trademarks of Oracle and/or its affiliates in the United States and other countries. SPARC is a registered trademark of SPARC International, Inc. in the United States and other countries. Products bearing the SPARC trademarks are based on an architecture developed by Oracle Corporation. OpenLDAP is a registered trademark of the OpenLDAP Foundation. HP is a registered trademark that belongs to HewlettPackard Development Company, L.P. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Novell and eDirectory are registered trademarks of Novell, Inc., in the United States and other countries. VMware, ESX, ESXi, vSphere, vCenter, vMotion, and vCloud Director are registered trademarks or trademarks of VMware, Inc. in the United States and/or other jurisdictions. Sybase is a registered trademark of Sybase, Inc. The X Window System and UNIX are registered trademarks of The Open Group. Mozilla and Firefox are registered trademarks of the Mozilla Foundation. IOS is a registered trademark or trademark of Cisco Systems, Inc. and/or its affiliates in the United States and certain other countries. Apple, iPad, iPhone, Mac OS, Safari, Swift, and Xcode are trademarks of Apple Inc., registered in the U.S. and other countries. Ubuntu is a registered trademark of Canonical Ltd. Symantec and Veritas are trademarks or registered trademarks of Symantec Corporation or its affiliates in the U.S. and other countries. OpenSUSE, SUSE, and YAST are registered trademarks of SUSE LCC in the United States and other countries. Citrix, AppFlow, NetScaler, XenApp, and XenDesktop are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. PostgreSQL is a registered trademark of the PostgreSQL Global Development Group. MariaDB is a trademark or registered trademark of MariaDB Corporation Ab in the European Union and United States of America and/or other countries. Intel, Itanium, Pentium, and Xeon are trademarks of Intel Corporation in the U.S. and/or other countries. Debian is a registered trademark of Software in the Public Interest, Inc. OpenStack is a trademark of the OpenStack Foundation. Amazon Web Services, the "Powered by Amazon Web Services" logo, and "Amazon RDS" are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries. Infobright, Infobright Community Edition and Infobright Enterprise Edition are trademarks of Infobright Inc. POLYCOM®, RealPresence® Collaboration Server, and RMX® are registered trademarks of Polycom, Inc. All other marks and names mentioned herein may be trademarks of their respective companies.