Chat now with support
Chat mit Support

Foglight for DB2 (Cartridge) 5.7.5.41 - Release Notes

Resolved issues and enhancements

Resolved issues and enhancements

The following is a list of issues addressed and enhancements implemented in this release.

Defect ID

Resolved Issue

GVFOG-54

Fixed issue where some dashboards, copyright, and URL addresses have not been rebrand to Quest Software Inc.

GVFOG-50

Fixed issue where DB Groups Grid in the DB Global View could not be restored after disabling or upgrading the previous GlobalView cartridge.

GVFOG-33

Updated the Supported Foglight Version number on the Databases > Administration dashboard.

DB2FOG-91

Fixed issue where Ignore List Group could not be added.

DB2FOG-89

Fixed issue where there was no snapshot list when clicking charts on the Top SQL dashboard.

DB2FOG-86

Failed to create a DB2 agent which switches were inactive.

DB2FOG-85

Changed to read the value of HADR Role from database_usability, if the value of hadr_activity was null.

DB2FOG-84

Changed the default value of dtNumRowsToFetchFromDB and agmMaxRowsToSubmit to 50 and 500 separately.

DB2FOG-50

Fixed issue where systemID collection was disabled by the IC agent created using the DB wizard. .

DB2FOG-35

Fixed issue where the unit in the Memory > Memory Summary > Pool Breakdown chart was incorrect.

DDB-5502

Updated instance names to ensure that all instance names are consistent on various dashboards.

DDB-5489

Clicking DB2 Permissions leads to the Getting Started page.

DDB-5457

Fixed issue where the format of Last Modified column in the DB2-Rules.csv file was incorrect.

DDB-5453

Added the following links to product videos: How to set up a DB2 agent for Monitoring and How to upgrade to DB2 cartridge VERSION 5.7.5.

DDB-5475

Fixed issue where the current agents (session) logon time was incorrect.

NGV-497

Users without the access to an instance has been blocked from viewing the Instance dashboard.

 


Known issues

Known issues

The following is a list of issues known to exist at the time of this release.

Defect ID

Known Issue

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.

DB2FOG-67 DB agents need be re-upgraded after upgrading the Foglight Management Server.
Workaround: Make sure to wait for more than 10 minutes between upgrade of the Foglight Management Server and Foglight for DB2 LUW.
GVFOG-37 The Databases dashboard does not appear after user upgrades the Foglight for DB2 LUW to 5.7.5.37 using SPM installer.
GVFOG-60 The "Error executing script" error shows in the server log, if user clicks any tab or component on the Global View.
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.
The DB2 agent should be created manually through Foglight Administration > Agent Status.
The fields that needs to be modified are:

  • DB2 Host - the Physical Host the DB2 instance resides on
  • Port - DB2 port
  • User and Password for the DB2 instance
  • Monitored DB's - the associated Databases **The monitored databases secondary properties should be cloned first.
  • Monitored members - the associated partitions\members **The monitored members secondary properties should be cloned first.
  • DB2 home - DB2 home of the monitored instance

Once the agent was activated, the following errors may be occurred:

  • The agent will fail to detect standby (HADR) databases, so our collections will fail for those databases.
  • DB2_Log_File_Size collection will fail
  • The agent will fail to detect number of active databases, so the metric 'con_local_dbases' in the instance activity will not be set
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.
Workaround: Upgrade to Foglight Management Server 5.6.4 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.
Workaround:
1. On the navigation panel, navigate to Administration > Cartridges > Cartridge Inventory.
2. Select the check box next to the DB2_OnlineHelp cartridge.
3. Click Disable to disable the cartridge.
4. Click Enable to enable the cartridge.
When you are finished, both online help versions are displayed in the action panel.
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-1767 Monitoring a pureScale environment does not display locks when they are performed between two members (for example, one member is locking another member).

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".

DDB-1567

Monitored environments with tablespace that have Korean characters in their name, will not be displayed correctly in the tablespaces dashboard graph.

N/A

The tasks listed below cannot be accomplished from the central Foglight Management Server (the federation master):

  • Creating agents
  • Administering agents
  • Viewing a monitored instance from the federation master which is defined under two or more federation child server.

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.


Third party known issues

The following is a list of third party issues known to exist at the time of this release.

Cartridge-related issues

Defect ID

Known Issue

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:

  1. Open TCP port: 135.
    WMI by default uses the port range 1024 to 5000.

  2. Open up a range of ports above port 5000.
    Port numbers below 5000 may already be in use by other applications and could cause conflicts with your DCOM applications.
    It is recommended to have at least 100 ports opened, as several system services rely on these RPC ports to communicate with each other.

  3. Add the registry key, including additional ports.

    • Use the RPCCfg.exe (Windows Resource Kits) by running: rpccfg.exe -pe 5009-5009 -d 0

    • Manually add the registry keys under: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Rpc\Internet

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:

  • Configure the firewalls to allow traffic between servers in the dynamic port range of 49152 through 65535 (less secure).

  • Limit the port range that is used in each monitored server.

N/A

Monitoring a DB2 instance which resides on Windows Server 2008 R2 requires the following workaround:

  1. Browse to http://www.quest.com/support/ and log in.

  2. Implement the instructions provided in solution SOL65870.

Windows-related issues

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.

 


Upgrade and compatibility

Upgrade and compatibility

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 LUW 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.
This version supports a minimum Foglight version 5.7.0 and minimum Agent Manager version 5.8.0.

The Foglight for Infrastructure agent will not be created in the following scenarios:

  • If the agent is configured to use an IP address instead of the host name
  • If the agent was not configured to monitor the operating system prior to the upgrade
  • If the agent's host is currently monitored by the legacy OS cartridge (prior to version 5.6.4)

 

The following Foglight product versions and platforms are compatible with this release. 

Product Name

Product Version

Platform

Foglight Management Server 5.7.0 and later All platforms supported by this version of the Foglight Management Server
Foglight Agent Manager
Note: The monitoring agents available in this version of Foglight for DB2 LUW support the Agent Manager HA failover mode. For more information about this mode, see the Agent Manager Guide.
5.8.0 and later All platforms supported by this version of the Foglight Agent Manager

 


System requirements

System requirements

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 50 Oracle instances) should consult the Foglight for DB2 LUW Hardware Sizing Guide.

UNIX server and programs

The following UNIX programs must be accessible to the user logged on to the UNIX and Linux computers:

  • On all platforms: df, du, awk, iostat, vmstat, uptime, netstat, sed, ps, uname, ls -l

In addition, the following platform-specific programs must be available:

  • On the Linux platform: /proc/vmstat, /proc/net/dev, free, /proc/cpuinfo, getconf
  • On the Solaris platform: /usr/sbin/prtconf, mpstat, pagesize, psrinfo
  • On the AIX platform: lsattr, lsdev, pagesize, bindprocessor, lsdev, oslevel
  • On the HP-UX specific platform: bdf (instead of df), sar, /var/adm/syslog/syslog.log, /usr/sbin/ioscan, getconf, /swapinfo, InfoLog (needs to be enabled)

Required privileges

For information on the required privileges, refer to the DB2 Getting Started Guide.

Supported platforms

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 IBM z Systems   x x x x x x x
6.x POWER System - Big Endian   x
7.x x86-64, x86-32 x x
Suse Linux Enterprise 10 x86-64
x86-32
x x x x x x x x
11
12
Ubuntu Linux 8.04 LTS x86-64   x x x   x x x
10.04 LTS
12.04 LTS
14.04 LTS
14.10
Microsoft Windows Server 2003
Server 2003 R2
x86-64 x x x x   x    
Server 2008
Server 2012
Server 2012 R2
Server 7
Server 8
x86-64   x x x   x x x
Windows 7
Windows 8
x86-32 x   x x   x x x
Windows 8.1 x86-64, x86-32 x x   x   x x x
Solaris 9 SPARC   x x x        
10 SPARC
x86-64
  x x x   x x x
11 SPARC   x       x x x
AIX 5.3 POWER System - Big Endian x x   x        
6.1
7.1
POWER System - Big Endian   x x x x x x x

Note: DB2 Version 9.1.0 is no longer supported.

Linux on IBM System z support

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.

HADR support

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).

Physical partition

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.

Workgroup edition

Foglight for DB2 LUW supports monitoring a workgroup edition instance.

OS Cluster support

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.

pureScale support

Foglight for DB2 LUW supports monitoring a pureScale environment (except on Linux on IBM System z).

 


Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen