Foglight for DB2 (Cartridge) 7.2.0

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 7.2.2.10 release of Foglight for DB2 LUW. Review all sections before starting the installation.

New in this release

•

Add support for Remove literals from Query text. The default is false.

•

Change on-demand collections to use callback instead of RMI for increased security. Can close on-demand ports.

Known issues

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

General Issues

Table 1. General issues

Issue ID

Known issue

FOG-6864

On-demand dashboards does not work on Federation Master.

Workaround: View the data on the child FMS or enable RMI on the Federation Master by changing the value of “DBWC_Use_Callback_Instead_RMI” registry variable to “false“ followed by disabling and enabling the Oracle DB UI cartridge.

FOM-1008

Setting User Defined Collection Credentials for DB2 will fail, when the DB2 agent name contains the character @.

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-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-165

If your DB2 version is 10.1, granting user permission may fail due to inconsistent parameter().

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:

Navigate to the Administration > Rules & Notifications > Manage Registry Variables dashboard.

Search for “DB2_Is_Fglams_Required_Upgrade”.

Change its value to “-1”.

DB2FOG-345

DB2 SQL Performance doesn't support DB2 version lower than v9.7.0.10 (excluding 9.7.0.10).

DB2FOG-406

DB2 UnixAgentPlus needs to be deleted before adding new DB2 UnixAgent when upgrading DB2 cartridge to 5.9.4.10.

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-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-431

In Upgrade Wizard, when upgrade finishes (click the 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.

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

On the navigation panel, navigate to Administration > Cartridges > Cartridge Inventory.

Select the check box next to the DB2_OnlineHelp cartridge.

Click Disable to disable the cartridge.

Click Enable to enable the cartridge.

When you are finished, both online help versions are displayed in the action panel.

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.