Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.4.20 - 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-75

It displays wrong sorting order when sorting by column "Up Since" in the Global View table.

GVFOG-159

Enhance performance for "Database SQL PI" dashboard in federator FMS console.

GVFOG-165

Enhance the performance of dashboards when many DB instances are being monitored.

GVFOG-166

Global View displays no data under some circumstances.

GVFOG-167

It encounters slow response of dashboards due to too many DB2 debug logs generated.

GVFOG-176

Databases - SQL PI dashboard sometimes displays blank in the Federation master of Foglight Server.

DB2FOG-374

Enhance Top SQL table to drill down from each SQL statement.

DB2FOG-460

Enhance FMS performance by filtering out all the temp tables in Top Tables Collection.

 

Issues also resolved in version 5.9.4.10

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

Defect ID

Resolved Issue

DB2FOG-151

Fixed the memory issue on current agents dashboard when DB2 server version is higher than v9.7.

DB2FOG-160

It failed to create UnixAgent to monitor AIX host when setting up DB2 monitoring agent.

DB2FOG-228

It displays database number instead of instance number on the DB2 tile of Overview page.

DB2FOG-245

It displays incorrect value of total utilization in the warning message when clicking Global View > Summary > Active Log.

DB2FOG-258

The drilldown link under Global View > Whole Instance > CPU pop-up page is invalid.

DB2FOG-273

"DB2 - Database Log message" alarm is triggered falsely when the invoke switch is configured as OFF in Administration > Diagnostic Log.

FOGDG-785

The error message showed up on User Level Access page after adding a new user.

 


Known issues

Known issues

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.
Workaround: Click “Info” icon on the right corner of the page and see the warning message.

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.
Workaround:
In fact the upgrade has already been finished after the first upgrade process. We can directly cancel the second upgrade process. Then, we can validate:
- In Database GlobalView, there should be no "Upgrade Required" displayed.
- In Agent Status, the agents' version should be updated.

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.
Workaround: See the warning message on the right corner of the page.

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

  • 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

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:

  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 2008R2 or higher 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 5.9.4.20 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.4.20. 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.4.20, the upgrade path will be 5.5.8 >  5.7.x  > 5.7.5.x (or later) > 5.9.4.20.


Foglight for DB2 LUW 5.9.4.20 requires:

  • Management Server version 5.9.2, 5.9.3, or 5.9.4
  • Agent Manager version 5.9.2, 5.9.3, or 5.9.4

 

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

All platforms supported by these versions 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.9.2

5.9.3 

5.9.4

All platforms supported by these versions of the Foglight Agent Manager

 


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating